Thread: Copying formulas to a different file without path in the formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phillycheese5
 
Posts: n/a
Default 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 With QuoteReply With Quote