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

Closed
polarstorm Posts 3 Registration date Tuesday November 25, 2014 Status Member Last seen November 29, 2014 - Nov 27, 2014 at 05:46 PM
polarstorm Posts 3 Registration date Tuesday November 25, 2014 Status Member Last seen November 29, 2014 - Nov 29, 2014 at 07:53 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Nov 28, 2014 at 09:59 AM
Hard to tell without knowing more about your criteria and data. One option is to use vlookup
0
polarstorm Posts 3 Registration date Tuesday November 25, 2014 Status Member Last seen November 29, 2014
Nov 29, 2014 at 07:53 PM
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
0