Copying or Extracting data to another sheet

Hi guys!

I need your help on how to copy data on another sheet.

I need to extract the data of every employee on separate worksheet.

Please see the attached file samplefile.xlsx. Sheet entitled mainworksheet consists of the data that needs to be copied on another sheet for every employee.

Each employee has his/her own sheet containing the data on the mainworksheet.

Sheet2 contains the format of what the new sheet of every employee should look like.

I hope you can help me on this. Thank you so much.

virgolady,

Welcome to the forum!
Attached is a modified version of your posted workbook. It contains the below macro. Your template sheet ha some fields that weren't on the 'mainworksheet' so I wasn't sure exactly where to output the information. As a result, the information is just output to where you had it in your example file (to the right of template sheet's setup).

Please Login or Register  to view this content.

How to use a macro:

1. Make a copy of the workbook the macro will be run on
   • Always run new code on a workbook copy, just in case the code doesn't run smoothly
   • This is especially true of any code that deletes anything
2. In the copied workbook, press ALT+F11 to open the Visual Basic Editor
3. Insert | Module
4. Copy the provided code and paste into the module
5. Close the Visual Basic Editor
6. In Excel, press ALT+F8 to bring up the list of available macros to run
7. Double-click the desired macro (I named this one tgr)

Sorry...

hecgroups, did you post in the right place? This isn't your thread, and the script provided here was not from watersev...

Looks like this question is being asked by two different people, here's the other thread:
http://www.excelforum.com/excel-prog...e-in-vb-2.html