Ideas on how to track multi-year balances that consist of 8 columns/year

[georgemaka]

We currently use Excel to track the year-end balance of 20 different people. Each person is listed on the left hand side, and then year year has 8 columns of items that effects the year end balance. Rather than scrolling to the far right for every year, trying to gather ideas that will allow me to display prior and current year balances for each column as well as gather the data in a better format. I know this is a shot in the dark, and may be hard to understand without seeing, but though I would throw it out and see if any ideas are out there.

[alansidman]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Look at the yellow banner at the top of this screen.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.