Creating an Editing Macro

[Ted]

I have created two workbooks that are linked.

Workbook 1. Contains multiple worksheets broken down by
month, each worksheet has multiple rows broken down by
month.

Workbook 2. Contains multiple worksheets broken down by
month, each worksheet has cells linked to specific cells
in Workbook 1. I need to create a macro that allows me to
edit the linked cells in Workbook 2 to the appropriate
cells in Workbook 1. Otherwise there will be over 1000
manual edits.

All of the worksheets in Workbook 1 currently have the
same links to the same cells in Workbook 2. I need to go
in month by month and edit the links. Here is an example
of what I need the macro to do.

Workbook 2.
Worksheet: Feb-03
Currently Linked to Workbook 1: Jan-03'!$N$973
Needs to be Linked to Workbook 1: Feb-03'!$N$974

I will be grouping the worksheets together as I edit the
current month, then ungroup the current from the remaining
so that it's always an increase by 1.

If the whole process cannot be done, fine, but if I could
at least create a macro to increase the existing number by
1, I can always find and replace the month.

Help, please!

 

[Thomas O'Sullivan]

I don't know if there is a macro that will help you, but
have you ever thought about find / replace? We use it all
the time and its pretty quick...

To resolve yours:

Find: "Jan"
Replace: "Feb"

If you have the file opens when you do this operation it
works faster. Also, if there are multiple tabs to change,
highlight all the tabs then do the operation. If there are
only particular cells to change then search only those
cells.

hope it helps...