software

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,quot;ddddquot;) amp; quot;!c10quot;)

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(quot;'quot; amp; TEXT(A5,quot;ddddquot;) amp; quot; Totals'!c10quot;)

--
Kevin Vaughnquot;JennLeequot; wrote:

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

gt; If I understand you correctly, this should get you started in the right
gt; direction:
gt;
gt; =INDIRECT(TEXT(A5,quot;ddddquot;) amp; quot;!c10quot;)
gt;
gt; This assumes your date is in column A and is an actual date, and in C10 of
gt; worksheets Monday - Friday is where the total you want to retrieve is.
gt; Oh, Monday Totals. Try this instead:
gt;
gt; =INDIRECT(quot;'quot; amp; TEXT(A5,quot;ddddquot;) amp; quot; Totals'!c10quot;)
gt;
gt; --
gt; Kevin Vaughn
gt;
gt;
gt; quot;JennLeequot; wrote:
gt;
gt; gt; I have a workbook containing a separate worksheet for each day of the week on
gt; gt; which to post activity for specific days/dates. Worksheets are named Monday
gt; gt; Totals, Tuesday Totals, etc. I have a cell on each worksheet that contains
gt; gt; the date for that particular Monday, Tuesday, etc. Then I created another
gt; gt; worksheet at the end I named WEEKLY TOTALS that I needed to give an overview
gt; gt; of the week in one area but still by date. So how do I do an auto thing in
gt; gt; my WEEKLY TOTAL sheet that will pull the date from the Monday Totals
gt; gt; worksheet into the correct cell in my WEEKLY TOTAL wk sheet and the date from
gt; gt; the Tuesday Totals ws into the correct cell in the WEEKLY TOTAL wk sheet,
gt; gt; etc? Clear as mud?
gt; gt; Thanks in advance for any assistance - I'm actually almost delirious from
gt; gt; stressing over a solution. Need something kinda ASAP!
gt; gt; --
gt; gt; Jennifer Lee
gt; gt; IS Coordinator/App Support

You're welcome. Glad you found a solution.
--
Kevin Vaughnquot;JennLeequot; wrote:

gt; Thanks Kevin for your quick response. Before I checked back here, I actually
gt; came up with the formula. All I did is in the cell on the Weekly Total Sheet
gt; in which I wanted the date to 'flow over' from the corresponding day's sheet,
gt; I entered
gt; =(Monday!$A$3) and it populated the date cell on the Weekly Totals Sheet
gt; with the date I had entered on the Monday worksheet in cell A3 !!! Yeah!!
gt; I had about driven myself crazy over something that ended up so very simple.
gt; Anyways, thanks for your suggestion,
gt; --
gt; Jennifer Lee
gt; IS Coordinator/App Support
gt;
gt;
gt; quot;Kevin Vaughnquot; wrote:
gt;
gt; gt; If I understand you correctly, this should get you started in the right
gt; gt; direction:
gt; gt;
gt; gt; =INDIRECT(TEXT(A5,quot;ddddquot;) amp; quot;!c10quot;)
gt; gt;
gt; gt; This assumes your date is in column A and is an actual date, and in C10 of
gt; gt; worksheets Monday - Friday is where the total you want to retrieve is.
gt; gt; Oh, Monday Totals. Try this instead:
gt; gt;
gt; gt; =INDIRECT(quot;'quot; amp; TEXT(A5,quot;ddddquot;) amp; quot; Totals'!c10quot;)
gt; gt;
gt; gt; --
gt; gt; Kevin Vaughn
gt; gt;
gt; gt;
gt; gt; quot;JennLeequot; wrote:
gt; gt;
gt; gt; gt; I have a workbook containing a separate worksheet for each day of the week on
gt; gt; gt; which to post activity for specific days/dates. Worksheets are named Monday
gt; gt; gt; Totals, Tuesday Totals, etc. I have a cell on each worksheet that contains
gt; gt; gt; the date for that particular Monday, Tuesday, etc. Then I created another
gt; gt; gt; worksheet at the end I named WEEKLY TOTALS that I needed to give an overview
gt; gt; gt; of the week in one area but still by date. So how do I do an auto thing in
gt; gt; gt; my WEEKLY TOTAL sheet that will pull the date from the Monday Totals
gt; gt; gt; worksheet into the correct cell in my WEEKLY TOTAL wk sheet and the date from
gt; gt; gt; the Tuesday Totals ws into the correct cell in the WEEKLY TOTAL wk sheet,
gt; gt; gt; etc? Clear as mud?
gt; gt; gt; Thanks in advance for any assistance - I'm actually almost delirious from
gt; gt; gt; stressing over a solution. Need something kinda ASAP!
gt; gt; gt; --
gt; gt; gt; Jennifer Lee
gt; gt; gt; IS Coordinator/App Support