Copying data between two sheets using internal function

[harshalraje]

Hello

I am a newbie to Excel and my question my sound silly or someone else might have asked it here earlier. If latter, please point me to the post.

I have a workbook with several sheets. I am working on sheet 6 and want to copy data from sheet 2. (it not a copy paste job.)

I know i can use the formula " =sheet2!$C$4 " and get the data in my current sheet. Now my question is how do i replicate this formula down the entire column (some 250 rows) without manually incrementing the row number. e.g. =sheet2!$C$4, =sheet2!$C$5, etc.

can this be achieved without the use of macros and VB script?

Appreciate your response.

Harshal

 

[Hui]

Harshal

Firstly, Welcome to the Chandoo.org Forums

In your case I will assume that C4 is the Top left corner of your data area

Use the formula: =Sheet2!C4 instead of =Sheet2!$C$4

Copy down and across as required

refer: http://chandoo.org/wp/2008/11/04/relative-absolute-references-in-formulas/

 

[harshalraje]

Hello Hui

Thanks a lot. it worked.