diamondjoechubbs
New Member
- Joined
- Oct 26, 2020
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
It has been a while since I've used excel in a job setting, so forgive me as I am trying to dust off the cobwebs.
Every morning I import data from a report into a new sheet that I name simply with that date. I then use the following formula to pull the information I need from that sheet into my data tracking sheet =XLOOKUP($D2,'10.23.2020'!$A:$A,'10.23.2020'!$D:$D,"D.N.W.")
Is there a way, since the sheet name is only the date, which is also the first row on that spreadsheet, to automate the sheet name so that it pulls it every day so that I don't have to find and replace?
Every morning I import data from a report into a new sheet that I name simply with that date. I then use the following formula to pull the information I need from that sheet into my data tracking sheet =XLOOKUP($D2,'10.23.2020'!$A:$A,'10.23.2020'!$D:$D,"D.N.W.")
Is there a way, since the sheet name is only the date, which is also the first row on that spreadsheet, to automate the sheet name so that it pulls it every day so that I don't have to find and replace?