Thread
:
Macro for filtering
View Single Post
#
1
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Macro for filtering
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett