So please refer only to the Big Data file The Source sheet in column J has cells that have 2 names in the cell Full name, full name I need the second ...
Thank you!! Great answer, smart solution !! About ISOWEEKNUM function - Does she automatically count a week from Monday? And if you want to count a we...
I will detail the case more - It's a Google Drive cloud I have 30 users updating the data every day on Google Drive I need to have 30 Excel files in o...
Hi, From your answer I realize I need 2 files - 1. The original file - where I can add data and sheets 2. Another file on which Query is run and it...
Okay, worked for me. After doing the whole process - I added a given in one of the tables - I clicked Refresh And he doesn't show the new figure. Beca...
Hello, I am now in Exercise 3.02 Inserts the Excel.Workbook function But I get an error message - Expression.SyntaxError: RightParen Token Require...
I've written so now and it still brings me the same error = Excel.CurrentWorkBook() All functions should be case sensitive?
Each will receive a separate report based on their own data. It will receive the report in a PDF file. Now I do this a long manual way- Filters one sa...