Extract data from multiple files to one file

[ranaray]

Hi,


Can you please share a solution to help me extract contents of a specific coloumn from multiple excel files (saved in a specific folder on my desktop) to a blank new excel file which has the same coloumn headings.


Basically I have recieved expense files for the last one year. I dont want to open each file , copy the coloumn I need and past in to a new sheet.


I will then use the new file with all data init to generate pivots and do analysis.


Please help.

Thanks

 

[Luke M]

Check out the Copy/Paste/Merge section here:

http://www.rondebruin.nl/tips.htm


Ron has several great tools for merging info into one summary book, including some free add-ins that might help you out.