Results 1 to 2 of 2

Thread: vba newbie looking for help
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2018
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default vba newbie looking for help

    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?

  2. #2
    Board Regular
    Join Date
    Jul 2017
    Posts
    315
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: vba newbie looking for help

    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
    Work: Excel 2016 on Windows 10
    Home: Office 365 Insider on Windows 10

    Please use [code][/code] tags

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •