Row number to show by date

PieterGrove · Jul 11th 2018

Hi there,

I have a basic data sheet 1 with rows numbered from 1-31(Column A). Column A represents days of the month and have relevant data in Columns B to J
Would like to have number 1 with relevant data highlight on the first day of the month, Number 2 with relevant data highlight on the 2nd day of the month and so on. Also then have the highlighted row with data show on Sheet 2. Any suggestions please?

chirayuw · Jul 11th 2018

see sample. conditional formatting does the highlighting. vlookup does sheet 2

PieterGrove · Jul 12th 2018

Perfect thanks. Looking at the numbers in Columns B to J, I am looking for a code that would randomize these numbers on the first day of the month. Can this be done?

chirayuw · Jul 12th 2018

There's a formula called Randbetween that lets you set a low and high number between which to randomize your data. That's what I used and then value pasted. So you could do the same on the first day of each month. the issue is when the first day falls on the weekend.

PieterGrove · Jul 13th 2018

Ok, can you please add sample?.

chirayuw · Jul 13th 2018

attached same file with formula

PieterGrove · Jul 13th 2018

Awesome, thanks you have been a great help.

Row number to show by date

Participate now!

Share