Quick Combining of Workbooks Data

[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

 

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

 

[JMay]

hummmm, I'll check it out!
Tks Tom

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?

 

[Ron de Bruin]

Hi JMay

Maybe you can use the example from my Tips page
http://www.rondebruin.nl/tips.htm

 

[JMay]

Thanks Ron,
Looks most helpful.
JMay

Hi JMay

Maybe you can use the example from my Tips page
http://www.rondebruin.nl/tips.htm