• 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.

query + excel: In a excel workbook, create new transformed power query sheet with out converting into table

harivardhan

New Member
In an excel workbook, i want the "sheet1" to be transformed by power query.
- this transformed data should be in a new sheet of same workbook. say "sheet2"
- but the data in sheet 1 should not be converted into table format.


If this is not possible:
how do i create a dynamic replica of a sheet in the same workbook.
example: 'Sheet 1' & 'Sheet 1-copy' are two sheets in a excel workbook.
ANY CHANGES DONE IN "Sheet 1" SHOULD ALSO BE AUTOMATICALLY REFLECT IN "Sheet 1-copy"
 
Back
Top