Forum Discussion
Excel Power Query
Two things... 1. I have a main sheet tab that takes information from 3 other sheet tabs in the same workbook and displays the data using power query. However, I also want to add additional free-...
In my testing sample, I try to add 1-2 supporting column in 3 subsheets. Such as a input date.
When I run the Append as New I will sort the date as 1st sort and sort ColumnA as 2nd sort.
The the manually input will not shuffle. And you could easily vlookup back to subsheets.
If your subsheet is very complicated you could add 3 support columns date, sheet A/B/C and row number.