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
polarstorm Posts 3 Registration date Tuesday November 25, 2014 Status Member Last seen November 29, 2014 - Nov 29, 2014 at 07:53 PM
Related:
- Finding data in different Excel sheets with month-sort by VBA?
- Number to words in excel without vba - Guide
- How to sort bookmarks in chrome - Guide
- Enable vba in excel - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Vba case like - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Nov 28, 2014 at 09:59 AM
Nov 28, 2014 at 09:59 AM
Hard to tell without knowing more about your criteria and data. One option is to use vlookup
polarstorm
Posts
3
Registration date
Tuesday November 25, 2014
Status
Member
Last seen
November 29, 2014
Nov 29, 2014 at 07:53 PM
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
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
