How to create a list of units to show only those moving in the next 90 days?
I have a huge Excel list (I called Master Tracker; see screenshot) of units scheduled to move on a given date. I am using Excel 365. The list will capture one year ago from today and one year in the future from today. My master tracker is updated constantly as we add more units every month.
Master Tracker
Monthly, I create a roll-up report for my boss which I call the “Baseball Card”. I use a PowerPoint slide (see screenshot attached) to show only the units scheduled to move within the next 90 days but, I have been doing this manually and using the Master Tracker as my reference. The yellow portion in column B in the Master Tracker shows already the units that are within the 90-day window from “today” (5AUG24).
PowerPoint Baseball card
Tired of doing manual calculations, I took the Excel Master Tracker and created a second tab called Baseball Card (see screenshot attached). The purpose of this tab is to substitute the PowerPoint presentation (Baseball card) done manually to reproduce all my data by using Excel formulas as much as possible.
Excel Baseball card
I am doing well so far but the challenge I have now is to come up with a way to display a list (rows will vary depending on how many units) of “Forces projected next 90 days”. This list must display only the units (By MSC, by unit, and by country) within the next 90 days from today. I thought a Pivot table would do the trick, but I already tried and couldn’t figure it out. I really would appreciate any help on this.
I have a huge Excel list (I called Master Tracker; see screenshot) of units scheduled to move on a given date. I am using Excel 365. The list will capture one year ago from today and one year in the future from today. My master tracker is updated constantly as we add more units every month.Master TrackerMonthly, I create a roll-up report for my boss which I call the “Baseball Card”. I use a PowerPoint slide (see screenshot attached) to show only the units scheduled to move within the next 90 days but, I have been doing this manually and using the Master Tracker as my reference. The yellow portion in column B in the Master Tracker shows already the units that are within the 90-day window from “today” (5AUG24). PowerPoint Baseball cardTired of doing manual calculations, I took the Excel Master Tracker and created a second tab called Baseball Card (see screenshot attached). The purpose of this tab is to substitute the PowerPoint presentation (Baseball card) done manually to reproduce all my data by using Excel formulas as much as possible.Excel Baseball cardI am doing well so far but the challenge I have now is to come up with a way to display a list (rows will vary depending on how many units) of “Forces projected next 90 days”. This list must display only the units (By MSC, by unit, and by country) within the next 90 days from today. I thought a Pivot table would do the trick, but I already tried and couldn’t figure it out. I really would appreciate any help on this. Read More
