+ Reply to Thread
Results 1 to 2 of 2

Need help - macro filter cell value sheet1 in table sheet2

  1. #1
    Registered User
    Join Date
    05-03-2015
    Location
    Netherlands
    MS-Off Ver
    MS2013
    Posts
    5

    Need help - macro filter cell value sheet1 in table sheet2

    Hi all,

    Question1-
    The idea is:
    When selecting a cell in table sheet1 the value is shown in cell B6. When the Search button is pressed the value in cell B6 is filtered in table sheet2. So the value being looked up can differ but is always looked up in the same column. Also the macro first unfilters the table first.

    When I program the macro in the same sheet it works, but i think my code is having trouble at the end reffering to the cell on the right sheet. Can anybody help me out?

    This is the code:
    Please Login or Register  to view this content.
    Question2-
    The length of the tables on sheet1 and sheet2 differs. Do I need to change the code to some kind of 'end of table' code? What should i do then?
    Attached Files Attached Files
    Last edited by Leith Ross; 07-19-2015 at 03:29 PM. Reason: Added Code Tags

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Need help - macro filter cell value sheet1 in table sheet2

    Hello GoldbergJesse,

    Here is the working code...
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ 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] A macro which pulls the data from sheet2 to sheet1 basis of scenarios selected in sheet1
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2015, 01:46 PM
  2. Macro to copy table from sheet1 to sheet2 (qty of rows may vary)
    By arkharova.s in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-18-2014, 03:54 AM
  3. macro to copy table from sheet1 to sheet2 (# of rows in table may vary everytime)
    By arkharova.s in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2014, 03:18 AM
  4. Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  5. Filter from sheet1 to sheet2
    By s128 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-15-2013, 11:45 PM
  6. Replies: 5
    Last Post: 12-19-2012, 11:05 AM
  7. Macro to copy range of cell from sheet1 to sheet2 based on a cell value in sheet2
    By drgwhizz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-25-2012, 10:39 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