View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default 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