LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Automatic Data Update by Date Range

Is there a way to have a cell update through a date range from data
entered in another cell?

An Example...

Each day a numerical value will be entered in cell A1 (number of
people who purchased product)

I would like for cell B1 to automatically update the data each day for
1 week from the amount entered into A1 on each day.

If entering 1 in cell A1 on Mon, 3 on Tues, 1 on Wed, 1 on Thur, and 2
on Fri

Cell B1 should have a total of 8 on Fri.....This would update a by
Week, another cell by Month and another cell by Quarter

1. Would I need to clear data from Cell A1 each day to enter a
different number for the next day?

2. Will cell B1 require a cut off time for each day?

Thanks
 
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
how can i set up an automatic "date update" in excel? Litzyam New Users to Excel 3 April 5th 23 02:55 PM
Automatic update of date once, then remains static mfdc_frank Excel Worksheet Functions 5 October 5th 06 12:16 AM
Combo Box input range automatic update John M Excel Discussion (Misc queries) 1 May 11th 06 08:05 PM
Automatic Date Update Jmoore Excel Worksheet Functions 1 November 17th 05 08:21 PM
Automatic Date Update khaji00 Excel Discussion (Misc queries) 2 June 22nd 05 11:48 PM


All times are GMT +1. The time now is 10:54 PM.

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"