LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JennLee
 
Posts: n/a
Default How do I copy a date in a worksheet cell to another worksheet?

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy data in a cell from worksheet A to worksheet B rajesh Excel Discussion (Misc queries) 1 February 21st 06 07:40 AM
how to copy cell contents from one workseet to another worksheet? James Excel Discussion (Misc queries) 1 January 21st 06 09:12 PM
update a date cell only when worksheet is edited Joe Black Excel Discussion (Misc queries) 1 September 23rd 05 05:11 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM


All times are GMT +1. The time now is 01:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"