User inputs number on sheet 1 and multiple cells (from sheet 2) are shown on sheet 3

[rimshot609]

I would like to enter a number on sheet 1 (A1) and have the data from sheet 2 displayed on sheet 3.

For example. If I enter a 1 in cell A1 on sheet 1. I would like only cell A1 of sheet 2 appear on sheet three.

If I enter a 2 on sheet 1 (A1) I would like cells A1 and A2 appear on sheet three (without the need for filling down).

If I enter a 3 on sheet 1 (A1) I would like cells A1-A3 appear on sheet three without having to manually fill down on sheet 3....and so on.

I have attached a spreadsheet as an example. I have no problem getting the first row to appear on sheet 3 using an IF statement but I'm not sure how to have multiple rows appear with multiple if statements and without having to fill down.

Thanks.

[FDibbins]

Try this...
=INDEX(Sheet2!$A$1:$A$4,Sheet1!A1)

[:) Sixthsense :)]

Copy the below code and do right click on SHEET1 sheet tab and select view code and paste it.

Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.

Please Login or Register  to view this content.

[rimshot609]

Thanks FDibbins for you response but sixthsence's solution did the trick! Wow, that was fast. Thanks so much.