Extrapolation Macro VBA

  • Goodmorning everyone,

    I am using a table with our company program, in the morning I extrapolate in xls format, but when I create the links to copy the values, it is better to use the VBA or use the formula "='C:\Users\1\Desktop\[s.xlsx]data'!E2"?

    I have an Excel file with the sheet name "To be pasted" only from A2 to X20000 and I have to copy the file "C:\Users\1\Desktop\s.xlsx" from E2: AB20000 which formula should I use the macro?

    Thanks for your help

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!