How do I duplicate a workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook with financial information listed. There are several
columns that I do not want people to see, so I've hidden them and protected
the worksheet. This works fine.
But now I need another group of people to view the hidden columns on another
sheet. I need this other sheet to update automatically when changes are made
to the first.

Please help

Sam.
 
You can password protect the worksheet with the hidden columns and give the
password to only those to whom you wish to grant access
 
Ok, But the people who need to see the info have lesser knowledge than myself
and could not be relied upon to keep unhiding the columns......let alone
remembering a password.

I need to have a seperate workbook (workbook B) that can be opened to
display certain columns from workbook A.

When Workbook A is updated, workbook B is updated with the changes.

Any Ideas?
 
There are a few ways to do this. One way would be to open your workbook and
a new workbook at the same time. Click cell A1 in the new workbook and type

=+

Then click cell A1 in your existing workbook. Now copy that cell in the new
workbook over the same range as the old one. The drawback is that this new
workbook is totally dependant on the old one and can't be updated at all. It
is strictly for reference.

Another way is to use the import feature in excel but I don't have much
experience with that.

I'm sure there are other ways but this is all I know.
 
Back
Top