Excel makro

[Tyloendis]

Hi! Is this possible via makros?
I have workbooks for each day of the week. Their name contains the current date. Is it possible to write a makro, that can import all these workbooks into one sheet? Next to each imported content, the date would be there(from the name of the files).
If there would be newer workbooks, they could be imported too.

 

[mrbeanyuk]

Hi! Is this possible via makros?
I have workbooks for each day of the week. Their name contains the current date. Is it possible to write a makro, that can import all these workbooks into one sheet? Next to each imported content, the date would be there(from the name of the files).
If there would be newer workbooks, they could be imported too.

Do all sheets have the same type of data in each column or row?
Do you want the data to merge into one long list or into a format?

A little more clarity on what you want to go where would be useful.

N