Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Find & Replace a link to another worksheet in the same workbook

I need to create a "Monthly Summary" (in it's own workbook) from many
workbooks on a monthly basis. Each source workbook contains monthly tabs.
The January Summary is linked to each source workbook, cell by cell (for
totals). Rather than do this manually each month, I would like to copy the
January summary worksheet, and then do a "find and replace" - in other words,
just replace the "word" January with the word February, so my new summary
goes and retrieves the totals from the February worksheets. Data in both
source worksheets are in the same cells.

There's got to be a way. Any suggestions. Thanks so much
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 20
Default Find & Replace a link to another worksheet in the same workbook

Have you tried to copy the worksheet then use menu item Edit | Replace,
with option "Look In: Formulas" chosen? Seems like it would work,
unless I'm not understanding your questions.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find and replace, within workbook Matt Carter Excel Discussion (Misc queries) 1 November 22nd 05 01:55 AM
Inserting Filtered RC cell information into other worksheets Dennis Excel Discussion (Misc queries) 10 July 30th 05 01:54 AM
Find and Replace Formula Links Werner Rohrmoser Excel Worksheet Functions 0 June 9th 05 12:13 PM
how to find and replace a symbol in my worksheet TC Excel Discussion (Misc queries) 3 May 3rd 05 06:29 PM
VB Find and Replace Bony_Pony Excel Worksheet Functions 10 December 6th 04 06:45 PM


All times are GMT +1. The time now is 09:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"