how to populate a range with another range of data ?

[theorbo]

Hi - imagine that I have 2 worksheets in my workbook.

Worksheet 'MASTER'
5 columns x 4 rows
Column 1 = KEY and Columns 2 - 5 = numbers (data)

Worksheet 'DATA'
4 columns x 12 rows (3 groups of 4 rows)

I have been trying to use a combo-box to select which of the 3 groups of 4
rows from the 'DATA' worksheet to show on the 'MASTER' worksheet. Anyone
have an idea of a technique to use?

I am not sure how to get my range of data in 'MASTER' to change based on
'pointing' to a range of data somewhere else. I've tried using named ranges
and haven't had any luck - YET.

Any tips or pointers?

TIA.

 

[Bernie Deitrick]

For example, in cell B1, enter 1, 2, or 3, and in A2, enter

=INDEX(DATA!$A$1:$D$13,($B$1-1)*4+ROWS($A$1:$A2),COLUMN(A1))

and copy to A25.

HTH,
Bernie
MS Excel MVP

 

[theorbo]

Worked beautifully ... thank you!

For example, in cell B1, enter 1, 2, or 3, and in A2, enter

=INDEX(DATA!$A$1:$D$13,($B$1-1)*4+ROWS($A$1:$A2),COLUMN(A1))

and copy to A25.

HTH,
Bernie
MS Excel MVP