Copy and paste

[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]

You could use data>filter>autofilter>filter the appropriate column for your
target>copy visible cells.

 

[Eric]

Don,
I am looking for this in a macro style.

You could use data>filter>autofilter>filter the appropriate column for your
target>copy visible cells.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

The macro recorder is your friend. Try it and then post your solution and
additional questions.

 

[Eric]

Your really making this tough on me ....... My head hurts........