Hi

I have many vlookups in a spreadheet to look up a specific value in many
columns.

Is there a way to have a macro to fill up these columns instead of having
dozen
of vlookup in the file?

regards, xlsops

While I am sure it is possible I am not sure why you would want to? Is there
a performance issue or some other concern you have? If you make it inot a
macro then the ability of the average user to fix it or trouble shoot it is
gone. Why add the complexity of a macro if you don't need to...
--
HTH...

Jim Thomlinson


"franciz" wrote:

Hi

I have many vlookups in a spreadheet to look up a specific value in many
columns.

Is there a way to have a macro to fill up these columns instead of having
dozen
of vlookup in the file?

regards, xlsops

Hi Jim

There are about 20 somethings Vlookups, a few Index & Match and
Sumproduct in this spreadsheet spanning across from Col A to Col AE,
users need to fill this up after the first macro run on combining all the
workbooks in a folder to one new summary sheet in a new workbook
and copying all the dataset to its respective sheets.
The combined data on the new summary sheet can amount from
300 rows to 1700 rows depending on the day's transactions

There seem to be some slowness in the perfomamce of the new summary
sheet in term of filtering, sorting, subtotals and calculations.

Importantly, is that users are not very familiar with Excel and hence the
formulas
provided always got messed up. Hence, the idea of filling up formulas
the respective columns in the summary sheet via a macro.

The columns to be fill up is always fixed, ie col B, D, K, L, N to V taking
the different
dataset from worksheet named Rate, Code, Client, Tax and so on.

TIA

regards, xlsops


"Jim Thomlinson" wrote:

While I am sure it is possible I am not sure why you would want to? Is there
a performance issue or some other concern you have? If you make it inot a
macro then the ability of the average user to fix it or trouble shoot it is
gone. Why add the complexity of a macro if you don't need to...
--
HTH...

Jim Thomlinson


"franciz" wrote:

Hi

I have many vlookups in a spreadheet to look up a specific value in many
columns.

Is there a way to have a macro to fill up these columns instead of having
dozen
of vlookup in the file?

regards, xlsops