Well, without knowing your data structure at all, and without knowing how you
are obtaining which specific row, you could do something like this:
Assuming A1 contains the row that you need.

B1: =INDIRECT("Sheet1!B"&A1)

If this doesn't get you on the right track, post back with more info, such
as data structure, formulas, and expected results.
--
** John C **


" wrote:

Usually I am pretty good at using formulas, but this one has me
baffled, I am pretty sure it is possible.

I have two sheets; on the first page I have all my calculations and
variables, one row per item, but multiple columns. On the second
sheet I have how the items should be formatted. I am trying to figure
out a way script it so I can choose a row, and have it fill in the
cells on sheet 2, or choose another row from sheet 1 and have it
recalculate the cells on the sheet 2. In a nutshell sheet 2 is a
template that gets it information form sheet one. The trick is that I
need to be able to choose what rows from the first sheet.