Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel Macros

  • 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

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


  • #3
    damnyanks
    Registered Users, Registered Users 2 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