Copy and paste
 

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

Copy and paste
 

You could use datafilterautofilterfilter the appropriate column for your
targetcopy visible cells.

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

Copy and paste
 

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

"Don Guillett" wrote:

You could use datafilterautofilterfilter the appropriate column for your
targetcopy visible cells.

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

Copy and paste
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eric" wrote in message
...
Don,
I am looking for this in a macro style.

"Don Guillett" wrote:

You could use datafilterautofilterfilter the appropriate column for
your
targetcopy visible cells.

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

Copy and paste
 

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

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eric" wrote in message
...
Don,
I am looking for this in a macro style.

"Don Guillett" wrote:

You could use datafilterautofilterfilter the appropriate column for
your
targetcopy visible cells.

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