Linking data from one worksheet to another...
in [Functions]
|
Prev: hr worksheet counting days missed
Next: how to remove #n/a error in excel vlookup b/c value is not fou
From: hrquestions on 5 May 2010 14:39 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!
From: trip_to_tokyo on 5 May 2010 15:02 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" wrote: > 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!
From: Ashish Mathur on 5 May 2010 19:55
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 "hrquestions" <hrquestions(a)discussions.microsoft.com> wrote in message news:C61C5281-D932-495B-AD33-F97A24A183E2(a)microsoft.com... > 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! |