Transfering information form one cell to another work sheet

[Stephanie]

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

 

[NBVC]

Probably a combination of Sumif and Indirect functions might work... se
both these functions in excel help to see how they work.

e.g.

=Sumif(Indirect("'"&$A2&"'!A:A"),B$1,indirect("'"&$A2&"'!B:B"))

this would look at column A in the day sheet named as per your cell A
(e.g. Monday) in the summary sheet for matches to cell B1 (e.g. 9/11/09
in your summary sheet and return summed corresponding values fro
column B in the day sheet.. Formula can be copied down and across

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com

 

[Pete_UK]

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

 

[Stephanie]

Thanks,

I'm going to try it and see if it works

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

 

[Stephanie]

Thanks,

I'm going to see if I can get it to work, I'll let ya know.

 

[Stephanie]

I am still confused!!!!

 

[Stephanie]

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?

 

[Stephanie]

I am still stuck!!!!

 

[Pete_UK]

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

 

[Stephanie]

Ok Pete, I am going to go ahead and try this. When I am done I will let you
know what happens. Thank you for walking me through it!!!!

 

[Stephanie]

Ok Pete, sorry it took me so long to get back to you. I followed the
directions but I couldn't get past adding a blank row.

Once I added the blank row and then tried to place to formula in the same
colum as the total cell I received a message box asking if I was trying to
create a formula.

I entered the new blank row on each form and then went to J1 to enter the
formula and it didn't work. The reason I entered the formula in J1 was
because my total is in J35.

What am I doing wrong????

 

[Pete_UK]

Hi Stephanie,

I don't know what's wrong.

The instructions I gave you were quite clear and the operation should
have taken you a few minutes only. I presume you changed the cell
references in J1 to suit that column?

=SUM(J3:J1000)

Perhaps there is something else you have not told me about your
workbook ??

Pete

 

[Stephanie]

Thank you pete I will try one more time!!!

Hi Stephanie,

I don't know what's wrong.

The instructions I gave you were quite clear and the operation should
have taken you a few minutes only. I presume you changed the cell
references in J1 to suit that column?

=SUM(J3:J1000)

Perhaps there is something else you have not told me about your
workbook ??

Pete

 

[Stephanie]

You are so smart!!!!! It worked this time, it must have been something I was
doing. Now how do I get those totals to my summary sheet and in the right
order of Monday, Tuesday, Wednesday, ect?

 

[Pete_UK]

In my first post to you I said this:

" ...
Then on your summary sheet you would have:

=Monday!F1

=Tuesday!F1

and so on.
.... "

Obviously you would now have J1 instead of F1, but just put those
formulae where you want to see the results on your summary sheet.

Hope this helps.

Pete