Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Permanent Reference
I have a list of data on Sheet1. I would like to pull these (using a
formula) to Sheet2. Further, I would like the data to remain in Sheet2 even if I delete the information in Sheet1. Is there any way I can write a formula to accomplish this? I know that copying and pasting "values" will do the trick but I would like to use a formula. I have tried using intentional circular references (like with a timestamp) but to no avail. Help? Sincerely, Doug |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
How to have a variable cell reference across sheets? | Excel Discussion (Misc queries) | |||
MIN Function w/ variable address reference | Excel Worksheet Functions | |||
Flexible Cell Reference | Excel Discussion (Misc queries) | |||
Cell Reference Math | Excel Worksheet Functions |