Results 1 to 4 of 4

Thread: Code merge data of multiple sheets in one sheet
Thanks Thanks: 0 Likes Likes: 0

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

    Default Code merge data of multiple sheets in one sheet

    hello

    i need help to find code merge data from 3 sheets in one sheet
    i have 3 sheets every sheet contains data in table with headers begins from b4: h10 i would code to merge data from theses sheets to sheet4 also when happens every change automatically changes in sheet4 i tried recording macro but it doesn't well work and no practically
    note: the table is listobject in vba not normal table

  2. #2
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    Steamboat Springs
    Posts
    5,007
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Code merge data of multiple sheets in one sheet

    This is a perfect case for Power Query/Get and Transpose. Look at the links in my signature block for further understanding how this works.
    Let me know if that works for you
    Alan

    Am Yisrael Chai

    Win 10--Office 2019
    When Posting Code, please use code tags.
    How to insert Mcode to Power Query https://excel.solutions/2017/11/powe...te-code-video/


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

    Default Re: Code merge data of multiple sheets in one sheet

    Quote Originally Posted by alansidman View Post
    This is a perfect case for Power Query/Get and Transpose. Look at the links in my signature block for further understanding how this works.
    thanks but i prefer code is there another way to do this except query

  4. #4
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    Steamboat Springs
    Posts
    5,007
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Code merge data of multiple sheets in one sheet

    Because you are asking for it to update with every change, I have difficulty with providing any kind of code. With PQ, you only have to select the Refresh button on the Ribbon to update the output. I will pass on this as it is beyond my VBA skills. If however, you decide that PQ is a way, I am willing to provide help.
    Let me know if that works for you
    Alan

    Am Yisrael Chai

    Win 10--Office 2019
    When Posting Code, please use code tags.
    How to insert Mcode to Power Query https://excel.solutions/2017/11/powe...te-code-video/


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
  •