+ Reply to Thread
Results 1 to 9 of 9

need vba to pull data from another sheet based on cell input

  1. #1
    Registered User
    Join Date
    02-11-2016
    Location
    dubai
    MS-Off Ver
    msoffice 2010
    Posts
    63

    need vba to pull data from another sheet based on cell input

    Dear Friends,

    On my Sheet 2, I have a data with below headings.

    Referencenumber Customerdetails Currency Amount xxxx yyyyyy zzzzz aaaa bbbb cccc

    On my Sheet 1, I need those above data to be captured based on the Input in a field C4

    Note: All the above data in sheet one to appear in Columns (i.e. E4,E5,E6,E7,E8,E9,......) and also show this item in Red Color.

    Another note: Sheet 2 will be having approximate 1,000,000 rows with above said headings.


    Please help me with VBA macro and also to be faster after writing the C4 field.

    Thanks

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 2016
    Posts
    4,903

    Re: need vba to pull data from another sheet based on cell input

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Registered User
    Join Date
    02-11-2016
    Location
    dubai
    MS-Off Ver
    msoffice 2010
    Posts
    63

    Re: need vba to pull data from another sheet based on cell input

    Dear

    I have updated the required excel as a sample. Kindly support.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-11-2016
    Location
    dubai
    MS-Off Ver
    msoffice 2010
    Posts
    63

    Re: need vba to pull data from another sheet based on cell input

    Dear

    I have given the sample excel. Kindly support in providing solution.

  5. #5
    Registered User
    Join Date
    02-11-2016
    Location
    dubai
    MS-Off Ver
    msoffice 2010
    Posts
    63

    Re: need vba to pull data from another sheet based on cell input

    Dear Arkadi,

    I provided the required excel. Please help.

  6. #6
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,111

    Re: need vba to pull data from another sheet based on cell input

    see the attached file
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  7. #7
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,794

    Re: need vba to pull data from another sheet based on cell input

    @ anuwers

    Only using the last 6 digits there will be only 1 match in over 1 million rows ?????? What are the odds.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  8. #8
    Registered User
    Join Date
    02-11-2016
    Location
    dubai
    MS-Off Ver
    msoffice 2010
    Posts
    63

    Re: need vba to pull data from another sheet based on cell input

    Thanks Samba Ravi.

    I am getting if i write full 16 digits. But if i write the last 6 digit of 16, not getting data in F4 and below.

  9. #9
    Registered User
    Join Date
    02-11-2016
    Location
    dubai
    MS-Off Ver
    msoffice 2010
    Posts
    63

    Re: need vba to pull data from another sheet based on cell input

    There is plenty of references, which we used to have last 6 digit of 16 digits or full 16 digits
    Reference will never appear again in any of the rows.

+ 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. Replies: 0
    Last Post: 03-30-2016, 09:08 PM
  2. Pull data from multiple sheets based on cell in Main sheet
    By cpyter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-29-2014, 01:19 PM
  3. Pull data based on user input
    By mani_bbc05 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-14-2013, 03:39 PM
  4. [SOLVED] VBA to pull data from worksheet to a new sheet based on specific text cell value
    By TalResha in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-13-2013, 02:11 AM
  5. Replies: 19
    Last Post: 05-13-2013, 01:08 PM
  6. Replies: 3
    Last Post: 01-27-2013, 07:23 PM
  7. Pull data from a specific sheet that matches cell value on Input Sheet
    By vaciaravino in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-12-2012, 08:38 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