If in cell is a value, copy rows to sheet2
Hi,
I have the following question>
In my worksheet there may be value "X" in some cells of column F. I would like to copy this entire row and the 4 rows underneath to Sheet 2, if this is the case. In sheet2 there should then be a list with all the rows (always 5 rows per X) from sheet 1 with the "X" in column F.
More Details:
It is a client list. Each client information consists of 5 different rows. Where as in the first row in column F is the "X" or not.
The first client have rows 3-8, the second client rows 9-14, etc.
I hope it is not too confusing.
Can someone please help me?
silke
If in cell is a value, copy rows to sheet2
This can easily be done with a simple macro that would loop thru column F. If the value =X, it would select the four rows you require and copy and paste to the other worksheet.
I know VB and this is something not very difficult to code
Marty
A sample file would help...
A sample file would help...
Screen shot
I loaded up a screen shot. It would me so great if you could help me!