Macro for filtering

[Eric]

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

 

[Don Guillett]

Pls stay in your ORIGINAL thread.