Building a shipping label program

[Lost in excel]

I want to build a template that when the user keys in a customer number, it
fills in the template with the shipping address and allows them to ask how
many labels and have them print on our label printer. I would love the
general outline on how to do this.

Thanks much
Greg

 

[Gord Dibben]

Data Validation>List dropdown menu for the entry of the number.

VLOOKUP tables formula(s) for the filling-in of addresses.

You would need VBA to use an InputBox to collect the number of labels then
print that many.

example code.

Sub print_labels()
Dim numlabs As Integer
numlabs = InputBox("Enter number of labels to print")
ActiveSheet.Range("C4:F7").PrintOut Copies:=numlabs
End Sub


Gord Dibben MS Excel MVP