Posts by yegimor216

Dear royUK,

Not good, I'll explain the same:

-Sheet "Mese Corrente" use the filter column D from the oldest up to today's date;

-Sheet "Mese successivo" use the filter column D from the oldest up to the date of the following month only;

-Sheet "2 Mesi successivi" use the filter column D from the oldest up to the date only 2 months later;

- "Generale" sheet use the filter column D from the oldest to the most recent;

-Sheet "Da incollare" use the filter column D from the oldest to the most recent.

Thanks

Good morning royUK,

does not work,

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

Scadenziario Generale1.zip

Thanks and best regards

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

Good evening Fuzz-Head,

Thanks for the answer, but I have a doubt but the code, where should I put?

Should I put "This Workbook" or VBA of Sheet1-2-3-4?

Have a good evening

Good evening everyone,

I have 4 worksheets:

Sheet1

Sheet2

Sheet3

Sheet4

I would like to know if there is a VBA Macro at the time of opening does the "Reapply All" filter (Filter) of all worksheets work?

Thanks for your help.