Forum Discussion
excell spreadsheet help
i need help setting a up the spreadsheet to calculate monthly payments to keep track for the year i also need all the sheets to match, can you help?
Hello kaa2014,
Yes, that can be done.
Please upload the workbook. If it contains personal or sensitive information, upload a copy with that information removed.
It would also help to know:
- Which version of Excel you're using.
- Whether you want one worksheet for each month or a single worksheet for the entire year.
- Which columns you want to include.
- How you want the monthly and yearly totals to be calculated.
Once I see your current layout, I can help you create one template sheet, copy it to the remaining months so they all match, and add the formulas needed to track your payments throughout the year.