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