Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub to iterate thru combo box n copy paste n name ranges successively in a new sht
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I copy big ranges of cells without drag or copy/paste? | Excel Discussion (Misc queries) | |||
Iterate over a Range of data - create arrays or ranges | Excel Programming | |||
copy / paste -- vlookup combo ??? | Excel Programming | |||
Newbie question: How to iterate over combo boxes on a worksheet | Excel Programming | |||
Combo box copy and paste | Excel Programming |