linking a worksheet to one in another book

  • Thread starter Thread starter Alec Holliday
  • Start date Start date
A

Alec Holliday

Done this before - but cannot remember how.

Excel 2003

Workbook with 7 sheets, for wages, 1 sheet is a "master" and consists of the
totals of the other 6 sheets.
The master (plus other sheets from different workbooks needs to be sent to
payroll bureau.)
I cannot for the life of me remember how to make a sheet in a different book
update with changes from this master sheet.
I have followed the help files which suggest "paste special" but paste
special is greyed out.
Would be eternally grateful.
(and a Happy new Year to anyone who helps - and even those who do not)
Alec
 
Alec said:
Done this before - but cannot remember how.

Excel 2003

Workbook with 7 sheets, for wages, 1 sheet is a "master" and consist
of the
totals of the other 6 sheets.
The master (plus other sheets from different workbooks needs to be sen
to
payroll bureau.)
I cannot for the life of me remember how to make a sheet in a differen
book
update with changes from this master sheet.
I have followed the help files which suggest "paste special" but paste
special is greyed out.
Would be eternally grateful.
(and a Happy new Year to anyone who helps - and even those who do not)
Alec
Click to expand...

Paste special might be greyed out because you have 2 instances of Exce
open. Open one worksheet and then open the other from within Excel. Le
me know if this doesn't help
 
Back
Top