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

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" wrote:

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

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.

"FloMM2" wrote:

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" wrote:

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