Hello,

Is there a way to use a macro to automatically upload data from one
spreadsheet into another? At the moment i have to use copy and paste option -
but with the amount of data and format of the spreadsheets it has become very
time consuming. I have to copy and paste individual columns into destination
spreadsheet and I wonder if there is a way to automate this process?

I will be very grateful for any tips.
Thank you
M.