Hi

Sorry if the data you are trying to copy from is on Sheet1, in cells
G10, H10, I10 etc. then yes the formula needs to change to
=OFFSET(Sheet1!$G$10,0,ROW(1:1)-1)


--
Regards

Roger Govier


"londar" <[email protected]> wrote in
message news:[email protected]...
>
> 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" <[email protected]> wrote
>> in
>> message news:[email protected]...
>> >
>> > 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
>