+ Reply to Thread
Results 1 to 5 of 5

macro that will display the value of a name from another sheet

  1. #1
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    399

    macro that will display the value of a name from another sheet

    Hello everyone..

    I have here two files.
    First the sample.xls i want to show the equivalent of the acronym in this sheet. the equivalent of the acronym is found on the other file.

    for example: A006 - should be bitumen.

    I know how to do this on excel function but i want it to be on macro.. so i could just click a button..

    hope anyone can help..

    please find the attached files

    thanks in advance..
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: macro that will display the value of a name from another sheet

    I suppose I have to ask, if you have a solution why do you want a more complicated solution? or can you not use VBA to apply the formula you need?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    399

    Re: macro that will display the value of a name from another sheet

    because i can apply the macro in all other sheets. if i use the vlookup, index match function it will amke the file bigger.

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: macro that will display the value of a name from another sheet

    Why not use VBA to apply the formula you know already works?

    I guess I just dont see the value add here.

  5. #5
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    399

    Re: macro that will display the value of a name from another sheet

    index match function is the only thing i know for this. i need a macro because the line items of the file is reaching 100,000 lines. Using index match would make the file bigger.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] only display a messagebox when the sheet is activated through user, not macro
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-21-2013, 08:15 AM
  2. Using a Macro to search though a database and display the results on a new sheet
    By tmbg99 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-07-2013, 05:34 PM
  3. Replies: 5
    Last Post: 11-30-2012, 01:33 PM
  4. Macro to display sheet numbers
    By iamjess147 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2010, 04:48 PM
  5. Replies: 1
    Last Post: 11-08-2005, 10:20 PM

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