Hi All,
I have two workbooks one is target file.xls and another is source data file. Now I want to pull some data from source data file into target file using ADO method. In my target file in Column A starting from row 3 I have region names like AM, Pacific, Asia, UK etc. and in Column B against the above region I want to populate numbers i.e.. the amount paid to vendors and I have this details in source data file day wise. So now I want to see that on a particular date (which is entered in the cell B2 of target file) how much payment was made to different vendors in each region with the help of macro and at the same time I want a vendor wise amount split as well in column F & G in target file. Here is the code which I got so far.
I have attached my macro file as well for your reference.
Thanks a lot for your help in advance.
Bookmarks