hearsay9999
New Member
- Joined
- Jun 24, 2021
- Messages
- 3
- Office Version
- 365
- 2016
- Platform
- Windows
Good afternoon, I'm relatively new to VBA and brand new to this forum, (this is my first post). I have been struggling to find a way to line up a dynamic range with a static range. I have looked around on this and other forums for code that might help me with what I'm trying to achieve but so for no luck. Can anyone help?
- Column A - Dynamic date range, the number of dates listed will change.
- Column B - Static time range, this will not change and will begin with 00:00 and end with 23:30 going up by increments of 30mins
- Column D - This needs to be each date in column A replicated 48 times (for each 30 min interval in the day)
- Column E - This needs to be each time interval from 00:00 - 23:30 repeated for as many dates showing in column D.