jfshoemaker
12-04-2018, 05:23 PM
Hello!
At my work, we have an eLog that we make entries in every day, and I want use VBA to create a report that can pull up what happened during a particular day from it. The number of entries each day varies.
Here is an example of the starting data:
23341
And say I want my report to tell me what happened on December 4th, that section would look like:
23342
Ideally I would love to take it one step further and only copy specific columns, so that the report would only have the most important information. Example:
23343
Note, all dates would be grouped together, so it have to seek entries that are out of order (if that helps).
I’ve been searching around and googling how to make just the first step a reality, but I am currently stumped.
Any and all help is greatly appreciated.
At my work, we have an eLog that we make entries in every day, and I want use VBA to create a report that can pull up what happened during a particular day from it. The number of entries each day varies.
Here is an example of the starting data:
23341
And say I want my report to tell me what happened on December 4th, that section would look like:
23342
Ideally I would love to take it one step further and only copy specific columns, so that the report would only have the most important information. Example:
23343
Note, all dates would be grouped together, so it have to seek entries that are out of order (if that helps).
I’ve been searching around and googling how to make just the first step a reality, but I am currently stumped.
Any and all help is greatly appreciated.