Forum Discussion
Help pulling data from multiple workbooks
Hello, I'd be grateful if anyone could help. I'm working with a large data set, that will be split into 30-50 workbooks for different colleagues to work on different categories. It needs to be diff...
This method involves using VLOOKUP to pull the comments from each workbook based on a unique reference. For this example, let’s assume your master workbook is called "Master.xlsx" and your category workbooks are named "Category1.xlsx," "Category2.xlsx," etc. Each workbook has the unique reference in column A and the comments in column B.