Column relation in two spreadsheets

[Biffarama]

Hi,

I have a question about setting up an Excel sheet so that it shows only specific columns from another Excel sheet and is connected so that changes are reflected, if it's possible.

I have a master spreadsheet of data with 20 columns and hundreds of rows. My boss wants me to create and maintain a spreadsheet for him that will show just 5 of those columns, he isn't interested in any of the other columns. I'm trying to avoid having to maintain and update both spreadsheets. What I'm wondering is if it's possible to create this spreadsheet for my boss that shows only the columns he wants from my master spreadsheet, but will reflect any changes I make to the rows in my master. The columns will always stay the same, it's the rows that will change.

Hope I have described it well enough. Thanks in advance for your help.

Troy

 

[Dannyh1]

Hi,

something like:

In your New file (say Book1)

='[Master.xls]Sheet1'!A1

No?

 

[Biffarama]

The only problem is that only copied what is in cell A1. What I need is for all the rows in 5 of the columns to be connected. For instance, columns A, C, D, R, S and T.

Thanks

 

[Biffarama]

By the way, I'm using Excel 2010