megamind007
New Member
- Joined
- Sep 22, 2013
- Messages
- 43
Hey folks,
I need a macro (or if there is formula or any other method ) that counts the increase and decrease in the number of rows at the end of each day (i.e. number of records inserted and deleted in a workbook in some of the sheets and then gives a sum of those increases and decreases.These rows are transaction records and I dont need a net figure.I need increases and decreases separately.
P.S:these rows are in different sheets of the same workbook and i need the increase and decrease on a new worsheet of the same workbook.
Thanks in anticipation.
Regards,
I need a macro (or if there is formula or any other method ) that counts the increase and decrease in the number of rows at the end of each day (i.e. number of records inserted and deleted in a workbook in some of the sheets and then gives a sum of those increases and decreases.These rows are transaction records and I dont need a net figure.I need increases and decreases separately.
P.S:these rows are in different sheets of the same workbook and i need the increase and decrease on a new worsheet of the same workbook.
Thanks in anticipation.
Regards,