2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Is it possible? Populate a cell from a separate sheet dependent on today’s date

Hi! I’ve spent a good hour trying to figure things out on my own, but I figured asking wouldn’t hurt.

I have a spreadsheet listing out topics that rotate on a monthly basis. I want the title of that theme to auto-populate on a different sheet in the same spread so that it changes on a monthly basis, and for them to be the same in case the original topic changes as well

I can get so far as to have the cell match the title using =‘2026’ ! Cell, but is there a way where I can get it to change based off the date?

The original spreadsheet (not designed by me) is separated into columns titled Month, Location, Theme, and for some reason Date Range, though it’s always the beginning to end of the month. From there, we have 11 rows to each month. The only data that changes is the Topic. I am needing to create a new sheet based off these topics with additional information, but since the topics are subject to change, I’d like them to be attached to the original spreadsheet.

submitted by /u/asclepicats
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#cloud-based spreadsheet applications
#Excel alternatives for data analysis
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#generative AI for data analysis
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#rows.com
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#spreadsheet