| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining worksheets with common column but different number of ro
I have two excel spreadsheets, one that is complete with product part
numbers, item descriptions, prices, quantity, photo url's, etc. I get a daily update in the form of a spreadhseet with part number and quantity only. Is there a way that excel can recognize that column A in each worksheet are part numbers, and if the part number in column A of each worksheet matches that excel should update column G with the new quantity (column B from worksheet 2)? A simple cut and paste will not work as there are different numbers of rows in each worksheet as part numbers become discontinued. Any help with this would be appreciated. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Taking a column from several worksheets; combining into another... | Excel Worksheet Functions | |||
| merge worksheets which share a common column? | Excel Worksheet Functions | |||
| combining excel worksheets with common columns | Excel Discussion (Misc queries) | |||
| Sharing common column data on several worksheets? | Excel Discussion (Misc queries) | |||
| Combine 2 spreadsheets w/1 common column of data, text and number | Excel Worksheet Functions | |||
tony 
Threaded Mode
