Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Merge Cells
I need some help creating a Macro to merge cells based on info in another
worksheet. Here is what I have: Sheet 1 - Customer (column A), Ad Size (Column B), Page Number (Column C), Position (Column D). What I want it to do: If on Sheet 1 - b=Full Page, c=1, d=Full - Merge cells on Sheet 2 a2:b3 and enter Value from Sheet1-A1... or if on Sheet 1 - b=Half Page, c=1, d=Top - Merge cells on Sheet 2 a2:b2 and enter value from Sheet 1-A1... or if on Sheet 1 b=Half Page, c=1, d=Bottom - Merge cells on Sheet 2 a3:b3 and enter value from Sheet 1-A1... Then if Sheet 1 c=2 use Sheet 2 c2:d3 to merge instead... Example: On sheet 2 (if Sheet 1 - a1=Village Green, b1=Full Page, c=1, d=Full), Merge a2:b3 and enter value "Village Green"... (if Sheet 1 - a2=Market Square, b2=Half Page, c=2, d=Top), Merge c2:d2 and enter value "Market Square".... (if Sheet 1 - a3=Briar Manor, b3=Half Page, c=2, d=Bottom), Merge c3:d3 and enter value "Briar Manor"... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Merge Cells
Any help to get me started would great...
"Josh O." wrote: I need some help creating a Macro to merge cells based on info in another worksheet. Here is what I have: Sheet 1 - Customer (column A), Ad Size (Column B), Page Number (Column C), Position (Column D). What I want it to do: If on Sheet 1 - b=Full Page, c=1, d=Full - Merge cells on Sheet 2 a2:b3 and enter Value from Sheet1-A1... or if on Sheet 1 - b=Half Page, c=1, d=Top - Merge cells on Sheet 2 a2:b2 and enter value from Sheet 1-A1... or if on Sheet 1 b=Half Page, c=1, d=Bottom - Merge cells on Sheet 2 a3:b3 and enter value from Sheet 1-A1... Then if Sheet 1 c=2 use Sheet 2 c2:d3 to merge instead... Example: On sheet 2 (if Sheet 1 - a1=Village Green, b1=Full Page, c=1, d=Full), Merge a2:b3 and enter value "Village Green"... (if Sheet 1 - a2=Market Square, b2=Half Page, c=2, d=Top), Merge c2:d2 and enter value "Market Square".... (if Sheet 1 - a3=Briar Manor, b3=Half Page, c=2, d=Bottom), Merge c3:d3 and enter value "Briar Manor"... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge cells with formula or macro? | Excel Discussion (Misc queries) | |||
Need help with merge cells in a macro | Excel Programming | |||
Macro to merge cells | Excel Programming | |||
Merge Cells in a column Macro | Excel Programming | |||
Merge cells using macro | Excel Programming |