Need Code to Populate Cell Range
In cell Sheet1 range M11 put
=OFFSET(Sheet2!E10,MATCH(Sheet2!C11,
{"T1","T2","R1","R2","R3","R4"},0),0)
or substitute the array with the range used to populate
the ComboBox
Kevin Beckham
-----Original Message-----
A workbook has two sheets: Sheet1 and Sheet2
In Sheet1 I want to populate merged cell range M11:AK12
as follows:
If Sheet2, cell C11 = "T1", insert Sheet2!E11 data in
Sheet1 range M11
If Sheet2, cell C11 = "T2", insert Sheet2!E12 data in
Sheet1 range M11
If Sheet2, cell C11 = "R1", insert Sheet2!E13 data in
Sheet1 range M11
If Sheet2, cell C11 = "R2", insert Sheet2!E14 data in
Sheet1 range M11
If Sheet2, cell C11 = "R3", insert Sheet2!E15 data in
Sheet1 range M11
If Sheet2, cell C11 = "R4", insert Sheet2!E16 data in
Sheet1 range M11
As background, Sheet2!C11 is populated by a ComboBox
LinkedCell
What is the code to make this happen?
.
|