countryfan_n
03-03-2008, 05:37 AM
Hello friends,
The below attachment should make request easier to understand.
I am truly sorry for the inconvenience
I am trying to create a macro that:
1. Would look into rows 3 or 4 or 5 or 6 or 7.
2. And if the value in G3 or G4 or G5 or G6 or G6 or G7 = 100%
Then the:
3. Entire row of that active cell would be copied & pasted to C11:H11.
4. Clear the data in the top rows (since it has already been pasted to a new row).
5. Please note the pasting should only occur from row number B11.
6. If the row B11 already is filled up, then pasting should be applied to the following empty row and so forth.
Thanks in advance,
Nawaf
The below attachment should make request easier to understand.
I am truly sorry for the inconvenience
I am trying to create a macro that:
1. Would look into rows 3 or 4 or 5 or 6 or 7.
2. And if the value in G3 or G4 or G5 or G6 or G6 or G7 = 100%
Then the:
3. Entire row of that active cell would be copied & pasted to C11:H11.
4. Clear the data in the top rows (since it has already been pasted to a new row).
5. Please note the pasting should only occur from row number B11.
6. If the row B11 already is filled up, then pasting should be applied to the following empty row and so forth.
Thanks in advance,
Nawaf