Hi, all. Please help with link and formatting of multiple cells from one sheet to another

[stan.db]

Hi, I'm a new here and I need a help with some excel stuff. I need to take data from multiple cells in a row from one sheet and paste it into another sheet (linking them) but in a column. I could do this simply linking cells one by one but it's a hard work since the cells are hundreds. Is there any faster way, I'd appreciate your help, this will save me hours of work. Thank you

[Bhuvi]

Hi stan.db,
Welcome to the forum

If linking or pasting data between sheets has a logical pattern then a VBA code can do it.
For best results please attach a sample sheet providing example of what you want to achieve.

[stan.db]

Thanks, Bhuvi. I tried to attach a sample but nothing happened. I am with my mobile now and will try to send from here. One the first sheet you'll see a column and on the second - same cells but in a row. Each cell should be linked to the corresponding one in the other sheet. I don't know how to do it when the cells are great number.me ex.xls

Hi stan.db,
Welcome to the forum

If linking or pasting data between sheets has a logical pattern then a VBA code can do it.
For best results please attach a sample sheet providing example of what you want to achieve.

[Bhuvi]

The attached sheet has errors in it, please try to attach the correct sheet again

[stan.db]

Bhuvi, I found the solution. It was posted here:

http://www.ozgrid.com/forum/showthread.php?t=187337

Thank you, man, hope to be able to count on your excel help in the future.