L
Les Linton
I have a workbook with two sheets “Order” and “Data”
Data Sheet Columns are A=Number, B=Vendor, C=Description, D=Cost an
E=List. There are several hundred rows of actual data.
Order Sheet Columns are A=Number, B=Vendor, C=Description, D=Quantity
E=Cost, F&G are formulas and H=List.
There are 35 rows for data on the order sheet.
When I enter a part number in the first cell on the ORDER sheet, (A4)
have been trying to use INDEX/MATCH to populate the ORDER sheet column
B,C,E and H based on the like Number on the Data sheet. I’m doin
something wrong.
The Number column on the data sheet is actually formatted as ‘text
because the part numbers often have letters in them and not in an
specific order.
If I have more than 35 items, I would like to have it expand, but tha
can be a different question.
Can I do this? Should I learn VB and make this a User Form?
Any ideas would be helpful
Thanks,
Le
Data Sheet Columns are A=Number, B=Vendor, C=Description, D=Cost an
E=List. There are several hundred rows of actual data.
Order Sheet Columns are A=Number, B=Vendor, C=Description, D=Quantity
E=Cost, F&G are formulas and H=List.
There are 35 rows for data on the order sheet.
When I enter a part number in the first cell on the ORDER sheet, (A4)
have been trying to use INDEX/MATCH to populate the ORDER sheet column
B,C,E and H based on the like Number on the Data sheet. I’m doin
something wrong.
The Number column on the data sheet is actually formatted as ‘text
because the part numbers often have letters in them and not in an
specific order.
If I have more than 35 items, I would like to have it expand, but tha
can be a different question.
Can I do this? Should I learn VB and make this a User Form?
Any ideas would be helpful
Thanks,
Le