HELP: Quick method to copy from Column A to column B, C.. base on their respective rows?

I have text in various rows in column A.

What method/formula to use to copy some of the data from Column A to column B, C, D...... base on the text from their respective rows?

Thanks

Originally Posted by Rahul Nagar

Hi,

You can just select the data till column D and press "Ctrl R"

That works like a charm.

But unfortunately if it is a linked cell, it is not able to.

Any way around that?

Thanks

Originally Posted by FDibbins

Excatly what data are you trying to copy across, and how/why?

Also, this seems very much like your other thread....
http://www.excelforum.com/excel-gene...her-sheet.html

Please let me know if this is thh same question, so that I can close 1 of the 2 duplicate threads

Hi. It is a different question.

Hi FDibbins,

I was testing out different method to compare 2 tables of data. One of them is to link the cells to another worksheet. Some of the cells are merged. In the linked sheet, i unmerged them. But when i use ctrl+R, i get '0' instead of the corresponding data.

Hope i can get a solution to this.

Thanks