Linking data from one worksheet to another...

[hrquestions]

I have two worksheets in different workbooks, one as a master list, and the
other as a sub list, with candidates names and information (I'm in Human
Resources). I'd like to link them so that whatever changes I make to one
worksheet, is automatically updated in the other. Is this possible? If so,
how can it be done? Would I need to put both worksheets in the same workbook
for this to work? Thanks!

 

[trip_to_tokyo]

EXCEL 2007

Yes, this is possible.

Please check out:-

http://www.pierrefondes.com/

Item number 47 (called 2 Linked Workbooks).

Pull both Workbooks up on your screen.

If you change any of the cells A6:E7 in avinity1 you will see linked cells
being updated in avinity2 (cells C17:G18).

Just look at the formulas in avnity2 to see how it's done.

Both Worksheets do not have to be in the same Workbook (as you should be
able to see from the above).

If my comments have helped please hit Yes.

I have two worksheets in different workbooks, one as a master list, and the
other as a sub list, with candidates names and information (I'm in Human
Resources).

I'd like to link them so that whatever changes I make to one

worksheet, is automatically updated in the other.

Is this possible? If so,

how can it be done?

Would I need to put both worksheets in the same workbook

 

[Ashish Mathur]

Hi,

No you need not put both worksheets in the same workbook. You may simple
link data by establishing a cell link I.e. = and then select the desired
cell on another file. Before copying and pasting, remove the $ sign

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com