• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Create Dynamic table based on another table

jonastiger

Member
Hi
As shown in the attached file, I need to convert TABLE1, which is a dynamic table (that is filled automatically from various source data tables), in TABLE2,
sorted by Site and ignoring zero values or blank cells.
I would like to get some help, formula or VBA, since I'm stucked with my results.
Thank you very much in advance
JT
 

Attachments

  • ConvertTables.xlsx
    12.6 KB · Views: 5
Sorry, no VBA or formulae but Power Query.
Table at cell T3 needs refreshing by right-clicking it and choosing Refresh after the source table has been changed/updated.
 

Attachments

  • Chandoo47194ConvertTables.xlsx
    22.8 KB · Views: 5
Thank You very much.
Great (and simple) solution!!!!
So blind looking for VBA or formulae options, I never considered PQ.

I think we can setup autorefresh in query properties...
 
Back
Top