+ Reply to Thread
Results 1 to 4 of 4

Entering data on one sheet and having it move to another sheet

  1. #1
    Registered User
    Join Date
    02-04-2015
    Location
    Colorado
    MS-Off Ver
    Excel 2013
    Posts
    2

    Post Entering data on one sheet and having it move to another sheet

    I want to enter data in a column in sheet 1 and have the sum total of it move to a cell in sheet 2 as I enter it in sheet 1. I have looked for an answer in Excel 2013 for dummies but no luck finding anything.

  2. #2
    Registered User
    Join Date
    10-22-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: Entering data on one sheet and having it move to another sheet

    If I understand correctly, all you need to do is make a cell reference to Sheet 1 from Sheet 2 and the SUM total value will update automatically on Sheet 2.
    Attached Files Attached Files
    Last edited by SChalaev; 02-05-2015 at 12:47 AM. Reason: Updated excel file.

  3. #3
    Registered User
    Join Date
    02-04-2015
    Location
    Colorado
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Entering data on one sheet and having it move to another sheet

    I see what your reply is saying and yes that works. But I want to add data to column "H" in sheet 1 each day and have it show up in cell 2C in sheet 2. I could total column H and have data move to 2C but I would have to create a formula each time I did it.

  4. #4
    Registered User
    Join Date
    10-22-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: Entering data on one sheet and having it move to another sheet

    How much data are you entering into "H" and is there a header in the first row of "H" column?

    If cell "H1" is taken by a header type the following into "C2" on Sheet2:

    Please Login or Register  to view this content.
    If column "H" is all numerical data going down a sheet type the following into "C2" on Sheet2:

    Please Login or Register  to view this content.
    If I have misunderstood, please post a mock file.

    Stas

+ 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. Replies: 5
    Last Post: 02-09-2014, 11:04 PM
  2. Replies: 5
    Last Post: 02-09-2014, 08:29 PM
  3. Replies: 10
    Last Post: 08-14-2013, 03:32 PM
  4. Auto entering data from sheet 2 into sheet 1 of the same workbook
    By cornerstoneparry in forum Excel General
    Replies: 8
    Last Post: 07-02-2013, 06:31 PM
  5. Taking data from sheet 3 and auto entering it useing a keyword to sheet 1
    By mark petrak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2008, 10:32 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