S
Sidesfive
I need create a "total" summary (in it's own workbook) from many workbooks on
a monthly basis. Each workbook contains monthly tabs. The January Summary
is linked to each workbook, cell by cell (for totals). For the February
Summary, I would like to copy the January summary and then do a "find and
replace"-in other words just replace January with February, so my new summary
has the February totals on it. When I do a "find" on "January" it brings up
every case. When I try to replace it with February (another worksheet in
the same workbook), it gives me an error message that says "a formula
contains one or more invalid references. Verify that the formula contains a
valid path, workbook, range and cell reference. Data in both worksheets are
in the same cells.
Any suggestions for making this work. I
Thanks,
Thanks
a monthly basis. Each workbook contains monthly tabs. The January Summary
is linked to each workbook, cell by cell (for totals). For the February
Summary, I would like to copy the January summary and then do a "find and
replace"-in other words just replace January with February, so my new summary
has the February totals on it. When I do a "find" on "January" it brings up
every case. When I try to replace it with February (another worksheet in
the same workbook), it gives me an error message that says "a formula
contains one or more invalid references. Verify that the formula contains a
valid path, workbook, range and cell reference. Data in both worksheets are
in the same cells.
Any suggestions for making this work. I
Thanks,
Thanks