Hi guys

I need to do the following and need a formula etc

I have some data on sheet 2 from A1 to J30. The data in Column A does not change and is always as follows, A1 = 1, A2 = 2, right down to A30 = 30. Columns B1 to J30, the data changes all the time.

I need to be able to be in sheet1 and type in any number between 1 and 30 in a cell and this will bring from sheet 2 the info from that row.

For example, if I type the number 9 then the information in sheet2, A9 through to J9 will be copied over to sheet1, ie alongside where I typed in the number 9.

Can anyone help?

Thanks

John