View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jonco jonco is offline
external usenet poster
 
Posts: 53
Default 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