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

M

Mel

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)
 
K

Ken Hudson

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?
 
Top