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