Hi,
I am trying to work on one macro and in that in macro I want to get values of Column A, B, and C of all workbooks attached(workbooks closed at the same time) to the open workbook(LAP_information required).
Criteria for getting values will be the country( Country will be given in column G in all workbooks). I will select any one country from the given drop down in LAP_information required workbook, and then by pressing 'generate' button, I want macro to fetch all the values for that particular country from other closed workbooks into this single workbook.
I have attached all workbooks, LAP_information required work and the other three workbooks.
Could someone please help me out on this?
Thanks in advance.
WORKBOOKS.ZIP
Bookmarks