So I am working on a budget spreadsheet, and I am trying to get a total on one worksheet to another. What coding would I use to have a total from cell K6 on the worksheet “paydays” to show up in cell C20 on “Bills to pay this paycheck”? Note I am a novice at excel, I can do a little bit of stuff on a single worksheet but not anything from sheet to sheet.
You can reference other worksheets in this form:
=SUM(paydays!A1:A3)
You just need the = followed by the name of the worksheet (paydays) followed by ! then the cell or range of cells.
Any formula can be built with that convention as well.
= then the name of the worksheet then ! then the cell reference. A range of cells is separated by a :
Thanks Shagnasty - you rock - it worked perfect!