+ Reply to Thread
Results 1 to 3 of 3

Fetch data from one sheet to another when user enters data

  1. #1
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    195

    Fetch data from one sheet to another when user enters data

    I have a sheet named "Sheet2", in which two columns has my data. In Column A, i have Equipment ID and In Column B, i have TAO number.
    On other sheet named "Final Log", In column E(Equipment ID) and column F(TAO number) i am using the same data
    but user will enter this data. Now i want when user enter data in column E, it should automatically fetch it,s TAO number
    from Sheet2. Please help me. Attached are snapshots and file
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    16,646

    Re: Fetch data from one sheet to another when user enters data

    F4
    =IF(E4<>"",IFERROR(VLOOKUP(E4,Sheet2!$A$2:$B$27,2,FALSE),""),"")
    copy down

  3. #3
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    195

    Re: Fetch data from one sheet to another when user enters data

    Thank you Jindon....this works fine

+ 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] Autofill data with value where row and column intersect after user enters data
    By trubio77 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-16-2017, 04:11 PM
  2. Replies: 0
    Last Post: 02-10-2016, 09:37 PM
  3. lock cell and/or message box after user enters data?
    By ashtally in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2015, 04:56 AM
  4. Fetch data from sheet having same name as of data heading
    By caabdul in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2014, 11:43 AM
  5. Replies: 4
    Last Post: 10-20-2012, 07:41 PM
  6. Replies: 2
    Last Post: 12-31-2011, 02:44 AM
  7. how to copy data from one sheet to another when a value enters in prior sheet's cell?
    By suhailtholakkal in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-24-2011, 04:37 PM

Tags for this Thread

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