vba newbie looking for help

[andybno1]

so I have spreadhseet that I want to do a couple things in VBA and compatible with excel 2013

sheet1 (named complaints):
sort column E in numeric order older to new automatically as entered it will sort for me

when column I is marked yes to then move that entire row to sheet2 and removed from sheet1

sheet2 (named completed):
sort in date order older to newer in column I

anyone able to help?

 

[mrhstn]

Hi andybno1, welcome to the board.


This sounds like an easy job for the macro recorder...


1. Power up the macro recorder and set her recording
2. Sort Column E
3. Apply a filter to your data
4. Filter Column I for yes
5. Copy this to a new sheet
6. Back to the previous sheet
7. Highlight the visible rows and right click >> Delete Rows
8. Unfilter column I
9. Stop the macro recorder.


The code will likely want tidied up some, made a little more robust and such. If you want a hand then post back what the record spat out