+ Reply to Thread
Results 1 to 3 of 3

Want to pull the description automatically from sheet 2 to sheet 1 for the respective code

  1. #1
    Registered User
    Join Date
    07-22-2014
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    9

    Want to pull the description automatically from sheet 2 to sheet 1 for the respective code

    Hi,

    I have an excel workbook with two sheets.

    Sheet 1 has boxes where a code and its corresponding activity has to be displayed.
    Sheet 2 has a list of codes and its corresponding activities.

    What I want to happen after the user selects the code in sheet 1 is for it to automatically fill in the corresponding activity from other sheet.

    I have also tried this "=INDEX(Database,MATCH(B13,Code,0),1)" but still I'm not able to sort it out.

    Can someone suggest what do I need to do in order for this to work?

    Attached is a very small example of my much larger project. Thanks!

    Regards,
    Arun Gopal V
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Want to pull the description automatically from sheet 2 to sheet 1 for the respective

    in C5
    =VLOOKUP(B5,Activity_Codes!A$1:B$34,2)

    and copy down
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    07-22-2014
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    9

    Re: Want to pull the description automatically from sheet 2 to sheet 1 for the respective

    Thanks Special-K. This is the functionality what I exactly needed.

+ 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. Value from one sheet to another sheet, according to description, date n month
    By beneesetas14 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-13-2014, 04:28 AM
  2. [SOLVED] Code to transfer latest entry from sheet 'Account' to sheet 'Summary' automatically
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-30-2014, 08:56 PM
  3. Pull google results - title, description,url into excel sheet using VBA
    By joewhyte in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 09:53 PM
  4. Creating a Macro that will automatically pull data from a new spreed sheet.
    By btm88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2013, 05:23 PM
  5. Allocate data from one sheet to the respective fields in another sheet
    By sreejeshc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2012, 08:08 AM

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