Pulling data from multiple .csv files

SamueXCEl

New Member
Joined
Aug 6, 2019
Messages
9
Hi - any idea how to vlookup or sumif or ... from multiple .csv files into one master file?

The master and .csv files would be saved in the same location, and the filename of each .csv would be stored in a cell in the master file.

The .csv files would not be open when the master is open (and thus updating).

Thanks
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

SamueXCEl

New Member
Joined
Aug 6, 2019
Messages
9
Thanks - but can I combine VLOOKUP with INDIRECT to pull from a range in a separate file
 

Watch MrExcel Video

Forum statistics

Threads
1,099,383
Messages
5,468,279
Members
406,578
Latest member
Julez_86

This Week's Hot Topics

Top