98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking
Linking
Resolved · Low Priority · Version 2007
Thu 5 Nov 2009, 16:37Delegate Shaper said...
Shaper has attended:
Excel Intermediate course
Excel Advanced course
Linking
can i link workbooks where the change is in adding/deleting lines?
Mon 9 Nov 2009, 13:20Trainer Simon said...
RE: linking
Hi Shaper,
Thank you for your question and welcome to the forum.
I am in the process of finding a method of achieving this without using VBA.
As soon as I have an answer I will email you.
Regards
Simon
Mon 9 Nov 2009, 13:24Trainer Simon said...
RE: linking
Hi Shaper,
You could copy the data to another sheet and paste into the same cell range as the original data.
Then you could group the two sheets together and then insert or delete sheets. As the sheets are grouped, the rows will be inserted or deleted in both sheets.
Regards
Simon
Mon 16 Nov 2009: Automatically marked as resolved.
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. |
Excel tip:Toggle Formulas and ResultsCtrl + 'The key above Tab with the |
