sparky
It is easy as was posted by kinetic when you right click the page tab on the bottom you are given an option to add a sheet and also to rename the sheet as in bedRoom-1. The name will need to run together and not have any spaces. OK so say I have added a column of numbers and have my total for that column in D52 I can take that information and copy it to any sheet. Just go to ,Let's say, the summary sheet and type in -
='PageName'!D52
PageName will be what ever you decided to name that page.
Also, If you set up a template sheet on say page #1 You can right click in the very top right of the page and hit "copy" then go to the next page, click the top left corner right click and hit "paste.
You can create some really cool spread sheets this way. I usually send my proposals over a fax. So my first sheet is a fax cover and my second sheet is my proposal My estimate sheets are stacked up behind these and my summary is the last sheet. I only need to type in the recipients name,fax,job, etc and the info is copied to any cell I wish on any sheet.
What is great about a summary sheet is that you can set cells up to change say sales tax rates or labor rates or profit percentages one time and all the math is taken care of. Even your final price can be put on your proposal sheet automatically.
I tried to paste in the bottom part of my summary sheet but it did not show the cells in perspective. However, it might give you some ideas.
Total Material $1,445.00 Total Hours 8.00
General Conditions 1.50% $21.68 10.00% 0.8
Total Material $1,466.68 Total Hours 8.8
Tax Rate 7.20% Labor Rate $50.00
Tax Total $105.60 Labor $ $440.00
Material and Tax $1,572.28
Labor Amount $440.00
Material and Labor Total $2,012.28
Overhead and Profit Percentage 15%
Overhead and Profit Value $301.84
Sub Total Job Value $2,314.12
Permit
Fire Alarm Permit
Total Job Value $2,314
Overhead and Profit + Labor $741.84
