Hello
Since, I am new to coding, would like some of your help.
I am trying to move data from 2 workbooks into 1. I am showing you the example of what I want to do, and I am going to repeat the same for the other cells;
But VBA tells me its an syntax error on the Sub, and the whole code is in red. I am guessing with using several workbooks something else needs to be done.
Please help me out.
Thank you in advance.
Since, I am new to coding, would like some of your help.
I am trying to move data from 2 workbooks into 1. I am showing you the example of what I want to do, and I am going to repeat the same for the other cells;
VBA Code:
Sub new_excel_problem()
Workbooks ("Current"), Sheet1.Range("E3") = Workbooks("GASB worksheet updated") ActiveSheet.Range("B7")
Workbooks ("Domain"), Sheet1.Range("D2") = Workbooks("GASB worksheet updated") ActiveSheet.Range("B11")
End Sub
But VBA tells me its an syntax error on the Sub, and the whole code is in red. I am guessing with using several workbooks something else needs to be done.
Please help me out.
Thank you in advance.
Last edited by a moderator: