how do I combine multiple excel files into one?
 

If the files I am trying to combine have blank cells within the data is there
a way to skip the blank cells?

how do I combine multiple excel files into one?
 

On 12 Nov, 20:53, Stephid707
wrote:
If the files I am trying to combine have blank cells within the data is there
a way to skip the blank cells?

I wrote a macro that processes all files in a folder and copies their
worksheets to another file. Is this what you need?