Prev: Trying to get this if statment to work
Next: IS THERE A FORMULA TO CALCULATE THE DISTANCE BETWEEN DATES
From: Puzzled on 5 Jun 2010 15:49
I have information in column A of a task sheet. The information goes from row
1 thru 35. Column B is where I place a "x" to say the task need to be
completed. Is there a formula that can check each row in column B to see if
the "x" exist, until it reaches the end. If the "x" exist in any of the rows,
then move the information into a blank sheet called assignment. Example
B1,B3,B4,B20 all have a "x" in the field, now I need to move the information
in A1, A3, A4, A20 to row1 thru 4 of a blank work sheet. Is this possible.
From: FSt1 on 5 Jun 2010 20:48
hi
see your other post.

regards
FSt1

"Puzzled" wrote:

> I have information in column A of a task sheet. The information goes from row
> 1 thru 35. Column B is where I place a "x" to say the task need to be
> completed. Is there a formula that can check each row in column B to see if
> the "x" exist, until it reaches the end. If the "x" exist in any of the rows,
> then move the information into a blank sheet called assignment. Example
> B1,B3,B4,B20 all have a "x" in the field, now I need to move the information
> in A1, A3, A4, A20 to row1 thru 4 of a blank work sheet. Is this possible.
 | 
Pages: 1
Prev: Trying to get this if statment to work
Next: IS THERE A FORMULA TO CALCULATE THE DISTANCE BETWEEN DATES