angoodkind
New Member
- Joined
- Jan 8, 2010
- Messages
- 10
Thank you in advance for all of your help <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
I'm trying to copy batches of rows, based upon one column's values. <o></o>
<o></o>
The worksheet looks like this (sorted by the first column):<o></o>
<o></o>
A 5 blue<o></o>
A 6 yellow<o></o>
B 3 red<o></o>
B 2 blue <o></o>
<o></o>
The loop has 3 primary steps:<o></o>
1) Copy all rows beginning with a value, e.g. rows 1-2, which both begin with "A" <o></o>
2) Paste rows into an email (I know how to do this) <o></o>
3) Move to the value, B, and copy all rows starting with B <o></o>
<o></o>
I won't know the values of Column A, as they will change each time. Is there a way I can still write this loop?<o></o>
<o></o>
Thanks,
Adam<o></o>
<o></o>
fficeffice" /><o></o>I'm trying to copy batches of rows, based upon one column's values. <o
></o><o
></o>The worksheet looks like this (sorted by the first column):<o
></o><o
></o>A 5 blue<o
></o>A 6 yellow<o
></o>B 3 red<o
></o>B 2 blue <o
></o><o
></o>The loop has 3 primary steps:<o
></o>1) Copy all rows beginning with a value, e.g. rows 1-2, which both begin with "A" <o
></o>2) Paste rows into an email (I know how to do this) <o
></o>3) Move to the value, B, and copy all rows starting with B <o
></o><o
></o>I won't know the values of Column A, as they will change each time. Is there a way I can still write this loop?<o
></o><o
></o>Thanks,
Adam<o
></o><o
></o>
