Not clear on what your layout is.

Do you have one worksheet with multiple 13 row ranges(pages) of data?

Or multiple worksheets with 13 rows on each worksheet?

What do you consider a "screen" to be?

What does "PF" mean?


Gord Dibben MS Excel MVP


On Fri, 3 Apr 2009 08:07:02 -0700, Bradly
wrote:

At work, we use a computer system that shows certain rows of data per page.
The information I want to copy has 13 rows on each screen. We have to "PF"
to the next screen--there is no scroll bar to move down. I am wanting to
copy all rows of information, which in most cases is multiple screens: I
start at screen one, highlight the data, copy, then Paste Special into my
Excel worksheet; then I "PF" to the next screen, and repeat the actions.

Is there a way that a macro could be set up to perform these actions, or am
I left to copying/pasting each screen individually? I actually tried to set
up a macro for this, but it only seems to work for the last screen I copied
and pasted.

Thanks.