Hello y'all,
Not sure if this is the correct subforum, as a macro may be more useful for what I want.
Within an Excel file I want changes on sheet(1) which contains a table, to affect other sheets. Any moving, copying, deleting or sorting of different rows, columns and ranges should be reproduced on other sheets.
So, if I would cut/paste P5:T15 to T5:X15 on sheet(1), the same cut/paste action should happen on sheet(2) and sheet(3).
Also if I would sort the table on sheet(1), the data in the other sheets should be moved in the same pattern, as the data on a given cell on one sheet is related to the same cell on another sheet.
The solution to select multiple sheets in excel results in the error: "Cannot make changes to a table or XML mapping when multiple sheets are selected."
The table on sheet(1) is causing this method not to work. Ideally I'd keep the table as it makes sorting through the data manually easier. So I'm looking for an alternative method. Preferably one that makes it so that I can just edit about on the first sheet as I would normally do, without any extra actions that I need to perform, for the amount of data I need to edit is already quiet a handful.
Bookmarks