And we appreciate the feed-back.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"John13" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Apr 2, 10:37 am, "RagDyeR" <ragd...@cutoutmsn.com> wrote:
>> Try this for the 2nd part of your question:
>>
>> =INDIRECT("Sheet"&J1&"!A1")
>>
>> --
>>
>> HTH,
>>
>> RD
>> =====================================================
>> Please keep all correspondence within the Group, so all may benefit!
>> =====================================================
>>
>> "AD" <alejandro.d...@dot.state.fl.us> wrote in message
>>
>> news:(E-Mail Removed)...
>> You have to add a $ before the column or row
>> $A$1"John13" <johnasmit...@gmail.com> wrote in message
>>
>> news:(E-Mail Removed)...
>>
>>
>>
>> > How can I copy Row 1 down without offsetting the referenced cells? I
>> > copied it to Row 5 and it changed the reference to A5, B5, etc.
>>
>> > A B
>> > C D
>> > =Sheet2!A1 =Sheet2!B1 =Sheet2!C1 =Sheet2!D1 (Row 1)
>> > =Sheet3!A2 =Sheet3!B2 =Sheet3!C2 =Sheet3!D2 (Row 2)
>>
>> > =Sheet2!A4 =Sheet2!B4 =Sheet2!C4 =Sheet2!D4 (Row 4)
>> > =Sheet2!A5 =Sheet2!B5 =Sheet2!C5 =Sheet2!D5 (Row 5)
>>
>> > Also, can I make the cell formula Sheet reference number a variable?
>>
>> > Like: =Sheet(J1)!A1 instead of =Sheet3!A1 so I can control the sheet
>> > number it looks at by changing the value of J1?
>>
>> > Thank you for your continuing Excel education, your service is
>> > appreciated more than you will ever know.
>>
>> > John- Hide quoted text -
>>
>> - Show quoted text -
>
> Thank you both very much, again I appreciate you taking time to teach!
>
> John
>
|
Similar Threads
