Creating an order form from a model number
 

Hi all,
I have a report that I pull from our ERP system. It gives me a list of data like the following:

Model SKU Size
1234 56789980 md
1234 65898982 lg
1234 56987985 xl
2345 89887878 md
2345 98565232 lg

I am trying to make an easier form to for ordering where I can input the model and have the sku's populate into a specific column and section of fields for instance:

Model 1234 put in on the order form and all the sku's would populate into the six column beneath it. I hope this makes sense. I am not sure how to do this. Thanks!

Creating an order form from a model number
 

Model number or SKU, since model number isn't a unique identifier, but SKU
is. If you want to reference off the SKU, you'd just use a VLOOKUP to match
and then bring the associated information back into your order form.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"TommyD" wrote:


Hi all,
I have a report that I pull from our ERP system. It gives me a list
of data like the following:

Model SKU Size
1234 56789980 md
1234 65898982 lg
1234 56987985 xl
2345 89887878 md
2345 98565232 lg

I am trying to make an easier form to for ordering where I can input
the model and have the sku's populate into a specific column and
section of fields for instance:

Model 1234 put in on the order form and all the sku's would populate
into the six column beneath it. I hope this makes sense. I am not sure
how to do this. Thanks!




--
TommyD

Creating an order form from a model number
 

If you type in a model number, are there 6 different sizes? Thus 6 different
SKU's?
--
John C


"TommyD" wrote:


Hi all,
I have a report that I pull from our ERP system. It gives me a list
of data like the following:

Model SKU Size
1234 56789980 md
1234 65898982 lg
1234 56987985 xl
2345 89887878 md
2345 98565232 lg

I am trying to make an easier form to for ordering where I can input
the model and have the sku's populate into a specific column and
section of fields for instance:

Model 1234 put in on the order form and all the sku's would populate
into the six column beneath it. I hope this makes sense. I am not sure
how to do this. Thanks!




--
TommyD