Macro to fill in cells based on 2 variables

Hi Guys, please see attached workbook.

this will be saved in a directory where there will be hundreds of .csv files. What i need is for each cell to populate when the macro is run with the value of a specific cell (stays the same every time) based on row 1 above the cell and column A.

i also need it to ignore if the file is not there.

for example - cell B2 needs to look for file name A2 & "Unacceptable" & B1.csv cell E2 and return that value. if that file does not exist it needs to just ignore and go to the next one. If you can help that would be awesome!!!

let me know if you need more detail

Its kind of liek a vlookup but i dont really want to name 1000 files that may or may not exist.....

hey Jerry - i am attaching a file .csv file example. if i use the code above it gives me an error - type mismatch.

the one i have sent you is for Q2 - through out the year there will be a file created with Q3 at the end and so on

i copied the changes in and still a type mismatch. sorry

i believe this is the line where the type mismatch is occurring

Please Login or Register  to view this content.

what this is doing is loking for file name on first rng through - 2unacceptable2.csv - does that help with identifying what to do to fix it?

i want it to read like the .csv file i attached above sorry Jerry. i was playing with it to find out where the error may be so i changed the f(csv) to = o so that i could see what the file name was called that it was looking for - thats where the 2unacceptable2.csv came from. so its not pulling the text from column A and its not putting a q in the file name

Ok Jerry - i had to add Q to the fcsv line and the workbook open line as per below. however now i click it and nothing happens at all....

Please Login or Register  to view this content.

What i mean by nothing is that the macro runs and no population of information happens

if i go step by step through the macro until i find a file that defineitly exists - that i see is that the line

Please Login or Register  to view this content.

leaves a value of zero when i hold the mouse over it.

Morning Jerry - well we seem to have moved forward a long way - when i ran the macro every single .csv file opened one by one which is great....unfortunately nothing was copied over though..any last thoughts?

i just did a trial - using only 1 row with a number that i knew existed in the directory. what i did was type the letter M into the Q2 corresponding row and when the macro finished running - the cell had been cleared. it just seems to be unable to pick up cell E2 from the .csv file...this is the only prob left

i have no idea Jerry - i changed the code to

Please Login or Register  to view this content.

and it worked fine. then changed it back and all that happened was all teh cells with completed in them were deleted....its really strange.

sent to you directly

file attached