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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
pcsonwheels,
To give an equal split of points for very different solutions seems somewhat odd. Do please explain your reasoning.
Patrick
To give an equal split of points for very different solutions seems somewhat odd. Do please explain your reasoning.
Patrick
ASKER
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.
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