+ Reply to Thread
Results 1 to 4 of 4

Trying to Create Running List on Sheet 1 from info in Sheets 2-5

  1. #1
    Registered User
    Join Date
    03-27-2014
    Location
    NYC
    MS-Off Ver
    Microsoft Excel for Mac 2011
    Posts
    2

    Trying to Create Running List on Sheet 1 from info in Sheets 2-5

    Hi,

    I don't know if it's possible to do this but is Excel able to take the info listed in other Sheets and create a tally of it in Sheet 1?

    For example, when I enter something in Sheet 2 like:
    2/13/14 Labels $57.68
    2/15/14 Tubes $18.07

    And something like this in Sheet 3:
    2/14/14 Vitamin E $7.50
    2/14/14 Beeswax $30.00

    I want it to import as I enter it so it goes into Sheet 1 as:
    2/13/14 Labels $57.68
    2/14/14 Vitamin E $7.50
    2/14/14 Beeswax $30.00
    2/15/14 Tubes $18.07

    And gives me a tally. I want it to be continuous. Is this possible?

    Thank you!!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Trying to Create Running List on Sheet 1 from info in Sheets 2-5

    Hi and welcome to the forum

    excel can pretty much do almost anything. However, I would question the need to have 2 data entry sheets? excel works best if all teh data is on 1 sheet, andthen summaries/extracts etc are done on another sheet/s

    If you upload a sample, I can take a look and see if we can streamline things a bit?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    03-27-2014
    Location
    NYC
    MS-Off Ver
    Microsoft Excel for Mac 2011
    Posts
    2

    Re: Trying to Create Running List on Sheet 1 from info in Sheets 2-5

    LitStix Financial Statement.xlsHi,

    I attached it here. I have the info in Sheets 2-whatever, but I want it all to populate into a Master Sheet in Sheet 1.

    Thanks!

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Trying to Create Running List on Sheet 1 from info in Sheets 2-5

    Take a look at the attached and see what I mean. I have duplicated all your sheets, so each sheet is now Master (2), Tax (2) etc. In this, you would enter all the data into Master (2), and each of the other sheets will put its own data for you

+ 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] Running the same macro for a given list of sheets
    By mrproject44 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2013, 04:53 PM
  2. [SOLVED] Create a list of info from column/row if condition is met
    By QEJohn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-19-2012, 09:43 AM
  3. [SOLVED] how to create a running list on one sheet using data from another
    By masterintraining in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2012, 12:10 PM
  4. How do I create a conditional running total on separate work sheets?
    By Poonz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-01-2007, 09:08 AM
  5. Replies: 4
    Last Post: 05-28-2005, 02:05 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