Dear Forum Members,
I would like to post the following question:
As part of our process, I need to extract data from specific cells located in different Workbooks (each has a different nomenclature, structure, form).
The individual data is placed in tables, filtered with a drop-down list.
Example:
I need a monthly summary report of John Smith in one place (Utilization, Evaluation, Sales).
Utilization is located in Workbook1
Evaluation in Workbook2
Sales in Workbook3
In each of the Workbooks there is a table with a drop down list that allows you to filter the data of a specific employee (John Smith, Chris Carter, Aaron Rodgers).
Is there a way to extract data relating to John Smith from these 3 places and consolidate into one table?
At the moment, it is done manually for each employee separately, and combined together in one table for the management, it involves burdensome searching and filtering out information in many files. I would like to automate this process thanks to VBA, however, I have only received beginners training in this topic and I do not know exactly where to start.
For starters, I wanted to get the information from a single source only to get a point of reference, but I was overcome by the drop-down list problem.
TLDR: I would like to extract information about John Smith from the file Workbook1 (B4: B9) and put it in Workbook2 (B3: G3). The difficulty is that in Workbook1 there is a drop-down list, and when Chris Carter is selected, the values in cells B4: B9 change accordingly. Is it possible to adapt the VBA code so that it distinguishes between John Smith and Chris Carter? This kind of a dashboard is being created for every employee in our department, and we would like to automate the process.
Thank you very much in advance for your answers.
P.S. Apologies if anything is not stated clearly enough, English is not my native language.
_________________
Best wishes
I would like to post the following question:
As part of our process, I need to extract data from specific cells located in different Workbooks (each has a different nomenclature, structure, form).
The individual data is placed in tables, filtered with a drop-down list.
Example:
I need a monthly summary report of John Smith in one place (Utilization, Evaluation, Sales).
Utilization is located in Workbook1
Evaluation in Workbook2
Sales in Workbook3
In each of the Workbooks there is a table with a drop down list that allows you to filter the data of a specific employee (John Smith, Chris Carter, Aaron Rodgers).
Is there a way to extract data relating to John Smith from these 3 places and consolidate into one table?
At the moment, it is done manually for each employee separately, and combined together in one table for the management, it involves burdensome searching and filtering out information in many files. I would like to automate this process thanks to VBA, however, I have only received beginners training in this topic and I do not know exactly where to start.
For starters, I wanted to get the information from a single source only to get a point of reference, but I was overcome by the drop-down list problem.
TLDR: I would like to extract information about John Smith from the file Workbook1 (B4: B9) and put it in Workbook2 (B3: G3). The difficulty is that in Workbook1 there is a drop-down list, and when Chris Carter is selected, the values in cells B4: B9 change accordingly. Is it possible to adapt the VBA code so that it distinguishes between John Smith and Chris Carter? This kind of a dashboard is being created for every employee in our department, and we would like to automate the process.
Thank you very much in advance for your answers.
P.S. Apologies if anything is not stated clearly enough, English is not my native language.
_________________
Best wishes
