joshua1990
11-02-2017, 01:45 AM
Hey community!
I'm just trying to minimize/ simplify a big table. This table summarises a lot of different datasets from diverse other tables in collaboration with a big quantity of LOOKUPS und some basic calculations. This leads to a slow start everytime I open the file.
According to an aim with a very fast start I would like to minimize the functions.
What ideas do you have?
Every column has his own relative function. I would start to place only one function at the beginning and place the other functions as a static value. In connection to a vba procedure I would like to get a loop which runs the function till the last cell.
Do you have an idea for this loop/ code?
Best regards!
I'm just trying to minimize/ simplify a big table. This table summarises a lot of different datasets from diverse other tables in collaboration with a big quantity of LOOKUPS und some basic calculations. This leads to a slow start everytime I open the file.
According to an aim with a very fast start I would like to minimize the functions.
What ideas do you have?
Every column has his own relative function. I would start to place only one function at the beginning and place the other functions as a static value. In connection to a vba procedure I would like to get a loop which runs the function till the last cell.
Do you have an idea for this loop/ code?
Best regards!