How to add a sheet
Welcome Suny,
This is how I do
If it is extra data to one of existing sheet just cut and paste in the end. But be careful not to create duplicates.
If it is a new sheet
I open all_cons and the file which has the sheet to be added.
1) Select the sheet to be added
2) Right click and choose move or copy
3) Expand the to book and change the sheet name to all_cons
4) Scroll in the box before sheet and pick the sheet before to copy.
5) Click/Select the create a copy button
6) Click Ok
That is to copy the sheet to all_cons.
To add in the summary sheet
1) Go to Summary sheet in all_cons.
2) Select the row above which to create the new row. I normally select the full row by clicking on the row num.
3) Right click , Copy , Right click, Insert copied cells.
Change the the First three columns SRC0x-xxx , name and Notice date in the copied row. What really matters is only the first column.
I normally keep the calculation turned off , just to avoid waiting to finish recalculation every step. In the end either turn on calculation or just press F9
Counts sheet.
It is not updated automatic. I am not sure it is worth the overhead even if we make it auto. The only purpose is to look at couple of things like Monthwise % completion, Cumulative count of pending 485 etc ( That is how many to go). To me if we can update once a month or so it is fine.
Here is what I do to update .
Expand all subtotals, Remove all subtotals.
Copy summmary sheet columns up to Bal column.
Paste values to count sheet. Put the subtotals back and click Level 2 to hide the detail rows.
--pr
