Request help/suggestion to simplify the work

[deepanjk]

Hi,
I have a master file with thousands of rows. I need to incorporate few details against these rows from multiple files. I need to key in formula to derive the column, take data from other files and also put a pivot in one file before that data gets mapped in master file. Multiple excel files are used to get data into one and then filter the data in master file to transfer to new file. This new file is used to derive some metrics. The same new file is used to filter specific category wise data to put in a different files for sharing with specific group of teams.

Time consuming... multiple excel files.

Kindly suggest/help me to simplify this time consuming process.
Even if I can get some suggestion wherein I can come up with a kind of tool with just update new files/refresh the data and the data is ready.
Please help.

Thanks in advance.

Regards,
DJ

 

[GraH - Guido]

It depends... I would go with Power Query (merging files, google it), others are more relying on macros, and some might even pull it off easily with formulae. Your Excel version might be a reason to go with the one or other solution.
Also for deriving KPIs, one could consider using Power Pivot measures.

The request as is perhaps to vague to give very good pinpoint advise. It could be that the whole process can be replaced by a single access db with a front/back office principle build in.