•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Pull data from a sheet with latest date value in a specific cell, automatically expand to new sheets
Our take
To streamline your data management across multiple sheets, you can automate the process of retrieving the latest date and corresponding values. By examining all sheets in your workbook, including newly added ones, you can identify the sheet with the most recent date in a specified cell, such as A1. Once this date is found, you can easily copy the value from another designated cell, like C1, ensuring you always have access to the most up-to-date information from your dated logs.
Here's what I am trying to get done:
- Look at all sheets in the workbook, including the newly added ones.
- Find all sheets that have a date in a specific cell, let's say A1.
- Find the sheet with latest date.
- Copy value from another cell in that sheet (say C1) as formula result.
The idea is to pull the latest value from dated logs.
TIA
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Pulling data from one sheet based on a columnApologies I’m not that experienced with Excel. I have a sheet with dates that a task needs to be completed (sorry for the photo of a screen but work IT won’t let me screenshot). I have a Master List sheet of all dates due (column D adds 48 weeks to Column C and Column E extracts the month from D). I want a sheet for each month and for each month’s sheet to pull the IDs from Column A so we can just look and see which tasks are due in e.g. January. And so that all are visible in the Master List so we don’t end up with duplicate IDs (column A has highlight rules for duplicates). I tried google and think it might need VLOOKUP but couldn’t seem to get it to work. Thanks. submitted by /u/arrianne_ [link] [comments]
- 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]
- Pulling data from a different workbookI think I know how to do this, but there also seems to be several methods and I want to know which is best. I pasted a simple example below. Basically, I will have a workbook already made (on the left) and I want to create a new workbook that will pull data from it as shown below (I may want cell A1 on the new workbook to pull from cell A2 and want it change if I change it on the original workbook). First, what is the easiest method to do this? Secondly, what do I need to be aware of (such as will it affect things if any of these files get relocated)? And finally, in my original workbook, I tend to add columns to it frequently. A good example will be in this one shown, I will eventually add May to column E. When that time comes, I would like to just be able to copy D1 over to E1 in the new workbook and have it know that I want it to actually pull from E2 rather than from D2. https://preview.redd.it/pd8jrm2z8xig1.png?width=1601&format=png&auto=webp&s=668d16961f4c3aa8f041743a984e054d2a9e8387 submitted by /u/dtman33 [link] [comments]
- Consolidate data from different worksheets with final information coming from a combination of the worksheetsHoping for some help on a problem I can't wrap my head around. I need to consolidate some information from 12 different tabs (one data pull per month) into one worksheet with some of the data needing to be overridden and some needing to stay. With the most recent pull of the data not necessarily being the information I want showing, I'm not sure how to proceed. I'm trying to find a way to create this and pass it along to someone else to just load data and it automatically puts out the result I'm looking for. For instance, I pull information from my system in January for the entire year (broken into monthly buckets) and all of that is perfect. My second data pull of the year in February isn't so clean. I need to see the numbers from January on any of the January data (because it zeros out in February in my system) but everything related to February through December needs to be from the most recent data pull. Third pull of the year in March, I need to see the numbers from January and February for the January and February data and then need the new info for March through December. Basically, by the time December rolls around, I need data from all 12 sheets. Hopefully this makes sense. Any thoughts on how I can accomplish this in Excel? submitted by /u/megd726 [link] [comments]