my original data that i am trying to copy is in Sheet1, so would I keep
the same format as you have written or change it to
=OFFSET(Sheet1!.......)

Thanks for the reply though, if this works you are my hero.


Roger Govier Wrote:
Hi

On your Sheet1 in the first cell to receive data enter
=OFFSET(Sheet2!$G$10,0,ROW(1:1)-1)
and drag down

--
Regards

Roger Govier


"londar" wrote
in
message ...

reread what i wrote it may be confusing. What i want is an easy way
to
copy the formulas over. I could manually reference each cell i need
in
the new worksheets but i have over 32 sites and 200 goods.

What i want is when i type =Sheet!G10 in the new worksheet, when i
click the bottom right corner and drag is VERTICALLY DOWN, i want is
to
change the next cell to =Sheet1!H11 NOT =Sheet1!G12 which is what it
does. Adding the $ or pressing F4 does what i want ONLY if i drag
in
the HORIZONTAL direction, which is not where i want the new data to
be
displayed.


--
londar

------------------------------------------------------------------------
londar's Profile:
http://www.excelforum.com/member.php...o&userid=32970
View this thread:
http://www.excelforum.com/showthread...hreadid=527960



--
londar
------------------------------------------------------------------------
londar's Profile: http://www.excelforum.com/member.php...o&userid=32970
View this thread: http://www.excelforum.com/showthread...hreadid=527960