copy rows from 1 sheet to multiple sheets

**GatorHunter** · 05-04-2010, 01:04 AM

Ok, I have been asking around for weeks with no answers, only I need Macros. I have never worked with macros and have no idea how to start.

This is my problem:

I have a workbook with many sheets. I currently work in Afghanistan for the military. I train soldiers on the vehicles they operate here.

On my first sheet I have the place they were trained, last name, first name, rank, MOS, Date started, date ended, and test score. All students will go on this master sheet. I then have one sheet for each location (total of 5 locations) I want to be able to input all the info on Sheet 1 and once I type in the location that each student was trained it will automatically copy that whole row to the other sheet with the same location.

Example:

Please Login or Register  to view this content.

Once I type this in the master sheet i was each row to be copied to another sheet

All Florida copy to one sheet
All Texas copy to one sheet
All New York copy to one sheet.

Hope i explained it enough,

thanks in advance for your help

GH

**royUK** · 05-04-2010, 01:15 AM

You don't need individual sheets,just use AutoFilter

**JBeaucaire** · 05-04-2010, 01:22 AM

Roy is right, once people discover the Data > Filter > Autofilter, they often find it is easy and convenient to work with the data right there on the master sheet. You can filter column A by any single value you want pretty easily. Check it out.

If you find you still really want standalone, I have a stock macro for this:

Sheet1 to Sheets - Parse Macro

That page has the code and a sample workbook, I'm pretty sure the code will do what you want as is.

**GatorHunter** · 05-04-2010, 04:50 AM

Originally Posted by royUK

You don't need individual sheets,just use AutoFilter

Yes, I understand how to use autofilter, but that's not how I want to use the spreadsheet, thanks for the input

**GatorHunter** · 05-04-2010, 04:55 AM

Originally Posted by JBeaucaire

Roy is right, once people discover the Data > Filter > Autofilter, they often find it is easy and convenient to work with the data right there on the master sheet. You can filter column A by any single value you want pretty easily. Check it out.

If you find you still really want standalone, I have a stock macro for this:

Sheet1 to Sheets - Parse Macro

That page has the code and a sample workbook, I'm pretty sure the code will do what you want as is.

I don't understand what I need to change on the sample macro code, sorry, never worked with macros

**JBeaucaire** · 05-04-2010, 08:26 AM

Probably all you'll need to edit is the Sheets("Data") reference near the top...change "Data" to whatever the name of your master data sheet is.... or change your sheet name to "Data" and use the macro as is.