I need VBA code or function to do this scenario:
(I have attached three files: File 1, File 2, and file)
- Macro should be put in sheet 1 of the attached File 1 and File 2.
- Macro sends the information of sheet 1 in each File 1 and File 2 to another excel file (File) without deleting any information related.
- Arrange the information as shown in sheet 1 of (File)
is it possible to do that? and How can do it?
Many thanks in advance
