Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying formulas to a different file without path in the formula?
I am trying to copy a whole page that contains formulas to another file. The
formulas in the other file end up with the path from the original file. Is there a way to get around this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying formulas to a different file without path in the formula?
The easiest way that I've used is find and replace all. If you leave the "replace all" box blank, it will do just that in the replacement. That will make the formulas reference the current file you're in. Hope that helps. Phillycheese5 -- Phillycheese5 ------------------------------------------------------------------------ Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196 View this thread: http://www.excelforum.com/showthread...hreadid=498442 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying formulas in vba | Excel Discussion (Misc queries) | |||
Can I concatenate text in cells to make a working formula? | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Copy and Paste Formula Without the linked file path | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions |