| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To Merge Range of Data
Is anybody could help me on the following, fill in the Pri File data in
master file: *If the material is the same than look from Pri File (W) which will be greater than Master file (W) Mater File Material W L Pri File (W)* Pri File (L)* Pri File(Qty) BVHZM005 5 645 BVHZM005 6.8 590 ZM006 9 620 BVHZM005 15 15 ZM006 15 25 BVHZM005 70 70 ZM006 70 1000 ZM006 100 1000 BVHZM005 100 1000 ZM006 125 625 BVHZM005 125 1000 ___________________________________________ Pri File Material Width Length qty BVHZM005 145 620 67 BVHZM005 150 620 53 BVHZM005 150 1000 4 BVHZM005 165 1000 3 BVHZM005 168 1000 9 ZM006 145 620 67 ZM006 150 620 53 ZM006 150 1000 4 ZM006 165 1000 3 ZM006 168 1000 9 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can you sum the last 5 columns of data from a range of data | New Users to Excel | |||
| Data Validation range | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| data range | Excel Discussion (Misc queries) | |||
| How can I check if data in an external data range is changed afte. | Excel Worksheet Functions | |||
Linear Mode
