Problem with paste link

[eldhose_mbits]

I am using excel 2007, i want to display the contet of a cell to athor file's cell. i used pate link for that, but for next colume that entru is not working.

Problem solved, Mr Dilip helped me.

[dilipandey]

Hi eldhose,

welcome to the forum.

In the pasted link, remove the $ sign from the row, if you want row to be changed and from column, if you want column to be changed, when you copy that link (formula) down. Thanks

Regards,
DILIPandey

<click on below 'star' if this helps>

[eldhose_mbits]

Problem solved by removing the dollar sign , Mr. DILIPandey ( [email protected]) helped me for solving the problem. Thank you.

[dilipandey]

You are welcome .. .

Cheers

Regards,

DILIPandey

<click on below star if this helps>