Solved

linking copied excel worksheets

Posted on 2014-10-17
2
61 Views
Last Modified: 2014-10-17
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
0
Comment
Question by:robmarr700
2 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40386685
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
 

Author Comment

by:robmarr700
ID: 40386704
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

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question