Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel Macros

Options
  • 22-05-2005 12:32pm
    #1
    gpsstudent
    Closed Accounts Posts: 32 ✭


    Hi
    I am completely unexperienced in designing
    excel macros but have just encountered a
    situation where I need their use.

    I need to copy the cells that contain the text "prj"
    from column A and place them in order in column B

    Essentially I am filtering column A.

    Heres an example of what I'm talking about
    http://www.geocities.com/thalkirchen03/example.JPG

    Has anyone any ideas?

    Thanks in advance for any assistance


Comments

  • Options
    #2
    cyberbob
    Closed Accounts Posts: 82 ✭✭cyberbob


    gpsstudent wrote:
    Has anyone any ideas?

    sure , learn VBA! .
    in the meantime put in a new column with the formula '=NOT(ISERROR(SEARCH("prj",A...)))' , and use excels inbuilt filters to filter by this column and then sort by A .


  • Options
    #3
    damnyanks
    Registered Users Posts: 4,276 ✭✭✭damnyanks


    If you have any programming knowledge at all use the macro recorder and hack whatever code it puts out to do the job you want.


Advertisement