Afternoon all,
I have a workbook which has 9 sheets on it. They all have the same amount of columns used A-AI with the same 'headings'. We use it for keeping track of our training. Depending on where someone is in the training programme decides which of these 9 sheets they are on.
What I am trying to get it to do, but in all honesty am at a complete loss. Is that if a column is added or deleted in any of the 9 worksheets then this is replicated in the other 8. If this is indeed possible.
I think that this may possibly have something to do with selecting all the sheets as an array before adding or deleting columns, but can't figure out how to get this to work as they would have to all be selected before the column is added/deleted rather than after. And I also can't figure out how to trigger it (possibly with the worksheet change event?)
Any help would be gratefully received, even if it is to say that this is not possible. At least that way I can drop it as an Idea.
I have a workbook which has 9 sheets on it. They all have the same amount of columns used A-AI with the same 'headings'. We use it for keeping track of our training. Depending on where someone is in the training programme decides which of these 9 sheets they are on.
What I am trying to get it to do, but in all honesty am at a complete loss. Is that if a column is added or deleted in any of the 9 worksheets then this is replicated in the other 8. If this is indeed possible.
I think that this may possibly have something to do with selecting all the sheets as an array before adding or deleting columns, but can't figure out how to get this to work as they would have to all be selected before the column is added/deleted rather than after. And I also can't figure out how to trigger it (possibly with the worksheet change event?)
Any help would be gratefully received, even if it is to say that this is not possible. At least that way I can drop it as an Idea.