+ Reply to Thread
Results 1 to 3 of 3

How can I capture data that is (DAILY) input into another worksheet?

  1. #1
    Registered User
    Join Date
    04-25-2016
    Location
    San Antonio, TX
    MS-Off Ver
    2013
    Posts
    1

    How can I capture data that is (DAILY) input into another worksheet?

    EXAMPLE:
    What I currently have... Worksheet A has columns "Date", "Open", "Plan", "Previous Completed", "<24 hours", "24 - 48 hours", ">48 hours"

    What I want to have... Worksheet A has columns "Date", "Open", "Plan", "Previous Completed", "<24 hours", "24 - 48 hours", ">48 hours" that populates a running spreadsheet in Worksheet B

    Is this possible?

  2. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: How can I capture data that is (DAILY) input into another worksheet?

    Could you attach a sample workbook stating your requirements?

    For how to attach a workbook here check out the link in my signature below.
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  3. #3
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: How can I capture data that is (DAILY) input into another worksheet?

    While you're attaching a workbook, could you also clarify the relationship? As worksheet A changes, does B merely mimic that change, or is B intended to keep a running log of everything that has ever been entered in A? Or something else entirely?

+ 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. Using VBA to input daily list of data into excel based on date
    By skinmonth in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2016, 01:22 PM
  2. [SOLVED] Help: Calculating MTD, QTD, and YTD from daily data input
    By misterk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-10-2014, 02:41 PM
  3. capture data from input userform to another workbook
    By tofan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2013, 10:14 AM
  4. Capture time and activity daily
    By Stormdronk in forum Excel General
    Replies: 0
    Last Post: 08-04-2011, 05:36 AM
  5. Replies: 0
    Last Post: 12-28-2005, 04:30 PM
  6. Daily new data input
    By ufo_pilot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-02-2005, 01:40 PM

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