M
Max
In a sheet: Z
I have a
Defined range: Branch
which refers to: =Z!$B$2:$V$10
I have a combo box (from control toolbox), with
Linked cell: H3
ListFillRange: BrList2
where BrList2 ='R'!$A$2:$A$86
The combo box selection (linked to H3) drives several formulas within Branch
I would like to iterate through each text value in BrList2, copy Branch then
paste special as values & as formats starting at B2 in a new sheet, leaving
a blank single row in-between successive copy/pastes of Branch for each
value in BrList2. The 1st paste will go into B2: V10, 2nd paste goes into
B12:V20, and so on down the sheet
I would also need each pasted range in the new sheet to be named after the
corresponding value in BrList2
Eg: if 1st value in BrList2 is xx1, then the 1st paste done in B2:V10 will
be named: xx1
Thanks for help with a sub which can automate the above generation.
I have a
Defined range: Branch
which refers to: =Z!$B$2:$V$10
I have a combo box (from control toolbox), with
Linked cell: H3
ListFillRange: BrList2
where BrList2 ='R'!$A$2:$A$86
The combo box selection (linked to H3) drives several formulas within Branch
I would like to iterate through each text value in BrList2, copy Branch then
paste special as values & as formats starting at B2 in a new sheet, leaving
a blank single row in-between successive copy/pastes of Branch for each
value in BrList2. The 1st paste will go into B2: V10, 2nd paste goes into
B12:V20, and so on down the sheet
I would also need each pasted range in the new sheet to be named after the
corresponding value in BrList2
Eg: if 1st value in BrList2 is xx1, then the 1st paste done in B2:V10 will
be named: xx1
Thanks for help with a sub which can automate the above generation.