i have a book that contains 3 spread sheets i would like to link these sheets that if i add a row to spread sheet 1 it will automatically and this to spread sheet 2 and 3
i have a book that contains 3 spread sheets i would like to link these sheets that if i add a row to spread sheet 1 it will automatically and this to spread sheet 2 and 3
There are 2 ways to do this. Only one requires VBA and has a few problems that you need to work out.
The VBA way is to use the event Worksheet_Change to detect whenever a row is added to sheet 1, and write code to copy the row to sheets 2 and 3. However, the event cannot detect when a row is added, it can only detect when there is a change to the sheet. This is a problem--you would have to develop logic to identify only when the number of rows increased. How are you adding the new rows--is this a person typing in data? If so, then when they enter data in column A, it creates a new row, which would be copied to the other sheets, but then if they keep typing in column B, C, D, etc., it's not a new row anymore and the data won't be copied. So you need to think very thoroughly about what you really want to happen here.
It can be done with formulas on sheets 2 and 3 to reference the data on sheet 1. That is easier to implement and easier to change. The data would always be in sync with Sheet1 no matter what changed or how. Would you consider this as an alternative to VBA?
The formular seems to me the way to go how do I set this up
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks