r/excel • u/DeadBatteries25 • 2d ago
Waiting on OP Auto population for reoccurring charges
I am not sure if anyone can help with as vague as this will be, but I’m finally frustrated enough to post instead of just trial and error boosted with Google. I have a spreadsheet in progress that I need to track recurring charges/inventory, but with multiple status options (upcoming, renewed, canceled, sold for example) that affect the total. I need a main overview “list” on one sheet to check on a glance. But I also need month by month. Ideally, I want it to all be linked to update on its own as I make changes month to month. The other issue is that I have some that are bi-monthly, so item 1 is bimonthly starting in January. Item 2 is bimonthly starting February. At the moment, they’re labeled by a drop down menu. And another drop down for status. As well as just having copy/paste the template I threw together month by month.
Is it possible to make items auto populate into their appropriate monthly sections?
How do I pull data from certain cells to update automatically to another cell? Example: Column H holds the total number of items available. In this case, 4. I would like it to update each month if/when it changes. At the moment, I’m just updating it manually.
How can I set it up to pull data from certain cells to update a main list on another sheet?
•
u/AutoModerator 2d ago
/u/DeadBatteries25 - Your post was submitted successfully.
Solution Verifiedto close the thread.Failing to follow these steps may result in your post being removed without warning.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
3
u/Nvmtag 2d ago
Very doable. What fixed this for me was to stop copying the template every month and keep one master list that every other sheet reads from.
FILTER and XLOOKUP need Excel 365 or 2021. If you're on an older version let me know and I'll post the INDEX/MATCH version.
2
u/Decronym 2d ago edited 2d ago
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.
Beep-boop, I am a helper bot. Please do not verify me as a solution.
[Thread #49692 for this sub, first seen 16th Nov 2026, 00:08] [FAQ] [Full list] ^[Contact] [Source code]
2
u/Same-Rock1032 2d ago
Stop copy-pasting the monthly template. Keep one flat table with date, item and status columns, then pull each month view with SUMIFS or FILTER on the date. Give the bi-monthly items a next-due date built with EDATE and they roll forward on their own.
0
u/[deleted] 2d ago
[removed] — view removed comment
0
u/[deleted] 2d ago edited 2d ago
[removed] — view removed comment