software

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
--
Kevin Backmannquot;SamMJloquot; wrote:

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

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?

quot;Kevin Bquot; wrote:

gt; You can password protect the worksheet with the hidden columns and give the
gt; password to only those to whom you wish to grant access
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;SamMJloquot; wrote:
gt;
gt; gt; I have a workbook with financial information listed. There are several
gt; gt; columns that I do not want people to see, so I've hidden them and protected
gt; gt; the worksheet. This works fine.
gt; gt; But now I need another group of people to view the hidden columns on another
gt; gt; sheet. I need this other sheet to update automatically when changes are made
gt; gt; to the first.
gt; gt;
gt; gt; Please help
gt; gt;
gt; gt; Sam.

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.--
Kept in the dark and fed crap all the time.quot;SamMJloquot; wrote:

gt; Ok, But the people who need to see the info have lesser knowledge than myself
gt; and could not be relied upon to keep unhiding the columns......let alone
gt; remembering a password.
gt;
gt; I need to have a seperate workbook (workbook B) that can be opened to
gt; display certain columns from workbook A.
gt;
gt; When Workbook A is updated, workbook B is updated with the changes.
gt;
gt; Any Ideas?
gt;
gt; quot;Kevin Bquot; wrote:
gt;
gt; gt; You can password protect the worksheet with the hidden columns and give the
gt; gt; password to only those to whom you wish to grant access
gt; gt; --
gt; gt; Kevin Backmann
gt; gt;
gt; gt;
gt; gt; quot;SamMJloquot; wrote:
gt; gt;
gt; gt; gt; I have a workbook with financial information listed. There are several
gt; gt; gt; columns that I do not want people to see, so I've hidden them and protected
gt; gt; gt; the worksheet. This works fine.
gt; gt; gt; But now I need another group of people to view the hidden columns on another
gt; gt; gt; sheet. I need this other sheet to update automatically when changes are made
gt; gt; gt; to the first.
gt; gt; gt;
gt; gt; gt; Please help
gt; gt; gt;
gt; gt; gt; Sam.