Pls stay in your ORIGINAL thread.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eric" wrote in message
...
Hello all,

I am trying to copy information from one page to another but I only want
to
copy the last 4 test results that corrispond to my Target.

Sheets("jmf targets").range("E27")~~~ This is the target value =4059


sheets("test Database")~~~ This is where the tests are stored
Information
starts on row 27 of this sheet
A B C D..........AC
4059~~~ copy this line (A-AC)
333
333
4059~~~ Copy this line (A-AC)
4059~~~ Copy this line (A-AC)
222
4059~~~ Coyp this line (A-AC)

Paste these tests on sheets("Last four")~~~ Starting on row 9

Any help would be appreciated.......Eric