+ Reply to Thread
Results 1 to 4 of 4

Summarize records on a worksheet from data entry sheets

  1. #1
    Registered User
    Join Date
    03-10-2020
    Location
    Dhaka, bangladesh
    MS-Off Ver
    Office 365
    Posts
    3

    Cool Summarize records on a worksheet from data entry sheets

    Hello,

    I have an excel file with 3 worksheets:
    • Summary Sheet
    • Data Entry Sheet 1
    • Data Entry Sheet 2

    The Column titles in all three sheets are the same.

    Everytime a record is entered in data entry worksheet 1 or 2, I want that same record to appear (just below the last entered record) in the summary worksheet.

    How do I do this?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,704

    Re: Summarize records on a worksheet from data entry sheets

    Read the yellow banner at the top of this page.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    03-10-2020
    Location
    Dhaka, bangladesh
    MS-Off Ver
    Office 365
    Posts
    3

    Cool Re: Summarize records on a worksheet from data entry sheets

    Attaching the file for reference.... I want each row of data from the data entry worksheets to automatically appear one after the other on the summary sheet. thanks.
    Attached Files Attached Files

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,704

    Re: Summarize records on a worksheet from data entry sheets

    Place this code in the worksheet_change Event for both Data entry sheets

    Please Login or Register  to view this content.

+ 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] SUMMARIZE Data OF DIFFERENT SHEETS INTO Group
    By raysrains in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-21-2020, 01:23 PM
  2. [SOLVED] Looking formula to SUMMARIZE Data OF DIFFERENT SHEETS INTO ONE BY ENTITY NAME & Divison
    By raysrains in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-11-2019, 04:21 AM
  3. Add/Edit Records Data Entry Form (Without VBA)
    By JCostanza in forum Excel General
    Replies: 3
    Last Post: 09-10-2018, 01:40 PM
  4. [SOLVED] Formula to summarize data from certain sheets only
    By rizmomin in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-21-2018, 06:21 PM
  5. [SOLVED] Need to summarize data from multiple sheets
    By jwagri in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 05-10-2018, 04:31 PM
  6. [SOLVED] How to get summarize data from Various Sheets in a single sheet
    By purav82 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-28-2017, 09:08 AM
  7. Summarize data from different sheets in the last sheet
    By maxfesca in forum Excel General
    Replies: 1
    Last Post: 03-25-2008, 01:08 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