Linking data from one worksheet to another...

H

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!
 
T

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.



hrquestions said:
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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top