Using worksheets at a form but formulas are not working

[evilthorne]

I made a "form" up with pull down menus and named columns. I'm hoping to use
this as a form system for customers. My problem is that when I copy the
orignal worksheet and put it in a worksheet in the same workbook the formulas
keep refering back to the copied worksheet.

How do I make the formulas only refer to the worksheet that the data is in?
I would like to be able to just keep one orignal and then copy and rename
that worksheet for every new customer.

Thanks

 

[FloMM2]

evilthorne,
Once you have your worksheet setup the way you want it. Columns width, row
height, drop down lists, and formulae are all set. Save the workbook as a
template.

Select "File", select "Save As". In the window that pops up, at the bottom,
select the down triangle in "Save as type:". The last selection is "Template
(*.xlt)", this is what you want. Make sure you name it something easy to
recall, and where you save it to. The default is to save it in a "Templates"
folder, this may or may not be where you want it.
hth

 

[evilthorne]

Thanks I'll try that as well. I ended up just removing the names and using
cell values and it fixed it that way as well.