Hi all....
need a little help with this, I'm sure its possible but my excel skills aren't up to snuff
I'm trying to get cells in sheet 1 across a row to equal cells that are listed vertically on sheet 2.
So for example, I want A1 on sheet 1 to equal A1 on sheet 2, but then I want B1 on sheet 1 to equal A2 on sheet two. I want to drag a formula horizontaly in sheet 1 across about 100 columns. Anyone know the easiest way to create a dragable formula to do this?
Thanks in advance.
Bookmarks