I have an excel file that is essentially acting as a database of information.
I am looking for a macro that you can enter two dates in to a driver tab and then run, and it will search for all the all cells that has a result between those two dates across multiple columns, and return data for each of those dates.
I have attached the file. As an example and to be more specific, I would want to enter in say 1/7/18 and 31/7/18, and it will return a list of all cells from columns O to BE where there is a date in between the 1st and 31st July 2018.
The output I am ideally looking for would return the following information for the item that it finds (in three columns):
- The Trading Name (Column C of the date found)
- The Product Type (Row 2 of the date found)
- The date that has been found
eg: Company 13 | Product 1 | 18/7/2018
(Note: All dates are in non-American format).
Please let me know if you need any more explanation.