+ Reply to Thread
Results 1 to 3 of 3

Please help! VBA Code to return cell value

  1. #1
    Registered User
    Join Date
    09-05-2012
    Location
    Derbyshire, UK
    MS-Off Ver
    Excel 2007
    Posts
    8

    Please help! VBA Code to return cell value

    Dear Experts,

    i am a very novice VBA user just learning to adapt code and wondered if you could assist me here. I have attached a file for your reference.

    My aim is to create a list of location (a7) and return the technical role name (row 5) if the cell value is an "X"


    My list would look like this .....

    Location Technical Role Name
    ARA2 ZSN_DATA_MGR_AR010
    ARA ZSN_DATA_MGR_CSTMR


    and so on.... please help

    Thanks

    A
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Please help! VBA Code to return cell value

    return the technical role name (row 5) if the cell value is an "X"
    Where? Which column/row?

  3. #3
    Registered User
    Join Date
    09-05-2012
    Location
    Derbyshire, UK
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Please help! VBA Code to return cell value

    Quote Originally Posted by AB33 View Post
    return the technical role name (row 5) if the cell value is an "X"
    Where? Which column/row?
    I would like it displayed in a new sheet if possible

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1