i have attempted to create 1 sheet from multiple sheets using =Excel.CurrentWorkbook() to bring all the sheets together in a Query. the result is i am getting some of my results listed twice .. i b...
cheers , finally got there however is there a way to add new sheets and have them update on the original query or do i have to repeat building the query every time new sheets are added thank you cheers
