+ Reply to Thread
Results 1 to 1 of 1

formula/vb to search data on two sheets upon data query of a control sheet to give report

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    EXCEL 2016
    Posts
    1,054

    formula/vb to search data on two sheets upon data query of a control sheet to give report

    Hi All

    Am looking a formula or vba that can search data in two sheets, the control sheet what ever data is entered in column B in respect of their headers in column A ,should be able to LIST all data corresponding to data entered in column B ,
    however the data entered in column B in control sheet may not tally with their corresponding headers that is as example itemno '0000537 is entered and 'ITEMDESC 'FIBERNET 1M20 GRIS - RL30 / AU METRE is entered You will noticed that these data may have not relationship but it must show their respective data
    from both sheets .

    Is this possible as sheets 2014 and 2015 may have up to 30000 rows and formulas in it for sake of example they do not appear

    the search is very painful and slow. Everyday I got crazy with this tedious task

    Can anyone help me.

    thanks
    Attached Files Attached Files

+ 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: 7
    Last Post: 01-12-2015, 02:48 PM
  2. Replies: 2
    Last Post: 12-17-2013, 08:21 AM
  3. Search Macro Needed
    By O0J0E in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2012, 11:19 PM
  4. Replies: 0
    Last Post: 11-19-2009, 09:20 AM
  5. Replies: 8
    Last Post: 05-01-2009, 12: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