I want to copy a column from one one sheet to sheet in another workbook. It should copy values and format of the cells. I tried various options but couldn’t do it. It pasted data/values but not format.
Hi @csmart - Did you check the below video
Also, please share your sample input excel if possible
@Gokul_Jayakumar I also tried specifying range in your suggestion but it is not working. Check the image, it is not working.
Here I attached Updated code, kindly refer it
In which, Just copy the formula from input to output.
CopypasteFormula.zip (82.5 KB)
And it will work based on our conditions, If we enter the Start range, end range will automaticall calculated at end of data by row column.
If we need certain column, we have to feed the condition start and end point of column
I did the same thing and it worked. Earlier I was defining range as “C1” and not “C1:C100”.
@csmart , You are giving static range as C100 end,
Refer this , i gave end value as dynamic. Based on column count, it will determine the end position
If you found the solution, kindly mark as a solution, I wil usefull for someone looking for same issues.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.