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.
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.