Copy rows based on cell content

B

billinr

I have a workbook with about 100 sheets, all formatted the same; different
information, but rows and columns are laid out the same.
I would like to copy the information from rows 5 through 13 based on the
contents of cell A1.
There will be three choices: FWD, RWD, BOF.
I would like to paste this information into 3 separate sheets, named as above.
The information is updated bi-weekly, so I would like to automate this
process.

Any suggestions are appreciated.
 
B

billinr

Thanks for replying.

I have a workbook - "All Models".
Inside that workbook are approx. 100 sheets, each with a different name
based on the model represented.
All of these sheets are formatted the same: columns, headers, rows, etc. The
individual cell contents varies between the sheets.
For all of these sheets, they will fall into one of three categories: FWD,
RWD, BOF.
I have placed this category title into cell A1 on each sheet.

What I would like to do is copy the entire row, from row 5 through row 13,
on each sheet, and place that information onto another sheet. I want to use
the category title in cell A1 to differentiate which sheet the information is
placed upon.

The new sheets can be in this same workbook, or on their own - no preference.

I would like to run this as automated as possible, because the information
is updated on a regular basis.

So, (forgive the newbie VBA), my macro instruction would be something like:
If A1="FWD", copy row 5, paste to "newsheet FWD". Repeat for row 6, 7, etc.;
repeat for all sheets in the workbook; repeat for "RWD" and "BOF".

Can this be done?

Thanks for your help.
 
Top