Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy results and then remove formula
Is it possible to have a cell or range of cells on one worksheet refer back to a range of cells on another page, to copy the text in the second page and then remove the formula that performed this task?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy results and then remove formula
Use a macro. Use the macro recorder to copy the values
across to the second sheet. Re-run the macro as needed. If you want the macro to automatically update every time you change the original worksheet, use the following macro example: Public Sub Auto_Open() Worksheets("sheet1").OnEntry = "CopyValues" end sub Public Sub CopyValues() Macrostuff that does the copying you need end sub The auto_open macro runs at the open of the workbook. The OnEntry function calls the macro CopyValues every time you change a cell value in sheet1 (you can refine this by running it against a named range, also). Note: the OnEntry function is /not/ triggered when values are pasted into the worksheet. If you modify the data by pasting it in, you'll have to manually trigger the macro. Hope this helps kpd -----Original Message----- Is it possible to have a cell or range of cells on one worksheet refer back to a range of cells on another page, to copy the text in the second page and then remove the formula that performed this task? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove #n/a in vlookup to sum results | Excel Discussion (Misc queries) | |||
How to copy 2007 excel file formula results into a 2003 Excel file | Excel Discussion (Misc queries) | |||
Remove Negative Signs from Formula Results | Excel Worksheet Functions | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
copy avg results | Excel Discussion (Misc queries) |