Creating and renaming a worksheet from user input
I need a macro that opens a dialog box and asks for a customer number and a
customer name and adds these two items to the bottom of a list of customers.
Then I want Excel to copy a worksheet titled "Blank" (already present in the
workbook) and rename it as the Customer Number: (Example - 2156 or
whatever they enter.)
As usual any help would be appreciated.
Jonco
|