Adding a Name to a Spreadsheet

[nic01scgt]

Hello,

I am splitting the cost of cable and internet with my roomates and I wanted to make an Excel Spreadsheet to keep track of payments. The sheet I made will work fine if only one person is paying, but I have 2 roommates who will be paying me money. Can anyone please help me with the best way of adding another person without just copying the sheet completely for the second person?

Thanks for all your help!

[Palmetto]

Insert another column to track the name of the person making the payment.
I would use a Pivot Table to calculate totals by month and individual.

BTW, it is generally best to post a sample workbook than an image of the workbook.

Post back if you more help.

[nic01scgt]

Insert another column to track the name of the person making the payment.
I would use a Pivot Table to calculate totals by month and individual.

BTW, it is generally best to post a sample workbook than an image of the workbook.

Post back if you more help.

I'm not very experienced with Excel so I'm not quite sure what you mean. I've attached the actual spreadsheet if you would be so kind as to get me started I appreciate all your help.

[Palmetto]

Take a look at the attached and see if this meets your needs. There are notes in the worksheet and some cell comments.

There may be a few features I've used that you will have to read up on to understand. See this link for good tutorials and downloads. Contextures

See this link for free basic Excel Training

Changes made:
1. Insert column for name of payee and apply Data Validation (List option).

2. Created Dynamic Named Range for the payment database

3. Created a Pivot Table to summarize the payments and balance due.

4. Automated refresh of the Pivot Table using VBA.

[nic01scgt]

Take a look at the attached and see if this meets your needs. There are notes in the worksheet and some cell comments.

There may be a few features I've used that you will have to read up on to understand. See this link for good tutorials and downloads. Contextures

See this link for free basic Excel Training

Changes made:
1. Insert column for name of payee and apply Data Validation (List option).

2. Created Dynamic Named Range for the payment database

3. Created a Pivot Table to summarize the payments and balance due.

4. Automated refresh of the Pivot Table using VBA.

Please forgive me if I am overlooking it but I do not see an attached file. Would it be attached under your message like mine was above?

[Palmetto]

Please forgive me if I am overlooking it but I do not see an attached file. Would it be attached under your message like mine was above?

Apologies. Attachment added to previous post.