Finding data in different Excel sheets with month-sort by VBA?

[Closed]
Report
Posts
3
Registration date
Tuesday November 25, 2014
Status
Member
Last seen
November 29, 2014
-
Posts
3
Registration date
Tuesday November 25, 2014
Status
Member
Last seen
November 29, 2014
-
Hello,
I have 2 workbooks named DB1 and DB2.The first one involves 12 sheets sorted by months names for example:"Apr-14" ,each sheet contains a table with several columns of data descending based on days of that month with format of dd-mm-yy.Next workbook involves some calculation based on data on first one.
How can i find data in each of these sheets (DB1)based on desired date i need for calculation(whenever i want to get history) in my DB2 by VBA?
Regards.

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Hard to tell without knowing more about your criteria and data. One option is to use vlookup
Posts
3
Registration date
Tuesday November 25, 2014
Status
Member
Last seen
November 29, 2014

Hi.At first thanks for your reply.I'm just a self-study beginner.
Consider that there is a table on first worksheet name'Jan-14' in DB1 as below:
ColA........................... 10 columns data ahead for each date...
1 01-Jan-14
2 02-Jan-14
3 03-Jan-14
4 04-Jan-14
.
.
First problem is how to find and collect data-at least 4 col- based on desired date in DB2 i.e finding/collecting data on 02-Jan-14 in this table by Vlookup?
As I mentioned,also each worksheet is for a specific month containing data belong to that month(it is a log sheet) like example above.So next problem is how to search and find exact month we need in DB1 and then extract data of those days of that month we need to report and/or make a trend based of them in DB2?
Regards