Hi,

I have 2 sheets in a workbook -Sheet 1 and sheet 2. I have data in
sheet 2 as follows:

Row ColumnA
1 data1
2 data2
3 data3

Now I want to put a formula in Sheet 1 to get the data from Sheet 2 as
follows:

Row ColumnA
1 =Sheet1!A1
2 -----
3 =Sheet1!A2
4 -----
5 =Sheet1!A3

On sheet 1 , I am skipping a row when copying the formula and because
of this I am getting the formula all messed up.

Please help.

Thanks


--
jijy
------------------------------------------------------------------------
jijy's Profile: http://www.excelforum.com/member.php...o&userid=15042
View this thread: http://www.excelforum.com/showthread...hreadid=547903

works fine for me !!!!
Corey....
"jijy" wrote in message
...

Hi,

I have 2 sheets in a workbook -Sheet 1 and sheet 2. I have data in
sheet 2 as follows:

Row ColumnA
1 data1
2 data2
3 data3

Now I want to put a formula in Sheet 1 to get the data from Sheet 2 as
follows:

Row ColumnA
1 =Sheet1!A1
2 -----
3 =Sheet1!A2
4 -----
5 =Sheet1!A3

On sheet 1 , I am skipping a row when copying the formula and because
of this I am getting the formula all messed up.

Please help.

Thanks


--
jijy
------------------------------------------------------------------------
jijy's Profile:
http://www.excelforum.com/member.php...o&userid=15042
View this thread: http://www.excelforum.com/showthread...hreadid=547903