Workstation location function...toughie...

[Michael J. Malinsky]

Using this in Sheet2!A1:

=OFFSET(Sheet1!A1,3,0)

will provide you with the value in Sheet1!A4.

The OFFSET function above starts with Sheet1!A1 then looks 3 rows down and 0
columns to the right (you can also use negative numbers to go up/left).

HTH
--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain

 

[Tom]

Hi gang -

Here's a toughie, at least, that's what I am being told. I have two
worksheets. In a lot of locations on the worksheets there is
duplicate information. Rather than entering the same information
twice I would like to use a function that takes the value out of
Worksheet1 and puts it in Workstation2 and then copy that function to
multiple cells. Now, here's the fly in the ointment, I need to get
the value for every third row from Worksheet1 to Worksheet2 so, in a
simple and easy world the cell reference for Worksheet2!A2 would be
something like this:
Worksheet1!A1+3

This would give me the value of Worksheet1!A4. Then, Worksheet2!A3
would be something like:
Worksheet1!A4+3

and would result in the value in Worksheet1!A7

Does anyone have any ideas?

Much appreciated.

Tom

 

[Arvi Laanemets]

Hi

Into cell A1 on Worksheet2 enter the formula
=OFFSET(Worksheet1!$A$1;(ROW(A1)-ROW(A$1))*3;0)
and copy down

 

[Tom]

Hi

Into cell A1 on Worksheet2 enter the formula
=OFFSET(Worksheet1!$A$1;(ROW(A1)-ROW(A$1))*3;0)
and copy down

Arvi -

Thanks much, you are the wizard. I appreciate everyone's help. Other
than changing the semi-colons to commas it worked perfectly.

Thanks again.

Tom