Forum Discussion
Solved
Need VBA code to get the data from another excel and use few formula, write the output back to excel
Hi All, I have a monthly data in a excel workbook named as workbook1, need a VBA code, put it into a button and placed in workbook 2. And by using the code to get the data of one column (named a...
I did what you asked, but I already suspected that it wasn't what you wanted.
Remove the lines
' Optional ws2.Range("A2:A" & lr).Value = .Valuefrom the code.
HansVogelaar Thank you so much for your Prompt help on this scenario.
After I clicked the button its working but the same output is pasted in the workbook2 as well like the below screenshot.
Is there any way to get rid of them.
I did what you asked, but I already suspected that it wasn't what you wanted.
Remove the lines
' Optional
ws2.Range("A2:A" & lr).Value = .Valuefrom the code.