Combine different tables in one table from selected files

Hello everyone,

I just need your help in making my macro code better to do it work like I need.

My code

Please Login or Register  to view this content.

What actually does these code:
1. it has to open the file from selected folder...name of the file is in cell B3
2. select range and copy it
3. past only values in the last empty row in column A of the origin workbook - OPS.xlms
4. close the opened workbook.

What should it do?
I want that the macro stops if the file with the selected name does not exist - so if i write in B3 February (example) and file with these name does not exist in folder it displays msg box - file with these name doesn't exist and stop the macro.
To sum values in the column E of the opened workbook and displays the result in a msg box or in a cell (B4) of origin workbook.

I really don't know hot to set up the code that it will work like I want.

Your help will be appreciated,
forfiett

Assuming this macro is stored IN the OPS.xlsm workbook, maybe this:

Please Login or Register  to view this content.

Add this neart the top of your macro:

Please Login or Register  to view this content.

If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.

That macro had the fPATH hardcoded. Instead, how about a cell that let's you enter the folder? Then the macro cycles through ALL the files in that folder? Maybe?

I was talking about letting them save the files with whatever names they want, then let the macro simply import all the sheets in that known folder one at a time and "do something specific" with that data, then repeat with the next file until all files are done, all at once.

Then the files that folder are moved elsewhere so they don't get reprocessed later.

I'm suggesting we do them all. All that is needed is a full set of instructions of what is to be "done" with each file as it is imported. So far:

1) Get filename from folder
2) Open the file
3) Copy the data and paste into master sheet
4) Close the opened file
5) Move the opened file to another folder
6) ?? stuff do with data ??
7) ?? save somewhere with some name ??
8) Repeat steps above for each file in the folder

Will the folder only have ONE file in it? If so this is easy, if not, more troublesome plumbing.

Good evening,

Find bellow one image with written coments (i dont know how te explain)

Attachment 215162

I have six folder full of excel files and I want to merge one file from each folder (so six files)...and to select each file from individual folder to use for merging I want that excel displays for each folder list of all files in it so I can select the right one.

and the image

MERGE SELECTED FILES .jpg

This is what I've come up with so far. Put the path to the main folder where your sub folders are found in Template cell B3, then this macro will pop open to the main folder each over and over and let you select a folder and a file and copy it into your wb, it will keep popping until you click CANCEL.

Please Login or Register  to view this content.

Not sure exactly how to do that since you've indicated many folders as possible sources.

I don't understand what you're saying. The macro given will let you select files to open until you quit.