Excel XP on Windows XP
I have a workbook with 58 worksheets (file One). I have individual workbooks that may hold one to five of the worksheets from file One (files A - Z). I want the worksheets in file One to be linked to the worksheets in files A - Z, so that when I update a worksheet in file One it automatically updates the worksheet in files A-Z (i.e. worksheet 345 in file One is linked to file D's workbook, worksheet 345).
I can not copy an entire worksheet in file One and use the paste link under Paste Special, because I get an error "Can not complete task with available resources". I selected the filled-in part of the worksheet in File One, plus 10 extra rows, copied them, and used the Paste link under Paste Special to copy them to the correct individual workbooks in files A-Z.
Here is the problem: when I insert lines in a worksheet in file One it does update the individual worksheet in file D ( for example) UNLESS I go beyond the extra 10 rows, then it stops linking. I want to be able to add rows in the original worksheet and have the linked worksheet automatically add the linked cells. OR is there a better way to link workbooks? Thank you!;;)
Adding rows to linked worksheet
-
-
-
Quote
OR is there a better way to link workbooks?Can you explain why your workbooks are set up the way they are? That may shed some light on whether different solutions may/may not work for you.
:usaflag:
-
The files were set up by someone else. The worksheets are all accounts. The large file (file one) holds around 75 different accounts (one account per worksheet). The files A-Z which correspond to file one holds individuals' accounts (say Bob who has accounts 3, 5, 9, 15 in file one). When we reconcile the accounts in file one, we want them to automatically update each file in the individuals' accounts. I really appreciate any help or suggestions you have!!!
-
Do you think it would work to put a button on each sheet in the master file that would copy the sheet and paste it into the appropriate A-Z file when the reconciliation is completed? Rather than all those links, I mean. This could be done by VBA with a bit of effort (not bad though).
-
It has been 4 years since I have done any VBA programming. Would I have to program each worksheet's button separately? The worksheets in file one are numbered 12-1234, etc. The files in A-Z are named Smith, etc. with worksheets numbered 12-1234, 12-1235, 12-1555. Any examples would be greatly appreciated. I am an Administrative Assistant, not a programmer. Although, I do like programming.
-
-
I will try to post some code tomorrow or the next day. Sorry I can't get to it until then.
-
Thank you!;;)
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!