How to automatically generate report by VBA?

[Andy23]

So in fact you did not ever try anything ! ​

As a reminder : easy to learn with using the Macro Recorder and reading VBA help.​

​

Anyway according to post #16 the last century VBA demonstration revisited as my last try :​

Hello Sir,

It works perfectly. Yes I used macro recorder for other works sheet.
And Sir, In the previous data I used column D for the distinct count of receipt. Then now I used column A instead of column and tried to update the VBA, but I couldn't get the correct result. And It is possible to calculate column J,K,L in VBA also Sir?
I also do research and read VBA programming. It really takes time to be able to write VBA code.

 

[Marc L]

As I wrote « according to post #16 » so try with its attachment and you should obviously see the columns J:K calculation​

as it keeps the existing formulas so nothing to do under VBA ! For other column(s) just add the formula in the first row.​

​

Array variables V & W work like the VBA statement Cells, for example V(R, 1) is the first column of row R of the source table,​

W(L, 3) is the third column of row L of the destination table … So you can change the column index according to your modification.​

​

As a reminder do not create any thread on any Excel forum until your project is fixed, all well known,​

nothing variable, nothing which may change …​

​

 

[Andy23]

As I wrote « according to post #16 » so try with its attachment and you should obviously see the columns J:K calculation​

Hello Sir,

Thanks for your explanation and kind support.
Now I am able to update the VBA.
Thank you so much!

Have a great day Sir.

 

[vletm]

Andy23​

As You'll add there eg weekly new data to Details-sheet then even Excel no need to solve the whole data every time.
Let even Excel do only needed work.
This sample has (solved) data until 31-Jan-2023 and
I left there to add the rest of Your sample data to add eg Weekly ... as You'll normally do.

 

[Andy23]

Andy23​

As You'll add there eg weekly new data to Details-sheet then even Excel no need to solve the whole data every time.
Let even Excel do only needed work.
This sample has (solved) data until 31-Jan-2023 and
I left there to add the rest of Your sample data to add eg Weekly ... as You'll normally do.

Hello Sir,

It works like a charm!
Thank you for the solution.

Have a great day Sir!