0

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
  • 1
    Welcome to superuser. What have you tried so far?
    – CharlieRB
    Jun 17, 2013 at 12:51

1 Answer 1

1

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .