When I first started in 2024, entering an amount in a cell under “Categories” would automatically populate the subsequent cells in the same row with the same amount. However, after adding new columns for Jan 2025 and beyond, the amount entered in Dec 2024 no longer auto-populates for the new months. How can I fix this?
Welcome,
There’s a formula in each of the cells that is equal to the column to the left of it is how it works
So for example if dec is in column ab
Then january’s cells would be =AB4 if row 4
1 Like
You just need to drag or copy/paste the formulas from another cell into the Jan 2025 rows.
2 Likes