Excel 2003 Find-Copy-Paste

[amonty78]

Hi all,

Looking for some help on a macro.......I have attached a sample to help with my explination.

In the first worksheet (labled "Data") I have some basic data. What I am looking for is a formula or macro that will search column G for the letter "A". Then, copy all rows down to but not including the next letter "A".
Then I need it to take the copied rows and paste them into the worksheet labeled "Copy To", into the row with the number 1 in column B.
This process then needs to start again from the next row containing A (in this case it would be row 16 in the wroksheet labeled "Data"), through to row 34. This data would then be copied and pasted into the worksheet labled "Copy To" into the row contain 2 (in column B).

The process then repeats until all rows from the first worksheet ("Data") is copied into the second worksheet ("Copy To").

Finally, I have a third workshet, labled "Finished Example" showing how all of the data would finally look if the above processes were carried out.

Alternativly, it may be easier to just insert rows into the worksheet "Data" to seperate the data aprt. However, the data would have to be spaced out evenly (seperated by 15 rows as in the example).

Thanks to anyone that has a try at solving this, I know my explination is a little confusing !!

Cheers.