Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying Excel 2007 data to external programs | Excel Discussion (Misc queries) | |||
Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
Copying Excel Macros | Excel Discussion (Misc queries) | |||
Copying data from another cell, I think there are macros | Excel Discussion (Misc queries) | |||
Copying data to an external Program | New Users to Excel |