Change formulas to macro to create report

You don't need macro for this:

For BUYING,SELLING,RESTTR,RESSR use:

=SUMIF(INDIRECT("'"&$A5&"'!D1:D20000"),B$4&"*",INDIRECT("'"&$A5&"'!G1:G20000"))

And for other change to:

=SUMIF(INDIRECT("'"&$A5&"'!D1:D20000"),B$4&"*",INDIRECT("'"&$A5&"'!E1:E20000"))

thanks
but if I don't need macro why you give me formula and I have really formula?

For constency.

anyway, here is a macro:

Please Login or Register  to view this content.

perfect !
may also you do when write two dates?
as I said

and if the cells B3,C3 contain DATES then will just merge amounts locates between two dates.

Here, try this:

thank you so much.