I have created an Excel Template. In Access I export data from a query to the Excel Template which works fine and it opens the Excel template so I can see the data that it exported. With the Excel template still open, how do I, with VBA, insert a blank row when column A date changes?
Example in column A:
4/18/2022
4/18/2022
4/19/2022
When it hits 4/19/2022, I want the code to know it's a different date from the previous date and will insert a blank row "above" 4/19/2022. This will continue for all dates in column A until the end of the record so that each date change will have a blank row inserted above it.
Not sure if this should be code from Access that after the export then insert the blank row to the active/open Workbook or have Access run an Excel macro after export to insert the blank row. Your help is appreciated.
Thanks,
Ben
Example in column A:
4/18/2022
4/18/2022
4/19/2022
When it hits 4/19/2022, I want the code to know it's a different date from the previous date and will insert a blank row "above" 4/19/2022. This will continue for all dates in column A until the end of the record so that each date change will have a blank row inserted above it.
Not sure if this should be code from Access that after the export then insert the blank row to the active/open Workbook or have Access run an Excel macro after export to insert the blank row. Your help is appreciated.
Thanks,
Ben