Simple VBA making my excel so slow - file attached

Hi Everyone,

I am a begginer with VBA. I have started created a simple code. However, at the end of the vba code, I can see some calculation performed by Excel.

Indeed, on the bottom right, I can see "Calculate : 1%". It takes my Excel maybe 3 minutes to move to 2%.

This is not a big file but I would be sooo helpful if you could help me identifying what is causing this slowness.

Thanks to everyone for your help

Hi all,

Thanks for your answers.

Let's take an example with the department called "AV".

I want to apply some filters to the "BO" tab in order to select only the desired rows for the AV department. Once done, I am copying this detail into the "AV Detail" tab. I will then create a new workbook called "AV Expenses" that will include those two sheets.

Trusten, I am using array formulas as this is the only way I found to show the top 5 biggest values that meet multiple condition. For example : 1st biggest of if column A = "Apple" and Column B = "200" and "Column C < 0". Would you have another way to do it?

Roy, how and where would you use pivot tables on my model?

Thanks again much appreciated