Quick Combining of Workbooks Data

J

JMay

I just scanned (using OCR software) into 20 separate Workbooks (Sample name
Page12.xls) (Data is in Sheet1 Only of all Wb's); The data is restricted to
a range of A1:F60 in All Wb's. My quick response to combining then was to
Take my Page01.xls, SaveAS Master.xls and Copy and Paste from each of the
2-20 wb's to my Master.xls;
This took an enormous amt of time and couldn't be the "smart-way" - I know
I'm missing a basic feature that will do this much faster (than manually as
I have done).
What am I missing?
Is code the answer?
TIA,
JMay
 
T

Tom Ogilvy

Code is a viable approach, but it might take longer to write it than to do
the copy manually. Does the OCR software have a setting to scan all sheets
into a single workbook?
 
J

JMay

hummmm, I'll check it out!
Tks Tom

Tom Ogilvy said:
Code is a viable approach, but it might take longer to write it than to do
the copy manually. Does the OCR software have a setting to scan all sheets
into a single workbook?
Click to expand...
 
Top