kittykat
05-08-2007, 02:49 PM
Hi,
Is that possible to just copy the range between the cheerleader and number of activities.
Algorithm:
1. Find " Cheer leader"
2. Find " Number of activities after cheer leader" row.
3. Move the selection to cheer leader move 3 rows down and 7 columns.
4.Copy the rows from 3 until the no.of activities minus one row and paste them in sheet2.
5. The code should copy both the 1 and 2 columns until before of the number of activities.
6. No.of activities row should not be there in the sheet 2.
7. The code should check for number of activities as a key thing.
Please let me know how to accomplish this thru VBA.
Is that possible to just copy the range between the cheerleader and number of activities.
Algorithm:
1. Find " Cheer leader"
2. Find " Number of activities after cheer leader" row.
3. Move the selection to cheer leader move 3 rows down and 7 columns.
4.Copy the rows from 3 until the no.of activities minus one row and paste them in sheet2.
5. The code should copy both the 1 and 2 columns until before of the number of activities.
6. No.of activities row should not be there in the sheet 2.
7. The code should check for number of activities as a key thing.
Please let me know how to accomplish this thru VBA.