VBA

[Yegimor]

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

[Bob Phillips]

Do the copy en-bloc, VBA will increment the cell address.

[Yegimor]

Goodmorning everyone

I am attaching the file, so you can see if I was wrong.


Thanks and best regards

[Bob Phillips]

That workbook fails on opening, it is trying to filter a table on each worksheet, there are no tables.

More detail on what is going on might help you get some assistance.