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?