+ Reply to Thread
Results 1 to 2 of 2

One cell to update daily as per given data.

  1. #1
    Registered User
    Join Date
    12-07-2019
    Location
    india
    MS-Off Ver
    16.0
    Posts
    1

    One cell to update daily as per given data.

    I can't explain the points clearly so I am attaching my sheet here and you can see there are two sheets inside this and SHEET 2's column B is the place where I will put new data according to date and in this sheet I want to update SHEET 1's column E daily but don't want to loose the previous day data. I meant to say column E is now showing a data as per I put a value in column B2 but on next date I will enter new value on B3 and after this new calculation will take place but I do not want o loose the data in SHEET 1's COLUMN E, I just want to add the new value to the previous value and calculations formula will be same everyday. Just the column E's data will be updated with the Sheet2's Column B value. E.g. if column E1 has value 10 and then on 2nd day if it's calculation shows result 2 then 2 will be added in E1 and CELL E1 will be updated as new value 12.
    Attached Files Attached Files
    Last edited by Govind1526; 12-07-2019 at 03:54 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: One cell to update daily as per given data.

    1. You cannot put a formula in a cell that references itself: circular reference error...
    2. You intend to have dates in sheet2, column A, but you have no dates on sheet1
    3. You have names on sheet1 but none on sheet2 so there's no way to know which row to update
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to update and Extract Daily data to Weekly
    By Ravindran Raman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2019, 11:52 AM
  2. Auto Update, Daily Data
    By MilkMyDragon in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-04-2018, 06:15 PM
  3. VBA Macro with button to update daily report with data from the previous day
    By Brenton77 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-27-2015, 02:25 PM
  4. [SOLVED] Formula (or way) to update daily the name of report where cell is linked to.
    By fonzireyes in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2013, 09:43 AM
  5. Update Daily Data To My Email (Outlook) Help
    By neelpatel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2012, 10:16 AM
  6. Repetitive data update (daily)
    By draxz in forum Excel General
    Replies: 4
    Last Post: 07-17-2012, 11:39 AM
  7. Formatting a series of cells to update data daily
    By jlt6jlt6 in forum Excel General
    Replies: 5
    Last Post: 09-30-2009, 02:22 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1