Hi everyone,

I have been asked to create an easy and organized billing grid for my work, and I know how I would like it to work but I'm not sure if it can be done with excel or how to set it up. For reference, I am using excel 2010 on a PC with Windows XP.

Here is what I want to do:

I would like to create a master sheet that contains a single row and the user will enter data into each cell of each column of that row. Once it's entered, a new table row will be created in another designated page (depending on information entered) and will save the information on that page. The information on the master page will then clear so that more data could be entered, which will be filed into it's own designated areas and so on.

I would like table on the master page to contain these columns: "Calendar Year", "Month Billed", "Client", "Product Name", "Project Title", "Account Job #", "Amount to Bill", "Estimate Amount Approved By Client"

Then, there will be other sheets for the different calendar years (2011,2012,2013) where they will automatically be filed. When they are filed, I also want them to be grouped by their product name and then organized numerically by job # in that product name group.

To make things even more difficult, the table in the master sheet won't have the same number of columns as the tables in the other sheets, because I would also like to include columns for "Total Billed to Date" and "Balance Remaining on Estimate" along with the columns from the table in the master sheet.