Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking One worksheet to Two different workbooks with Daily Dates. | Excel Discussion (Misc queries) | |||
Linking worksheet functions and arrays - Doozie | Excel Discussion (Misc queries) | |||
Linking worksheet event codes | Excel Worksheet Functions | |||
Outlook help and worksheet linking help | Excel Discussion (Misc queries) | |||
Linking items GREATER THAN O on another worksheet in the same Work | Excel Discussion (Misc queries) |