Budget and Debt Reduction Spreadsheet

[gapeach39]

I am not very experienced with Excel and I just want to create a simple sheet that shows my monthly bills. But, I want to be able to create a separate sheet in the same workbook that will take the amount paid on each bill (i.e. such as credit card bills) and pull it into the sheet which shows the beginning balance of each credit card and reduce it by the amount paid on the budget/monthly bills sheet.

Any ideas?

Thanks.

[Mayda89]

To accomplish this task, you need a unique identifier key for each bill.
For instance, lets say the credit card bill from bank a has the id 1, and the bill from bank b has the id 2 etc..
First, create a sheet, which has this id values in one column, and the amount owed in the other column.
Next, create another sheet, where again, you have the id values in one column, and amount paid in the other column.
Lastly, insert a vlookup function to a seperate column in the first sheet.

If you could just upload a sample workbook, I can do it for you.