Hello
My situation is:
I have an excel file which i use as my template, and i want to place data from a list of .xls files. I want to be able to run a macro which prompts me with a list of files i have in the G:\MyFolder, and then when selected it opens the file. I then want to copy the data in column C from this opened file and paste it into column A on my template (where the macro was run), I then also want it to copy the J2 cell and paste it into P3 cell on my template. I'm hoping someone can help me.