Hi everyone,
First time poster here - I'm pretty rusty on my vba (haven't used it since high school to be honest!)
I have a workbook that contains an inspection sheet with a list of assets. This sheet contains all the data that I need to export to a cover sheet (called RCR).
I need the macro to skip blank rows and only return data if it matches the current date and within a certain time range. The time ranges are 9am - 12pm, 12pm-5pm, 5pm to midnight.
Can someone help me with this?
Thanks,
Jessica
First time poster here - I'm pretty rusty on my vba (haven't used it since high school to be honest!)
I have a workbook that contains an inspection sheet with a list of assets. This sheet contains all the data that I need to export to a cover sheet (called RCR).
I need the macro to skip blank rows and only return data if it matches the current date and within a certain time range. The time ranges are 9am - 12pm, 12pm-5pm, 5pm to midnight.
Can someone help me with this?
Thanks,
Jessica