View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default Transposing + Absolute Reference + Multiple Worksheets = my headache

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