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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Macros

  • 22-05-2005 11:32am
    #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