• 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.

Date Wise Sorting in a separate row (VBA Help)

fahadferoz

fahadferoz

Member
The import tab has a vba code already. It extract all the data from the other three tabs.

The requirement: I need to sort the dates automatically when it imports. The sorting must be in a way where the later date arrives in a separate row (please have a look at the requirement picture attached herewith).

Please help me to write the code. I tried so many times but failed.
 

Attachments

  • Requirement.jpg
    Requirement.jpg
    322.3 KB · Views: 5
  • Workbook1.xlsm
    58.6 KB · Views: 2
  • VBA.png
    VBA.png
    92.2 KB · Views: 3
... and of course,
You tried to solve it Yourself,
am I right?
 

Attachments

  • Workbook1 (2).xlsm
    60.6 KB · Views: 2
Sorry for bothering again. But if I knew how to do it I wouldn't have asked for help!

Still getting an error. Please help!
 

Attachments

  • Screen Shot 2017-02-14 at 8.00.51 AM.png
    Screen Shot 2017-02-14 at 8.00.51 AM.png
    534.4 KB · Views: 3
  • Final Workbook.xlsm
    69 KB · Views: 4
Last edited:
I got this kind of result (top rows) with Your the newest file
... without any errors!
Screen Shot 2017-02-14 at 11.12.44.png
It's challenge to modify ... if nothing to modify!
 
You must log in or register to reply here.
Back
Top