Hi,
I am looking for a macro to pull the data based on Date from the other files i.e Vijay.xls and Anand.xls
Is it possible to entered the Date using input box? or Date can be entered on the cell and have the results pulled from other files below rows.
Regards,
Vijay
Instead of a Macro, I think that an easier way to do this is run a couple of MS Query. MS Query comes installed in Excel. Here is a tutorial on how to use it.
http://www.exceluser.com/explore/msquery1_1.htm
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Where do I get the MS Query?
It is built into your excel program. In Excel 2003, it is on the Data--->Import External Data--->New Database Query.
By this i'll have to create one by one Query to pull data from each file.
I thought macro will be easy and could someone help me on that.
You can use a macro to run the SQL statement. How many files will you be looking to grab data from? If only two, then you could modify your VBA to run one SQL statement and then the next.
The above is an example of a SQL statement that could be incorporated into your VBA. This was extracted directly from MS Query.
Please Login or Register to view this content.
Alan
I'll be using from 10 different files and the date will be based on my input and not to be stable search.
Could someone help me on this request
Here's another solution since you didn't want to use MS Query.
http://www.myonlinetraininghub.com/e...ultiple-sheets
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks