HELP...PLEASE...W/ IF/THEN/COPYTO STATEMENT - THANKS!
 

This is what I am looking to do...I know this is NOT the way to do it, so I
need help as soon as someone can...THANK YOU SOOOOO MUCH! Hope it makes
sense!

=IF(D2=MA)AND(E2=0-24)THEN(COPY(A1 and A2)TO WORKSHEET2 AT THE END OF LAST
ROW)

Hi Mel,
Not exactly sure of your question. Assuming Sheet1 D2 contains "MA" and E2
contains a number between 0 and 24. Assume that the last row of data in
Sheet2 is row two. Then put the follwoing formulas in A3 and B3 in Sheet2.

=IF(AND(Sheet1!$D$2="MA",AND(Sheet1!$E$2=0,Sheet1 !$E$2<25)),Sheet1!A1,"")

=IF(AND(Sheet1!$D$2="MA",AND(Sheet1!$E$2=0,Sheet1 !$E$2<25)),Sheet1!A2,"")

Is this what your looking for?

"Mel" wrote:

This is what I am looking to do...I know this is NOT the way to do it, so I
need help as soon as someone can...THANK YOU SOOOOO MUCH! Hope it makes
sense!

=IF(D2=MA)AND(E2=0-24)THEN(COPY(A1 and A2)TO WORKSHEET2 AT THE END OF LAST
ROW)