I am trying to copy the data from B1 and paste it in another sheet in C1 and repeat the same process for the entire column till we have the values in that column(B in this case).
can some one help me here with this.

I am able to get the code till opening the workbook but not able to take it forward from there.

New contributor

revanth pavuluri is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.