+ Reply to Thread
Results 1 to 3 of 3

How do I save daily entered data from a spreadsheet and pull it to another by date?

  1. #1
    Registered User
    Join Date
    05-02-2013
    Location
    Saint Louis, Missouri
    MS-Off Ver
    Excel 2003
    Posts
    2

    How do I save daily entered data from a spreadsheet and pull it to another by date?

    At work they want me to start tracking inventory (work completed) for the entire department by type. I created a spreadsheet that data can be entered into. My issue is: When they enter the data each day, I need it to be saved into another spreadsheet by date...then my manager wants a separate spreadsheet to pull the totals from the data entered in the original sheet. I've created both spreadsheets (attached) and linked the cells so the totals from one sheet appears in the other. I dont how to get the second spreadsheet to pull in data from whatever date she chooses to view.
    Attached Files Attached Files

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,869

    Re: HELP!! How do I save daily entered data from a spreadsheet and pull it to another by d

    So Basically you want to enter data in Sheet "Daily Inventory Tracking Form" and based on the date you want a new Sheet to be created with all the data in it??

    Is it right?
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    05-02-2013
    Location
    Saint Louis, Missouri
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: HELP!! How do I save daily entered data from a spreadsheet and pull it to another by d

    Quote Originally Posted by msexcelathome View Post
    So Basically you want to enter data in Sheet "Daily Inventory Tracking Form" and based on the date you want a new Sheet to be created with all the data in it??

    Is it right?
    Yes, the data will be entered from several users with their own access to the "Daily Inventory Tracking Form". I want to be able to pull data for whatever date I choose.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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