Forum

Hello everyone, used power query and script pyton on excel 365.  

Hi, First, get both files into Power Query. Open your main file, select the data, then Data → From Table/Range. If the second file is separate, clos...

  Hi,I created your Excel spreadsheet above it, along with two more sheets: one called Dashboard and a report sheet, all with formulas and link...

Hi, Try the code fixed, let me know. The Runtime Error 6 (Overflow) occurs because you're using Integer data type for RowNum which has a maximum v...