James Niven
11-14-2019, 03:48 AM
Hi there,
So, I have created a logging template for my listening hobby.
I would like to create a macro that will do the following to each block on each tab.
I would like enter in the UTC time and then delete the other rows that do not equal the UTC time entered, but leave a row above and below the entered UTC time. The UTC times are listed down column A.
On the tab 530-590 the cell with 530 at A5 is the frequency, numbers on row 6 across the screen are the minutes.
Next, I would like to entry in the minutes when I will start listening on this listening session.
So, if the minutes are 58-02, then I would like that range to be shaded in yellow on each frequency block and each tab.
So, for example if I was listening at 0458utc and ending at 0502utc, all the other rows would be deleted except the 0400 and 0600 and 58-59 would be highlighted in yellow as well as 00-01-02 would be highlighted in yellow. Hope this makes sense.
I have included a demo tab on my attachment to what I am looking for.
I know some VBA, but unsure where to start on this.
Thank you in advance for any help offered.
So, I have created a logging template for my listening hobby.
I would like to create a macro that will do the following to each block on each tab.
I would like enter in the UTC time and then delete the other rows that do not equal the UTC time entered, but leave a row above and below the entered UTC time. The UTC times are listed down column A.
On the tab 530-590 the cell with 530 at A5 is the frequency, numbers on row 6 across the screen are the minutes.
Next, I would like to entry in the minutes when I will start listening on this listening session.
So, if the minutes are 58-02, then I would like that range to be shaded in yellow on each frequency block and each tab.
So, for example if I was listening at 0458utc and ending at 0502utc, all the other rows would be deleted except the 0400 and 0600 and 58-59 would be highlighted in yellow as well as 00-01-02 would be highlighted in yellow. Hope this makes sense.
I have included a demo tab on my attachment to what I am looking for.
I know some VBA, but unsure where to start on this.
Thank you in advance for any help offered.