I'm trying to figure out the following:
1) Take the Lookup Value in Cell B2, i.e. "0001324"
2) Find the match in a text file with PSV laid out thusly over 1.8 million lines-- PartNumber may, or may not, be in ascending order:
PartNumber|ItemName|SoS|Unit|Price|Core
9999999|Fluid, Brake,Silicon|E|GAL|$56.00|N
0000001|Gadget,Widget|A|DZ|$99.99|N
0001324|Starter,..Pre-Lubed|A|EA|$1500.00|Y*
0001322|Starter,Standard|B|EA|$3570.00|Y
*2 Periods represent 2 spaces, due to text TRIM feature in posting.
Bonus: ensure that there is only one space after each comma in text string. (Not required, but would be nice feature)
3) Return the matching line across Cells that may or may not match the text file order.
i.e: ItemName to D2, SoS to C2, Unit to E2, Price to G2 & Core to F2
4) Loop until there are no more Lookup Values in Column B.
Note: Since the Invoice could be one page or 20, I'm thinking of using
the PrintArea to establish the length of Col B and backing off "x"
number of Rows to get to the actual last row of the invoice table itself,
or would simply determing the last cell of worksheet be more efficient?
TIA
Andy
1) Take the Lookup Value in Cell B2, i.e. "0001324"
2) Find the match in a text file with PSV laid out thusly over 1.8 million lines-- PartNumber may, or may not, be in ascending order:
PartNumber|ItemName|SoS|Unit|Price|Core
9999999|Fluid, Brake,Silicon|E|GAL|$56.00|N
0000001|Gadget,Widget|A|DZ|$99.99|N
0001324|Starter,..Pre-Lubed|A|EA|$1500.00|Y*
0001322|Starter,Standard|B|EA|$3570.00|Y
*2 Periods represent 2 spaces, due to text TRIM feature in posting.
Bonus: ensure that there is only one space after each comma in text string. (Not required, but would be nice feature)
3) Return the matching line across Cells that may or may not match the text file order.
i.e: ItemName to D2, SoS to C2, Unit to E2, Price to G2 & Core to F2
4) Loop until there are no more Lookup Values in Column B.
Note: Since the Invoice could be one page or 20, I'm thinking of using
the PrintArea to establish the length of Col B and backing off "x"
number of Rows to get to the actual last row of the invoice table itself,
or would simply determing the last cell of worksheet be more efficient?
TIA
Andy