I have a worksheet that has a rows of information called "Purchase Log"

I have another worksheet that is called "Purchase Sheet"

in the purchase sheet I want to be able to put the row# i want to populate
and it will automaticly populate the row into a specific line in the purchase
sheet

so in this case i will write the number 10 in a cell and it will automaticly
go to "purchase log!" row 10 and copy column B:I

is there a formula that can do this for me? I can also put the letters in
each cell and have it take the letter and then the row and use those as
figures if thats easier to do?

Thanks in advance, Avidan

I'm a little unclear about whether the cell you type the number into is
always the same cell, or could be different cells. Equally unclear as to
whether the information placed into the Purchase Sheet in the same row all of
the time or not.

But let's start with the simple case: you'll always type the number into the
same cell and you'll always display the results in the same cells.

The cell you'll type the number in will be A1 on the Purchase Sheet.

where you want to get data from column b on the Purchase Log sheet, put this
formula:
=OFFSET('Purchase Log'!$B$1,$A$1-1,0)
to get values from other columns, change the last parameter, the ,0) part
,1) to get from column C
,2) to get from column D
,3) to get from column E, etc.

so the formula =OFFSET('Purchase Log'!$B$1,$A$1-1,7)
would get you the information from Purchase Log!I# where # is the number
entered into A1.

Does that help any?

"Avidan" wrote:

I have a worksheet that has a rows of information called "Purchase Log"

I have another worksheet that is called "Purchase Sheet"

in the purchase sheet I want to be able to put the row# i want to populate
and it will automaticly populate the row into a specific line in the purchase
sheet

so in this case i will write the number 10 in a cell and it will automaticly
go to "purchase log!" row 10 and copy column B:I

is there a formula that can do this for me? I can also put the letters in
each cell and have it take the letter and then the row and use those as
figures if thats easier to do?

Thanks in advance, Avidan