Creating an order form from a model number

T

TommyD

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!
 
M

M Kan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
Do I need a Macro to do Transpose in this case? 3
Creating a list of job numbers, missing out irrelevant items 9
Search, using lists maybe? 0
Help with VBA Macro Reading Excel "form" 2
would love help creating a macro to insert information 3
Removing a matching code from another cell 5
Addiing a Zero to a number which is already there 1

Top