Hi forum
I'm trying to make my workbook (Schedule) to get data from another workbook (BOQ) depending on what sheet that is chosen in my dropdown in "E3".
The dropdown in generated from a VBA which get the "BOQ's" sheetnames.
I would then like to when I change the dropdown value, the sheet gets the data from the BOQ's matching sheetname in range B8:P90, and paste it into the "Schedule" workbook's active sheet.
Hope the above makes sense
I'm trying to make my workbook (Schedule) to get data from another workbook (BOQ) depending on what sheet that is chosen in my dropdown in "E3".
The dropdown in generated from a VBA which get the "BOQ's" sheetnames.
I would then like to when I change the dropdown value, the sheet gets the data from the BOQ's matching sheetname in range B8:P90, and paste it into the "Schedule" workbook's active sheet.
Hope the above makes sense