Moving Formulas to a different sheet
 

Hi
In Sheet1 I have a database and I have created a template with formulas
which pull up information from that database, now I want to keep the database
in Sheet1 and move the template to Sheet2 but I want to link the values in
Sheet1 to the formulas that I have in Sheet2.

Does make sence?
Is it possible?

Thanks

Moving Formulas to a different sheet
 

Hazarding a guess. Try Cut n Paste. Eg Cut out your "template area" in
Sheet1, then paste into Sheet2. Leave it to Excel to adjust the formulas
automatically.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,400 Files:356 Subscribers:53
xdemechanik
---
"Farias" wrote:
In Sheet1 I have a database and I have created a template with formulas
which pull up information from that database, now I want to keep the database
in Sheet1 and move the template to Sheet2 but I want to link the values in
Sheet1 to the formulas that I have in Sheet2.

Does make sense?
Is it possible?

Thanks