G
Guest
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"...
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"...