•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formatting spreadsheet to automatically update time per column entry
Our take
Are you frustrated with manually tracking dates and times in your spreadsheet? Imagine having your Column A automatically update with the current date and time whenever you modify an entry in Column B. This transformation is not just a dream—it’s achievable with the right approach to Excel's VBA. In this guide, we'll simplify the process and tackle common pitfalls, including how to set up your code effectively. Let’s unlock the potential of your spreadsheet and enhance your productivity!
Hello, all. I have a fairly simple spreadsheet layout, consisting of 3 lists. I'm concerned with the 3rd, where I need Column A, Date, to automatically add the current date and time when the corresponding row in Column B, Activity, is modified.
I've followed a few tutorials, and while this works perfectly fine in a new document, I've found I:
A, don't know how to invert the column relationship
and
B, cannot get even the basic, otherwise functional code to work in this spreadsheet.
I'm losing my mind. I've looked everywhere for what could be the issue, but haven't found anything. The file is saved as .xlsm, I am entering the VBA code into the little pop-up window into the List 3 section, not ThisWorkbook or a different one.
I apologize in advance, as I'm quite new to Excel and have only had very basic experience prior.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Is it possible? Populate a cell from a separate sheet dependent on today’s dateHi! 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]
- Issue with spreadsheet containing time calculation formulasI have a new clock in/out machine which has 3 columns, 1 for clock in, 2 for clock out and a 3rd column for the total time worked. Staff can clock in/out multiple times a day. It comes to me as an xls file with all the in/out cells as 'general' format and the 3rd column is as custom hh:mm but not the subtraction formula to show the total time worked even though the numbers are right. If i change the in/out from general to custom and then hh:mm I seem to have to click each individual cell for the format to change from (ie) 09:58 AM to 09:58 without the AM but the PM cells still show PM and when i do the subtraction formula for the total time worked it comes out as an error value, no amount of trying different formulas will change it to what it needs to be. I don't mind the first 2 colums showing as AM/PM but even with them that way the subtraction for the total time calculation still comes up as with a 'value' error https://preview.redd.it/hvunwr4p58og1.png?width=512&format=png&auto=webp&s=c11e3a1b77c137a4a40544c7bb2274e813d1038c submitted by /u/Loud-Conference8055 [link] [comments]
- 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]
- 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]