macros for copying external data to Excel
 

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.

macros for copying external data to Excel
 

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.

macros for copying external data to Excel
 

The layout is multiple "worksheets" with 13 rows on each. They really aren't
"worksheets" as would be the case in my Excel document. The original source
of data is a non-Windows-based, non-web-based system and each "page" of data
is what you see on the computer screen, hence each page being called a
"screen".

Imagine for a moment a government computer system that shows data for a
county program. The background is black and the data is in a green out-dated
computer font. There are no scroll bars to move up/down, left, right--you
have to use PF keys, which are really the F keys on the keyboard. When you
see the first screen, or page, of data, you see 13 rows of information
organized in columns. To see the next screen or page, you would press F8 to
move down, etc. There are several screens/pages of 13 row data.

Let me know if you need further explanation to help me with my question.

"Gord Dibben" wrote:

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.