• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Add Row using VBA after uneven identical Dates

A

Amit Punia

Member
Hello All,
I'm having a file where I need to insert rows using VBA after uneven but for identical dates. As visible in the sheet, some of the times the same date is repeated for 2 times and for 3 times. So it's not after regular interval. In original files, it's repeated for more than 10 times. So in the First sheet, my data is available. In second sheet, I showed the out put file. Can anyone do the same using VBA. Need subtotal for all the dates and have to insert a new row after every date.
 

Attachments

  • Add Row using VBA.xlsx
    9.3 KB · Views: 3
Hi, Amit Punia!
Select A1:B10 range, go to Data tab, Subtotals icon.
Function Count.
Regards!
 
@SirJB7 That's very easy way of doing it. I didn't know about this function. This is fulfilling my requirement. Sometimes we believe that certain things can be solved only through complex functions and formulas. However today I realized that "SIMPLICITY IS THE KEY TO SUCCESS."

Thanks a lot for the help @SirJB7 :)
 
Hi, Amit Punia!
Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.
Regards!
 
You must log in or register to reply here.
Back
Top