I have a workbook with 6 different worksheets but I want some columns to stay the same for all worksheets (and map any changes I may make to column A in Worksheet 1 - so that I don't have to manually make the required changes to all worksheets) - how do I do this please?
1 Answer
Focussing on “so that I don't have to manually make the required changes to all worksheets” (because I don’t fully understand your question): If you have six sheets that are, in part, the same and wish to make one change apply to all six then group the six sheets (either select them manually with Ctrl + left click on each tab, or select the range with Shift+left click on first and last in the range.)
Remember to deselect the grouping before working elsewhere on the sheets however. The Title bar should show whether or not grouping is in effect and the background of the tabs changes colour.
If you want exact copies of Sheet1 for part of the array, make the cells on Sheets2-6 refer to the corresponding Sheet1 entry.