I am interested if I write a VBA code can it run between 2 files?

[Meko1]

Hello I know that macros can be run between several excel files, but can it run data from one file into another just by running macro?
Lets call 2 files "2020" and "2021". So if I needed to copy-paste data from "2020" to "2021" I would use =file"2021 cellA1"!.... something like this, but since my data range is big and massy I want to make code which will do specific action...

I hope I made it clear.
Thanks in advance.
Hope to hear from you soon.

 

[JLGWhiz]

You just need to identify the workbooks and the sheets in the workbooks that you want to work with. As an example:

Sub xAmple()
Dim sh1 As Worksheet, sh2 As Worksheet  'Delare the variables you intend to use
Set sh1 = Workbooks("2020.xlsx").Sheets(1) 'substitute sheet name for index number - This puts the source sheet in a variable
Set sh2 = Workbooks("2021.xlsx").Sheets(1) 'substitute sheet name for indes number = This puts the destination sheet in a variable
sh1.Range("A1:F50").Copy
sh2.Range("A1").PasteSpecial xlPasteValuesAndNumberFormat 'assumes source sheet had formulas not to be copied.
End sub

Conditions: Both workbooks would need to be open at runtime. VBA will produce an error message if the copy range includes only part of merged cells. This code assumes that there are formulas in the source sheet, so the PasteSpecial method is used. When you use the Workbooks() syntax, the sheet must also be specified, unlike the Windows() syntax. By putting the sheet and its parent workbook into a variable, the need to spell out both each time is eliminated and only the variable need be used. If you try to use the variable like 'Workbooks("2020.xlsx").sh1', it will produce an error. Same with worksheet, because both are already included in the variable and trying to combine them with the variable causes the error.

There are tutorials on the web that explain all this in great detail if you search for them. Or you could use the macro recorder to get the basic code then ask for help to streamline it.
Regards, JLg