i have excel file where i have raw data in "Current" tab and "Previous" Tab copy pasetd from respective original files.
in Current work tab, i pulled 5 perticulat columns from Current tab in column B-F and same is done in Previous Work tab.
in column I-L i have some Arrey formula in place which search for the Match condition formula.
On basis of results in those column i pull the data using Index formula from Previous Work file matching to current work file column B-F.
Using this arrey formula it is taking too much of time to calculate my excel file (around 3-5 mins) as i have kept the calculation mode as Manuall.
can anyone help me in reducing this time or providing me simple MACRO which can be RUN once i Copy the data in Current and Previous Tab.
any help is really appriciated.