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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Permanent Reference
Sorry, but you've already found what's probably the most efficient way of
doing this without resorting to VBA and a macro to do the copying. You can either have a value or a formulat that gives a value in a cell, not both. "Huber57" wrote: 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 |
Reply |
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 |