Hello,
As the title states I am wondering how to solve the following problem I have (i haven't tested it out as the results need to be returned to me, but I'd like to know the most efficient way to do this once it is):
A Team Planner excel sheet was sent out to a team of four people. They're tasked to filter their names in Column I and must fill out the blank cells in Columns D, E, F, and L. I've filled in the color as blue for those columns below the headers.
Once they fill out each entry assigned to them, they'll email their respective spreadsheet back to me. Once that happens, I'm supposed to take each entry and combine all of them into the original sheet, so all the data filled for each person will be shown together. Essentially, I'm taking data from four different workbooks that were edited from the form, and putting them back in the original form.
How exactly should I do this? I'm not sure if I'm supposed to use Consolidate in Data Tools, or mess around with Power Query / VBA. Thanks for reading!
Bookmarks