Pulling data from multiple workbooks

jprlaw

New Member
Joined
Feb 9, 2003
Messages
11
Is there a quick way to pull data from multiple different workbooks within the same folder.

The cell references are identical for each workbook ie B19, B20 etc and are always located on sheet 1. but the files have completely different names. is there a macro i could run/write to open each workbook in turn, copy the cells in question, and paste them to a seperate workbook , then open the next workbook from the folder and repeat the process :devilish: ?

Thanks in advance for your help
 

Forum statistics

Threads
1,078,373
Messages
5,339,819
Members
399,334
Latest member
Grace Ford

Some videos you may like

This Week's Hot Topics

Top