Need help copying daily figures from cells in multiple csv files

[emtangy]

Hi there,

I'm new to this forum and everyone seems really helpful so I'm hoping I have the capacity to learn something today
I have very limited VBA knowledge (mostly just use statements to get what I need done) and am trying to create a master spreadsheet. Essentially there is a folder that gets benchmark/indices values every day. In that file are 72 indices. I want to pull maybe 5 different index values each day and paste that into a master spreadsheet.
The csv with the index information is always named the same with only the date changing.
The format is like this YYMMDD_idxsummary_dbi.
At the moment I do a VLOOKUP but need to open up the files for the lookup to update and I need to manually change the date reference in the lookup formula. I know this is not an efficient way at all

Please let me know what you think

[Greg M]

Hi there,

In order to automate this process as fully as possible, it would be useful to know where the data (.csv) files are stored - are they in the same folder as the Master workbook? Are they stored in weekly/monthly folders?

If we know where they are stored we can open them directly rather than having to navigate to the folder in which they are stored.

Are data files processed on a daily basis? If so, we can use today's date as the default name of the file to open.

It seems that you're looking up Scotia Index values in Column B and returning Price Index value from Column E - is this correct?

Regards,

Greg M