Using worksheets at a form but formulas are not working


E

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
 
Ad

Advertisements

F

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
 
Ad

Advertisements

E

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top