Hello, I recorded a macro and actually I would like some help to optimize it.
the principle is as follows
I have 2 columns that interest me in an excel file 'text' and 'reference'.
my need is simple to make via the macro a concatenation of the 2 columns text&reference.
- count the occurrences of the concatenation
- but also the occurrences of the references.
make a dynamic cross-reference to see data with occurrences of concatenation and occurences of references
here is the macro :
thanks for your help i'm using office 2016 PC or 2019 mac
things i'd like :
1. copy the formulas calculated according to the exact number of lines (max)
in the data sheet as well as in the pivot
2. do a Smart Search of the called file :
if present on the network then I take this file otherwise I take the copy on my c: (local copy less recent but available when I don't have a network)
if already open use it directly without asking to open again
optimization of filters, calculation...
the principle is as follows
I have 2 columns that interest me in an excel file 'text' and 'reference'.
my need is simple to make via the macro a concatenation of the 2 columns text&reference.
- count the occurrences of the concatenation
- but also the occurrences of the references.
make a dynamic cross-reference to see data with occurrences of concatenation and occurences of references
here is the macro :
thanks for your help i'm using office 2016 PC or 2019 mac
things i'd like :
1. copy the formulas calculated according to the exact number of lines (max)
in the data sheet as well as in the pivot
2. do a Smart Search of the called file :
if present on the network then I take this file otherwise I take the copy on my c: (local copy less recent but available when I don't have a network)
if already open use it directly without asking to open again
optimization of filters, calculation...
Last edited: