hello I am trying to copy columns one sheet to another however it takes so much time to copy.
i have tried this code below. I have lots of data it takes several time with this code. any tips to make this code more efficient?
Dim lastrow, erow As Long
lastrow = Worksheets("sheet...