Okay, I assume you have five sheets called Monday, Tuesday etc to
Friday, and that you have another sheet called Summary. I also assume
that the five daily sheets are identical in layout, with a header row
in row 1 and data below that.

To insert a new blank row in each of those 5 sheets, the easiest way
is to group the sheets together first and then do the actions once -
these actions will apply to all grouped sheets. So, select the Monday
sheet, and then hold down the CTRL key while you also select the tabs
for the other daily sheets. The tab colour will change, and you will
see Group in the title bar. Select row 1 of the visible sheet by
clicking on the row identifier, and then click on Insert | Rows. Now
you will have a brand new (blank) row at the top of those sheets.

I assumed earlier that the data to be totalled is in column F, so
position the cursor in F1 and enter this formula:

=SUM(F3:F10000)

Now you need to ungroup the sheets, and the quickest way is to click
on the Summary tab as this is not part of the group. If you now select
any of those daily sheets, you will see a blank row at the top with a
formula in cell F1. If you still have a SUM formula at the bottom of
the data, then you will need to get rid of this on each sheet.

Then you can follow the instructions I gave you earlier.

Hope this helps.

Pete

On Sep 22, 2:57*pm, Stephanie
wrote:
I would love to create another row but I can't because it is an actual
template with excel formulas. I'm not the greatest at this kind of stuff so
if you could maybe go step by step with me?



"Pete_UK" wrote:
I would suggest that you insert one or two new rows at the top of each
of your daily worksheets and have your totals on row 1 - e.g. if it is
column F where the hours are then you could have in F1:

=SUM(F3:F10000)

Then on your summary sheet you would have:

=Monday!F1

=Tuesday!F1

and so on.

Hope this helps.

Pete

On Sep 22, 2:05 pm, Stephanie
wrote:
Help!!!! this what I have. I have a work book with several tabls each tab
represents a week day (example: Monday, Tuesday, and so on) Each day is a
work sheet filled with formulas of time turned into hours worked with a total
cell at the bottom.

What I am trying to do on another work sheet is make a table that say anlong
the top the weeks such as 9/11/09, 9/18/09 and so on with the days of the
week running down the left saying Monday, Tuesday, Wednesday, Thursday and
Friday.

I want the totals from the tabed weekdays to automatical fill into the new
sheet.

Can some one please help me with this????

Thank you- Hide quoted text -

- Show quoted text -