You could easily generate this using ColdFusion while outputting an HTML table.
However, in Excel, you should be able to click the little black box in the bottom-right corner of a highlighted cell and drag it down. The cell references in the formula should update to the new location. Is that not what it is doing? M!ke -----Original Message----- From: William Bowen [mailto:[EMAIL PROTECTED] Sent: Thursday, February 17, 2005 11:03 AM To: CF-Community Subject: An excel question 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:147601 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=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54