L
Legacy 183961
Guest
Summery of project;
I'm working on a project where I need to generate a dynamic list from lists in multiple worksheets. The amount of worksheets where I need to pull the data can change, the data will be repeated and each worksheet contains a data validation list of drop down boxes from which items are picked. The idea is to generate a summery page where a list of items is generated such that it is unique and dynamic where any changes in the worksheets will change the summery page.
Details;
1. I have a master list of lathe inserts in worksheet(InsertList).
2. I have a macro that generates a worksheet based on a list in worksheet(Jobs) and a template in worksheet(template). Macro generates these worksheets after worksheet 1 in the workbook. (ex. RR40)
3. Each (job) worksheet has drop-down boxes in B2:B28. Drop-down box pulls info from InserList.
3a. I will have the need to go into each generated worksheet and pick a specific insert. The amount of inserts will vary between each (job) worksheet and some inserts will be repeated in some or all (job) worksheets.
Goal;
To generate a summery page (Dashboard) which houses a list starting in A2 which will be composed of all the ranges without duplicates (B2:B28) in the macro generated (job) worksheets. In addition, this list has to be dynamic in case an insert is added, removed or changed in any of the (job) worksheets. (ex RR40).
Current tabs;
Dashboard, InsertList, Template, Jobs
I hope this provides the necessary details of my project. Please ask if something is not clear. Any help will be greatly appreciated.
I'm working on a project where I need to generate a dynamic list from lists in multiple worksheets. The amount of worksheets where I need to pull the data can change, the data will be repeated and each worksheet contains a data validation list of drop down boxes from which items are picked. The idea is to generate a summery page where a list of items is generated such that it is unique and dynamic where any changes in the worksheets will change the summery page.
Details;
1. I have a master list of lathe inserts in worksheet(InsertList).
2. I have a macro that generates a worksheet based on a list in worksheet(Jobs) and a template in worksheet(template). Macro generates these worksheets after worksheet 1 in the workbook. (ex. RR40)
3. Each (job) worksheet has drop-down boxes in B2:B28. Drop-down box pulls info from InserList.
3a. I will have the need to go into each generated worksheet and pick a specific insert. The amount of inserts will vary between each (job) worksheet and some inserts will be repeated in some or all (job) worksheets.
Goal;
To generate a summery page (Dashboard) which houses a list starting in A2 which will be composed of all the ranges without duplicates (B2:B28) in the macro generated (job) worksheets. In addition, this list has to be dynamic in case an insert is added, removed or changed in any of the (job) worksheets. (ex RR40).
Current tabs;
Dashboard, InsertList, Template, Jobs
I hope this provides the necessary details of my project. Please ask if something is not clear. Any help will be greatly appreciated.
