Hi I am a newbie in vba and would like to seek help in a problem that I am facing. I am using excel 2003.
I have 15 similar files in which I want to extract data using vlookup. The range to look for is F3:T43, and the info I want to extract are in column 2,5,6 and 7. I want to put these into a new worksheet.
Manually I know how to do this. The formula that I would key in the cells would be something like ths
= vlookup(cell(j,i),F3:T43,2,FALSE) then for adjacent cell
= vlookup(cell(j,i+1),F3:T43,5,FALSE) etc
But I am not sure how to write a VBA to loop this through all the 15 files and put the values in sequence; ie for first workbook the data extracted will be stored in column c,d,e and f. While for the the second workbook into column g,h,i and j. Then I have to repeat that for j no of rows that I have.
Appreciate if anyone can help.
I have 15 similar files in which I want to extract data using vlookup. The range to look for is F3:T43, and the info I want to extract are in column 2,5,6 and 7. I want to put these into a new worksheet.
Manually I know how to do this. The formula that I would key in the cells would be something like ths
= vlookup(cell(j,i),F3:T43,2,FALSE) then for adjacent cell
= vlookup(cell(j,i+1),F3:T43,5,FALSE) etc
But I am not sure how to write a VBA to loop this through all the 15 files and put the values in sequence; ie for first workbook the data extracted will be stored in column c,d,e and f. While for the the second workbook into column g,h,i and j. Then I have to repeat that for j no of rows that I have.
Appreciate if anyone can help.
