Hi,

I did some searching but couldn't find an answer. I am far from an excel expert or to be honest a computer wiz so I apologize in advance. I'm guessing that the problem I have is no more then the click of a few buttons if it is possible to fix. I currently use an excel (version 2010) spreadsheet to pay invoices and track expenses prior to sending the information to my accountant. I have a data input table, where I enter in the company, the amount of the invoice, the cost, paid yes or no, etc. Once I have entered my data, I can click on my pivot table which will show my all my suppliers, invoice costs, the months, etc.

Once I have my data inputted, I can click on the totals in my pivot table. This will open a new sheet (ex sheet20) which shows me a breakdown of the invoices that make up the totals shown on the pivot table. I then use these sheets of data to write checks to suppliers. My problem is that I cannot edit the information on the data entry table through the new sheet. So when I'm done writing the check, I close the sheet and manually go back to my table and edit the initial data so the the invoices show up on my pivot table as paid.

So, is there a way to edit the information on the data table, but editing it on a new sheet? Does that make sense?

Thanks everyone, I appreciate your help in advance.

-pat