Macro Help : copy + selct

  • Thread starter Thread starter U>S>A
  • Start date Start date
U

U>S>A

Hi,

I would like run a macro to copy a specific sheet for example sheet
number 1 and put after the last sheet
then open a window to selcet the first name then another window to
selct the last name . Then the postition number . Finaly the employer
id.
the first name and the last name on on filed =b5 (Lastname, First
name)

position number = f4
employer number =f5

Thank you
 
This will move the first worksheet to the end...
Worksheets(1).Move After:=Worksheets(Sheets.Count)
--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/XLCompanion



"U>S>A" <[email protected]>
wrote in message
Hi,

I would like run a macro to copy a specific sheet for example sheet
number 1 and put after the last sheet
then open a window to selcet the first name then another window to
selct the last name . Then the postition number . Finaly the employer
id.
the first name and the last name on on filed =b5 (Lastname, First
name)

position number = f4
employer number =f5

Thank you
 
Back
Top