| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| moving formulas from one sheet to another | Excel Discussion (Misc queries) | |||
| moving informatiion from one sheet to a total sheet | Excel Discussion (Misc queries) | |||
| Moving cells without changing their formulas | Excel Worksheet Functions | |||
| Moving Formulas | Excel Discussion (Misc queries) | |||
| Moving formulas | Excel Worksheet Functions | |||
Linear Mode
