moving worksheets between files

  • Thread starter Thread starter Markathepub
  • Start date Start date
M

Markathepub

Hi,

On a monthly basis I need to move a worksheet from say the Novembe
file to the December file. The worksheet has lots of references t
other worksheets within the file, heaps of conditional formatting an
hidden rows.

When I move the worksheet it goes across OK (conditional formatting,
hidden rows) but the cell references point back to the old fil
worksheets whereas I want the references to pick up data in the ne
(December) file.

Does anybody know how this can be done, I've tried various ways o
cutting and pasteing without success. I ended up manually amendin
every call reference!

Thanks to anybody who helps

Mar
 
Before copying the sheet, replace all = with ^=, that will make all formulas
text,
(replace equal sign with ^= under edit>replace), copy over the sheet, once
copied over
reverse the replace and replace ^= with = on both sheets (source and new
copy)

--

Regards,

Peo Sjoblom


Markathepub said:
Hi,

On a monthly basis I need to move a worksheet from say the November
file to the December file. The worksheet has lots of references to
other worksheets within the file, heaps of conditional formatting and
hidden rows.

When I move the worksheet it goes across OK (conditional formatting, &
hidden rows) but the cell references point back to the old file
worksheets whereas I want the references to pick up data in the new
(December) file.

Does anybody know how this can be done, I've tried various ways of
cutting and pasteing without success. I ended up manually amending
every call reference!

Thanks to anybody who helps

Mark


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top