+ Reply to Thread
Results 1 to 3 of 3

Dynamic Data

  1. #1
    Registered User
    Join Date
    01-09-2021
    Location
    cincinnati oh
    MS-Off Ver
    MS Office X
    Posts
    2

    Lightbulb Dynamic Data

    At the end of everyday I will be manually copy-pasting that days sales from another file into one worksheet (Worksheet 1). In another worksheet( Worksheet 2) I have a column of dates. Everyday, I want that days sales updated in Worksheet 2 by referencing from the Total in Worksheet 1. However the next day, I want the previous days sales in Worksheet 2 to remain frozen and stop being updated from Worksheet 1 so that there is a dynamic list of sales for each day. Can this be done ?

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,525

    Re: Dynamic Data

    Not with a formula, unless you do some manual things every day, like fixing values before pasting in the new data (I assume you are pasting it in and overwriting what is already there).

    Pete

  3. #3
    Registered User
    Join Date
    01-09-2021
    Location
    cincinnati oh
    MS-Off Ver
    MS Office X
    Posts
    2

    Re: Dynamic Data

    Thanks Pete!
    Yes I could just keep it referenced and just use "paste values" at the end of each day just to freeze that day's sales. I was wondering if there is a more elegant way of doing it.

+ 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. Create dynamic drop down list from dynamic data source
    By rz6657 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2016, 05:22 PM
  2. Replies: 10
    Last Post: 10-09-2014, 06:20 PM
  3. How to create a dynamic chart off dynamic data
    By jananas in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-07-2013, 10:48 AM
  4. Replies: 0
    Last Post: 02-21-2013, 09:07 AM
  5. Web Query dynamic destination or VBA to copy and paste new data alongside existing data
    By Marbleking in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-12-2012, 06:03 PM
  6. [SOLVED] Mutliple SUM with dynamic SUM range within a Dynamic Data set
    By Michael.Westen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-10-2012, 06:28 AM
  7. Dynamic table formula for sorting data to another table dynamic
    By 650dozer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2012, 07: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