Results 1 to 2 of 2

Thread: sum data of two table in two sheets
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2019
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default sum data of two table in two sheets

    hi, expert
    i have table contains data in sheet1 the range from a1: d6 and the sheet2 the same thing and theyare both contain repeated data what i would code show the data in sheet2 the range from h2:k6 with sum the duplicated data and show one time without repeating



    Last edited by abdelfattah; Aug 30th, 2019 at 02:50 PM.

  2. #2
    Board Regular Sam_D_Ben's Avatar
    Join Date
    Oct 2012
    Location
    New Jersey, USA
    Posts
    371
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: sum data of two table in two sheets

    After summing up, i guess trying "AVANCED FILTER" option help you find the unique records with in the range or to copy to a different location with in the sheet.
    Sam_D_Ben

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •