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
robmarr700Asked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

You could copy the first sheet ( beware the numbr of rows or columns are not automatically adjusted)

then Paste Special / Link
Copy again
paste Special Format
Copy Again
and Paste Special Column Width

And adjust zoom

Regards
Copy-of-category-info-combinedV1.xlsx
0
 
robmarr700Author Commented:
I lost the linking when copying and paste specialing on column but width but I can do this stage manually.

Other than that worked great.

Thanks
Rob
0
All Courses

From novice to tech pro — start learning today.