Linkage between spreadsheets .... link from file1 sheet3 to file 2 sheet 1

D

dwalley

Hi.

I have a password protected master spreadsheet with 10 worksheet
included, I would like to create another password protected spreadshee
where the viewer may only see the contents of sheet 3 from the firs
spreadsheet.

It is vital that the second spreadsheet is password protected.

Thanks

Dav
 
F

Frank Kabel

Hi
just link the cells from this sheet. something like
=[book1.xls]Sheet3'!A1
in cell a1 of your new worksheet
 
D

dwalley

Frank.

Thanks for your reply, I tried that but it only copied the contents o
cell a1 into my secondary sheet. What I want is the entire contents o
the sheet which currently has 40 rows X 30 columns (this may change).

Dav
 
D

Dave Peterson

You may want to amend the formula slightly:

=if([book1.xls]Sheet3!A1="","",[book1.xls]Sheet3!A1)

Then drag down and drag to the right.

You won't get 0's for those empty cells.
 
Top