n/m - found the answer!

thanks!

On Thu, 17 Feb 2005 09:02:44 -0800, William Bowen
<[EMAIL PROTECTED]> wrote:
> I have the following formula in cell G2 in a spreadsheet.
> 
> =CONCATENATE(B2,"-",C2,"-",D2,"-",E2,"-",F2)
> 
> It works as expected on row 2.
> 
> Now here is the problem. If I add a Row 3, I have to enter (usually
> copy/paste) this formula again. and then edit the formula to be:
> 
> =CONCATENATE(B3,"-",C3,"-",D3,"-",E3,"-",F3)
> 
> and so on for every new row.
> 
> Now, here's what I'd like to be able to do: I'd like to be able to set
> up a "template" row that contains a generic version of this formula so
> that I don't have to waste time doing it. Is this possible? I could do
> this in SQLServer and write an interface, but I don't really have the
> time to devote to that.
> 
> Any help would be greatly appreciated.
> 
> TIA

-- 
will


"If my life weren't funny, it would just be true;
and that would just be unacceptable."
- Carrie Fisher

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:5:147497
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to