Help creating a macro to copy and paste a certain selection
Using the data sheet below, how do I write a macro that would find the data
that extists between the first (#1) (C2), (there's a header), to the last (#1) (C10), INCLUDING any blank rows there may be between them and copy then paste ALL the data from column A to S, to another sheet named R1. NOTE: this needs to exclude any blank colums past (R) and further(I excluded the data just for ease). After that it needs to come back to this data sheet and copy everything between the (#2)'s and copy them to R2 and so on until it reaches no other numbers usually around the number 10, then return to R1, cell (A2). Note, I put hyphens between cell values in row 2 to indicate new adjacent cell value. The copy begins in column E and goes to column R The top left cell on the sheet R1 is C5 where the paste begins Thanks everyone. x a b c d e f g h i j 1 Header 2 110-fm-1-Hol-81-11/01/2006-Easy Obsession-T-8.50-0.50 3 111 fst 1 Fpx 79 09/24/2006 Easy Obsession D 8.50 3.00 4 113 fst 1 Fpx 72 09/10/2006 Easy Obsession D 6.00 0.00 5 114 fst 1 Fpx 72 09/10/2006 Easy Obsession D 6.00 0.00 6 115 fst 1 Fpx 72 09/10/2006 Easy Obsession D 6.00 0.00 7 116 fst 1 Fpx 72 09/10/2006 Easy Obsession D 6.00 0.00 8 Blank row 9 117 fst 1 Fpx 72 09/10/2006 Easy Obsession D 6.00 0.00 10 118 fst 1 Fpx 72 09/10/2006 Easy Obsession D 6.00 0.00 11 119 fst 2 Fpx 72 09/10/2006 Easy Obsession D 6.00 0.00 12 120 fst 2 Fpx 72 09/10/2006 Easy Obsession D 6.00 0.00 13 121 fst 2 Fpx 72 09/10/2006 Easy Obsession D 6.00 0.00 |
All times are GMT +1. The time now is 09:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com