LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 193
Default make copies of sheet and name them from list

Hello,
I have about 50 employee numbers in sheet1 A:A. Is there code for a macro
that can make a copy of sheet2 for each instance of employee number and name
it with the employee number as the sheet name?

thanks in advance for any help,
Robert
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
make multiple copies of a sheet in a new workbook galeanne Excel Worksheet Functions 4 April 9th 23 12:50 PM
make copies of worksheet for each day of month Rhett C Excel Discussion (Misc queries) 1 October 29th 08 02:29 AM
Make dropdown item list in invoice sheet tim New Users to Excel 2 March 7th 08 07:47 PM
how to make a filtered list on a different sheet Madduck Excel Discussion (Misc queries) 4 August 22nd 07 11:42 AM
How can I Make 3 copies of one worksheet Page? VHall Excel Worksheet Functions 1 July 2nd 06 07:05 PM


All times are GMT +1. The time now is 11:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"