robmarr700
asked on
linking copied excel worksheets
I want to copy the attached sheet into two new sheets within the same workbook.
I want all the data to be linked to the data in the original sheet so that when data is changed in the original sheet it changes in the new sheets.
I also want to keep the source formatting so the sheets look the same.
I then want to hide different groups of columns on the two new sheets so I end up with three sheets.
1. With all columns displayed
2. One with a set of columns hidden.
3. Another with a different group of columns hidden.
All data with be the same and linked to the original sheet.
Can anyone help me with this?
category-info-combined.xlsx
I want all the data to be linked to the data in the original sheet so that when data is changed in the original sheet it changes in the new sheets.
I also want to keep the source formatting so the sheets look the same.
I then want to hide different groups of columns on the two new sheets so I end up with three sheets.
1. With all columns displayed
2. One with a set of columns hidden.
3. Another with a different group of columns hidden.
All data with be the same and linked to the original sheet.
Can anyone help me with this?
category-info-combined.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Other than that worked great.
Thanks
Rob