Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
Adding same cells across multiple worksheets | Excel Worksheet Functions | |||
Print order of worksheets | Excel Discussion (Misc queries) | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |