Link to home
Start Free TrialLog in
Avatar of pcsonwheels
pcsonwheels

asked on

Excel drop down boxes that populate multiple cells

Hi,
We make labels to go on palets of product.  We would like to make an excel spreadsheat that has one dropdown box once you choose a value from the box it automatically populates another cell with the description of the value selected.  Attached is the label and a small amount of a very large excel spreadsheat of out products. The two columns are SKU# and ITEM.  We will select the SKU# and the Item associated with that SKU should apear in the description area of the label.   Also I would like to be able have a serial number which is used for tracking if necessary that automatically incriments itself after the lable is printed or saved and the serial number can start out as any number lets say 10000.  The serial number area is not on that label yet.
Thanks
Book1.xlsx
SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
pcsonwheels,

Attached is a file in which the label can be printed when the button is pressed - with or without incrementing the Tracking Number.

Hope it helps

Patrick
pcsonwheels-01.xls
Avatar of pcsonwheels
pcsonwheels

ASKER

Thank you both for your answers.  I wanted to know what needs to be added to the macro to make it print to a different printer than the default printer.  I did some reading about it online and see it should be activeprinter = "\\comp2\hp4000 Ne01:"  How do you know which port it is connected to Ne00 Ne01 ...
Thanks
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
pcsonwheels,

To give an equal split of points for very different solutions seems somewhat odd. Do please explain your reasoning.

Patrick
I used the first solution to take care of selecting the data then I used your solution to take care of the printing by adding the macros to the already done shipping label.  I know your solution had the same type of selection process but I had modified the appearance of the shipping label before I used the printing macros.