Macro to copy data from multiple files to one master

'CSVs To One Sheet (Stacked)
To get you started, here's a macro for importing all CSV files in a folder into a single Excel sheet, each CSV filename will be listed on the sheet next to the data that it came from.

CSVs to 1 Sheet - Part 1

You'll want to edit this line of code:

Please Login or Register  to view this content.

...perhaps to:

Please Login or Register  to view this content.

Hi JB,
Thanks for the reply, appreciate a lot,

I commented the lines that adds the CSV names, as i do not need them in my final sheet, but for some reason when I run the Macro it gives me

"Subscription Out of Range Error" and when I go into Debug mode it highlights the beow line of code.

: Set wsMstr = ThisWorkbook.Sheets("SLC Master")

Now like I said, all my csv files and master csv file is in the same folder. Master CSV file hs all the heading and the Sheet Name is Master SLC.

What am I doing wrong here.

Here is the code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

An error on that line of code could mean:

1) The sheet doesn't exist in the workbook where the macro was installed
2) The sheet exists but is misspelled in some way... missing or extra spaces, maybe?

Sorry about the rules, I thought the thread was most closest to what I was looking for but will keep that in mind.

So Far,

I have 500 plus files, where some start with Column A Row 1 as "lost frames" header with data and other start with Column A as Row 1"sync loss second", Column B Row 1 as "Link Loss Seconds and then Column C as "lost frames". How do I insert two blank rows at the starting to all the files that has Column A as "lost frames".

if I do this, then I am able to add columns in front of Column A where Column A1 valus is lost frames.

Please Login or Register  to view this content.

But for other files where the 1st and 2nd Column are Column A as "sync loss second", Column B as "Link Loss Seconds, I want to use the range that only checks lost frames for column A1. if not do not do anything. Because the above code will still search for Row 1 for lost frames string and will add two additional rows in front since all the files do have the lost frames in either A1 or C1

Thanks
Deepak

Your sample code seems correct. maybe:

Please Login or Register  to view this content.