DVRCOLthrBearChub (he/they)Nov 22, 2022
#excel Help needed: I have this workbook that I need the data from the current date from the range above to populate in the Today column on Sheet 2. I.e. 1/2/23 only. But I need it to auto update daily. I'm not good with macros at all, so I'm hoping this is a simple formula
Show threadSwitch LondonNov 22, 2022

@DVRCOLthrBearChub couldn’t be easier in fact!

=TODAY()

will return todays date and auto updates anytime the doc is opened or altered. :)

Show threadDVRCOLthrBearChub (he/they)Nov 22, 2022
@switchldn I know of the today function, but will it pull the data from Sheet 1 automatically?
Show threadSwitch LondonNov 22, 2022
@DVRCOLthrBearChub I’m pretty sure it should as long as your sheet1 dates are formatted as dates! Then if you use HLOOKUP to compare today Vs row 1, to return the relevant team row below it (team A on row 2) etc. I’m only on my phone right now so can’t validate it, but I’m fairly certain I’ve done this before now!
Show threadSwitch London

@DVRCOLthrBearChub ie replace B1 with =TODAY() then in B2 enter

=HLOOKUP(B1,Sheet2!B:E,2,TRUE)

That shooould return A’s shifts. If it fails, try FALSE instead- in case today() is a time stamp and it needs near match- it’s been a while!

Nov 22, 2022 at 11:17pmWeb
Show threadSwitch LondonNov 22, 2022
@DVRCOLthrBearChub sorry B1:E4 , not B:E
Show threadDVRCOLthrBearChub (he/they)Nov 23, 2022
@switchldn ok, so if I wanna do the same for B and C shifts or let's say I have A-Z staff members, how do I change the formula so each member's shift shows. Do I have to edit each cell or can I just drag and fill?