Group several Excel files into only one or into Access

[Nelzon]

Hey Everyone!


So the goal:

I have hundreds of Excel files that because I have to, they are updated individually, but to consult it becomes really complicated.
I know it exists a way to have them grouped into only one Worksheet in Excel or into one Table in Access, and when I update the files individually they should reflet into the grouped data.

What are the steps for this?

Thank you all so much!

Regards!

[Nelzon]

No one to help me?

[Alf]

I think you need to give more information about your problem.

Are all files in the same folder? If so are a number of macros that will loop through a folder finding all files.

When a file is found does it contain one or several sheet? Should macro copy one sheet to target file or just some selected ranges from the different sheets?

Also I would recommend uploading a sample file + a master (target file) what should be copied and how it should be pasted to target file.

Alf

[getvarunhere]

I Think you are not clear with the exact requirements... Are all the excel files follow same data format????


Varun

[Nelzon]

You are right, I need to be more specific.

The files are on different folders, the files only have one sheet and they share the same row details, meaning that the data will be compatible since:
All the files have the same rows, for example:

Row A: URL
Row B: Title
Row C: User
Row D: Type

the goal is to gather all those hundred files into only 1 file and update each one individually and reflect the changes on the main file.

[getvarunhere]

Use recursion to access all folders n sub folders for excel files.... check the headers present if any. If not then check whether the number of columns is 4 or not... get those values to single gile

[Nelzon]

How can I do that? Cause i am really null in Macros...

[Hemant Verma]

Please more Explain your Query