linking a worksheet to one in another book
 

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

linking a worksheet to one in another book
 

Alec Holliday Wrote:
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

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


--
PowerWheels
------------------------------------------------------------------------
PowerWheels's Profile: http://www.excelforum.com/member.php...o&userid=30045
View this thread: http://www.excelforum.com/showthread...hreadid=497261