Keep consistent between two worksheets
I have two worksheet contain same customer's name in column B, but they might
be in different row, how can I make sure they are in same row between two worksheet, also when I add new customer's name by inserting row in worksheet one, how can it be added to worksheet two in the same row so that they are always consistent? Thanks a great!! Hank |
Keep consistent between two worksheets
"Hank" wrote:
I have two worksheet contain same customer's name in column B, but they might be in different row, how can I make sure they are in same row between two worksheet, also when I add new customer's name by inserting row in worksheet one, how can it be added to worksheet two in the same row so that they are always consistent? Some thoughts .. perhaps use either vlookup or index / match (lookup cust name) to dynamically extract particulars from data entered in one sheet to the other. The cust names in the 2nd sheet need not be in the same order as the those listed in the first sheet. Try Debra's nice coverage on VLOOKUP or INDEX/MATCH at her: http://www.contextures.com/xlFunctions02.html VLOOKUP http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
All times are GMT +1. The time now is 12:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com