Thread: Excel 2007 inserting info from sheet to sheet

Hello

I am in desperate need for help with this, cause no way is my tiny brain figuring it out all by itself.

Heres the deal:

I have a chart in sheet one with so many rows and 4 columns. In Sheet2 I have a chart with 4 columns and so many rows from which I want to extract the information into Sheet1.
In Sheet1 we only need so many informations from Sheet2, so copy and paste would take too much time.
What I would like to accomplish is typing in the first information off Sheet2 lets say Row1 into Sheet 1 Row 1, and have it automatically adjust the rest of THAT certain row from sheet 2 into Sheet1.

I hope this makes sense, if theres anything anyone can tell me, I would greatly appreciate it!

Thanks in advance

a.