•2 min read•from 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
Our take
Are you struggling to keep your spreadsheet updated with monthly themes that change based on today's date? You’re not alone. Many users face this challenge, but there’s a solution that can streamline your workflow. By utilizing a combination of date functions and references, you can auto-populate a cell in a separate sheet with the relevant theme, ensuring it stays current as original topics change. Keep reading to discover how to implement this intelligent connection and simplify your data management process.
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.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to auto-populate days between last day entered in column and today's date.I'm going to try my best to explain this with words and samples of my data/spreadsheet. I'm a wannabe author, and I love keeping track of how many words I've written per day. I used to use NaNoWriMo to keep track of all that, but they went under last year. Thankfully I'd moved all of my daily data into a spreadsheet I made a year ago. But now that I'm getting back into writing, I want to make some changes to the spreadsheet. This first image is a sample of the most recent dates I'd built into the spreadsheet and is the source of my main frustration. As it is right now, I have to manually drag down the formulas until I hit today's date (whatever the date is when I need to open the spreadsheet and update it). I'm much busier in life now, so there's often several days between writing days. Is there a way to have the spreadsheet automatically populate the rows with all the days between the last day in the spreadsheet and today's date? https://preview.redd.it/ijgi3gui8aug1.png?width=879&format=png&auto=webp&s=2553b92564abdebf80a0fc1d82d5f3b2e83606e2 For example, let's say today is 5/21/2025 and I open the spreadsheet. What I want is for the table to automatically expand so that A416 has the date 05/20/2025 in it and A417 has the date 05/21/2025 in it. And the rest of the rows have the corresponding data as well. I'm sure this would require macros or VBA or whatever, which I've dabbled in before. Assuming it is even possible. Also, a minor issue I'm less worried about: I have these graphs in the second image that were inspired by what NaNoWriMo used to do for me. But for some reason, only the daily word counts graph updates to the most recent date in the table when I refresh the data. The total word count graph is stuck with the end of the x-axis being the day I created the spreadsheet (4/2/2025). https://preview.redd.it/5d3wxf4x9aug1.png?width=1349&format=png&auto=webp&s=92b4a9c077cd08f4d5f236f49cd3ed79c0f1db1b submitted by /u/Striker_EZ [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- Conditional formatting date help neededI've been trying to use conditional formatting to help automate my work spreadsheet and the date formulas truly escape me. I feel like TODAY is a meany who likes to stick their tongue out at you and point for being stupid XD. This is a spreadsheet with a schedule on it. I am trying to get it to automatically grey out the text when the date passes so I can sort and filter by color and always keep the next upcoming appointment slot be top of the list, while still keeping the data in this sheet because another sheet refers to it via XLOOKUP. https://preview.redd.it/z1jqata8w6xg1.png?width=364&format=png&auto=webp&s=d49f71c8de80c402de1af923fc87e3371d606cc8 Here's the formula I'm using =AND($B$2<TODAY(), $D$2<> "") Column D is client names, for privacy purposes I didn't copy that. They end at D11, if it matters. I'm not sure why excel is treating the dates in May as if they are less than today, when they're not. Does anyone have any ideas? submitted by /u/tashykat [link] [comments]
- Change Sheet reference based on cell valueHopefully the title makes sense. Below is a snippet of what I'm working on. What I'm wanting to do is have the data table being referenced in the VLOOKUP change depending on the cell value above it. Right no I've just been manually changing each one to match. This is fine busy work but I get antsy after Data20. https://preview.redd.it/uov729eulztg1.png?width=803&format=png&auto=webp&s=6a2027958c3e56fd7f9800fcb8fa603092effb61 I'm also open to other ideas if you have them. Thanks! submitted by /u/BagConfident2457 [link] [comments]
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