Hello,
Actually I'm trying to filter some data and dispatch them to other sheets by using VBA (this code works !). But to start the macro firstly I need to copy all the data from the source workbook and paste it on the macro workbook.
Is there a way to pull out for example Data (all the data) from the source workbook (the closed one) and paste it from the celle A2 by using VBA (on the macro workbook).
Hope to find some help.
Actually I'm trying to filter some data and dispatch them to other sheets by using VBA (this code works !). But to start the macro firstly I need to copy all the data from the source workbook and paste it on the macro workbook.
Is there a way to pull out for example Data (all the data) from the source workbook (the closed one) and paste it from the celle A2 by using VBA (on the macro workbook).
Hope to find some help.