Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking sheets
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Linking sheets
Resolved · High Priority · Version 2003
Reply Thu 2 Apr 2009, 15:23Delegate Katie said...
Katie has attended:
No courses
Linking sheets
I am linking sheets in one workbook using the formula =SHEET!CELL. This works fine, however sheet 1 which is a distribution list of names, will be updated therefore rows inserted. However, I need the other sheets to follow suit and insert rows with the information updating.
Is there a simple way of doing this?
Thanks
For upcoming training course dates see: Pricing & availability
RE: Linking sheets
Hi Katie
Thank you for your question. There isn't an easy answer as far as I'm aware. To repeat the row on several sheets you are probably going to need a macro/some VBA programming.
Depending on the complexity of your workbook you may find our Excel VBA course of interest.
http://www.microsofttraining.net/excel-course-in-london-2003-vba.php
Kind regards,
Andrew
Thu 9 Apr 2009: Automatically marked as resolved.
|