I have a workbook containing a separate worksheet for each day of the week on
which to post activity for specific days/dates. Worksheets are named Monday
Totals, Tuesday Totals, etc. I have a cell on each worksheet that contains
the date for that particular Monday, Tuesday, etc. Then I created another
worksheet at the end I named WEEKLY TOTALS that I needed to give an overview
of the week in one area but still by date. So how do I do an auto thing in
my WEEKLY TOTAL sheet that will pull the date from the Monday Totals
worksheet into the correct cell in my WEEKLY TOTAL wk sheet and the date from
the Tuesday Totals ws into the correct cell in the WEEKLY TOTAL wk sheet,
etc? Clear as mud?
Thanks in advance for any assistance - I'm actually almost delirious from
stressing over a solution. Need something kinda ASAP!
--
Jennifer Lee
IS Coordinator/App Support

If I understand you correctly, this should get you started in the right
direction:

=INDIRECT(TEXT(A5,"dddd") & "!c10")

This assumes your date is in column A and is an actual date, and in C10 of
worksheets Monday - Friday is where the total you want to retrieve is.
Oh, Monday Totals. Try this instead:

=INDIRECT("'" & TEXT(A5,"dddd") & " Totals'!c10")

--
Kevin Vaughn


"JennLee" wrote:

I have a workbook containing a separate worksheet for each day of the week on
which to post activity for specific days/dates. Worksheets are named Monday
Totals, Tuesday Totals, etc. I have a cell on each worksheet that contains
the date for that particular Monday, Tuesday, etc. Then I created another
worksheet at the end I named WEEKLY TOTALS that I needed to give an overview
of the week in one area but still by date. So how do I do an auto thing in
my WEEKLY TOTAL sheet that will pull the date from the Monday Totals
worksheet into the correct cell in my WEEKLY TOTAL wk sheet and the date from
the Tuesday Totals ws into the correct cell in the WEEKLY TOTAL wk sheet,
etc? Clear as mud?
Thanks in advance for any assistance - I'm actually almost delirious from
stressing over a solution. Need something kinda ASAP!
--
Jennifer Lee
IS Coordinator/App Support

Thanks Kevin for your quick response. Before I checked back here, I actually
came up with the formula. All I did is in the cell on the Weekly Total Sheet
in which I wanted the date to 'flow over' from the corresponding day's sheet,
I entered
=(Monday!$A$3) and it populated the date cell on the Weekly Totals Sheet
with the date I had entered on the Monday worksheet in cell A3 !!! Yeah!!
I had about driven myself crazy over something that ended up so very simple.
Anyways, thanks for your suggestion,
--
Jennifer Lee
IS Coordinator/App Support


"Kevin Vaughn" wrote:

If I understand you correctly, this should get you started in the right
direction:

=INDIRECT(TEXT(A5,"dddd") & "!c10")

This assumes your date is in column A and is an actual date, and in C10 of
worksheets Monday - Friday is where the total you want to retrieve is.
Oh, Monday Totals. Try this instead:

=INDIRECT("'" & TEXT(A5,"dddd") & " Totals'!c10")

--
Kevin Vaughn


"JennLee" wrote:

I have a workbook containing a separate worksheet for each day of the week on
which to post activity for specific days/dates. Worksheets are named Monday
Totals, Tuesday Totals, etc. I have a cell on each worksheet that contains
the date for that particular Monday, Tuesday, etc. Then I created another
worksheet at the end I named WEEKLY TOTALS that I needed to give an overview
of the week in one area but still by date. So how do I do an auto thing in
my WEEKLY TOTAL sheet that will pull the date from the Monday Totals
worksheet into the correct cell in my WEEKLY TOTAL wk sheet and the date from
the Tuesday Totals ws into the correct cell in the WEEKLY TOTAL wk sheet,
etc? Clear as mud?
Thanks in advance for any assistance - I'm actually almost delirious from
stressing over a solution. Need something kinda ASAP!
--
Jennifer Lee
IS Coordinator/App Support

You're welcome. Glad you found a solution.
--
Kevin Vaughn


"JennLee" wrote:

Thanks Kevin for your quick response. Before I checked back here, I actually
came up with the formula. All I did is in the cell on the Weekly Total Sheet
in which I wanted the date to 'flow over' from the corresponding day's sheet,
I entered
=(Monday!$A$3) and it populated the date cell on the Weekly Totals Sheet
with the date I had entered on the Monday worksheet in cell A3 !!! Yeah!!
I had about driven myself crazy over something that ended up so very simple.
Anyways, thanks for your suggestion,
--
Jennifer Lee
IS Coordinator/App Support


"Kevin Vaughn" wrote:

If I understand you correctly, this should get you started in the right
direction:

=INDIRECT(TEXT(A5,"dddd") & "!c10")

This assumes your date is in column A and is an actual date, and in C10 of
worksheets Monday - Friday is where the total you want to retrieve is.
Oh, Monday Totals. Try this instead:

=INDIRECT("'" & TEXT(A5,"dddd") & " Totals'!c10")

--
Kevin Vaughn


"JennLee" wrote:

I have a workbook containing a separate worksheet for each day of the week on
which to post activity for specific days/dates. Worksheets are named Monday
Totals, Tuesday Totals, etc. I have a cell on each worksheet that contains
the date for that particular Monday, Tuesday, etc. Then I created another
worksheet at the end I named WEEKLY TOTALS that I needed to give an overview
of the week in one area but still by date. So how do I do an auto thing in
my WEEKLY TOTAL sheet that will pull the date from the Monday Totals
worksheet into the correct cell in my WEEKLY TOTAL wk sheet and the date from
the Tuesday Totals ws into the correct cell in the WEEKLY TOTAL wk sheet,
etc? Clear as mud?
Thanks in advance for any assistance - I'm actually almost delirious from
stressing over a solution. Need something kinda ASAP!
--
Jennifer Lee
IS Coordinator/App Support