when I’m trying to set up a loop for merging different excel sheet together, i’m not sure I need to use look up range first, then build data table and merge. But I can only merge 2 excel sheets once but not generating a loop automatically.
when I’m trying to set up a loop for merging different excel sheet together, i’m not sure I need to use look up range first, then build data table and merge. But I can only merge 2 excel sheets once but not generating a loop automatically.