September 22, 2019
hi guys, gurus and geniuses,
he i'm a lazy guy, i have this problem of combining tons of data, (excel files) customer 1.xlsx to customer 100... and so on... list just grows. and each customer order we need to fill up in the rows in each excel file... now i need to consolidate all... the tricky part is all individual excel files (customer 1 to 100++) is being updated daily... (customer orders are recorded from a7:u7) and fills as they order. for customer1 shes now until row 58... and so on...
i need help... really... i need to combine all these data from a hundred plus excel workbooks to a one master file. and can update itself. (because individual files are being filled by different people) please help.
also, in the master file, can i sort and filter normally? like in a regular sort and filter? anyways please help me. thank you so much. i can buy you a beer 🙂 thanks guys! hope to hear from you. 🙂 thanks!
October 5, 2010
I'd be looking to use Power Query for this. I'd need to see some examples of your files before I could offer any more.