Select and Copy Range from Active Cell

**Leah** · 10-21-2009, 02:31 PM

I've got my language wrong.

I want my code to evaluate each cell in column B, and based on its value, copy the row from D to X and paste on the newly activated worksheet. I'm trying to use Offset, but it's not working.

Please Login or Register  to view this content.

**DonkeyOte** · 10-21-2009, 02:40 PM

Perhaps, if I've understood,

Please Login or Register  to view this content.

**JBeaucaire** · 10-21-2009, 02:41 PM

Based on its value...copy D:X... what value are your testing for? Anything?

Without referring to your code, can you just explain verbally what you're macro is supposed to accomplish?

For instance:
"For every cell in B2:B200 that is not blank, copy D:X to another sheet. On the new sheet I want all the data without blanks"

If you post up your sheet with perhaps an example BEFORE/AFTER, we can help more specifically.

**Leah** · 10-21-2009, 02:55 PM

Sheet1 is the total sheet

Column B contains numbers, the team number a child has been assigned to.

I want to go through column B, and if its value is 1, the child's information (which is contained in Columns D through X of that Row) will be copied and pasted into the first available Row (starting with A2) on the Team 1 page (Sheet2 in this case). I would then repeat the code to do the same for values 2, 3, and so on until each Team page contains all of its registrants.

There are plenty of blank cells throughout the row, and the majority of Column X will be blank, which is why I'm hesitant to use an Endx1Up/Down.

Is that clear?

**DonkeyOte** · 10-21-2009, 03:03 PM

It might be an idea to outline the naming convention of your team sheets, using codenames is ok if they follow some logic.

I would simply adapt that already provided

Please Login or Register  to view this content.

**Leah** · 10-21-2009, 03:08 PM

That is perfect. And so simple! I will get there one day...one day.

**DonkeyOte** · 10-21-2009, 03:23 PM

I should add that in my prior example the sheet selection was based on Index position (ie physical position in file with 1 being leftmost sheet) which may/may not be correct.