how to populate a range with another range of data ?

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.

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 A2:D5.

HTH,
Bernie
MS Excel MVP


"theorbo" wrote in message

> 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.
>
>
>
>
>