+ Reply to Thread
Results 1 to 1 of 1

VBA coding search box through multiple sheets

  1. #1
    Registered User
    Join Date
    01-23-2022
    Location
    singapore
    MS-Off Ver
    2022
    Posts
    6

    Unhappy VBA coding search box through multiple sheets

    Good day everyone,

    I am working in an engineering company and have been tasked to create a sort of filter for their excel file. There are hundreds of different sheets of products updated monthly.
    Im not sure what vba code to type out, there is a layout of search box on sheet 1 which the user will be able to key any word or number value in text box and similar multiple results from the different sheets of products will populate below it as a full row from month to location. Also im not sure if its possible for photos from data sheets will follow the filter to the sheet 1 too. PS: black collumns also will be populated onto sheet 1 so full row of data...

    excelforum
    myonlinetraininghub
    ozgrid
    chandoo
    not enough post few times so cant insert any links but i posted this on other website to collect solutions which fits best for my query thank you sorry.

    I kindly seek your guidance anyone out there if you can provide me a sample coding, reference link or you may edit my sheet to test it out thank you very much

    regards
    Attached Files Attached Files
    Last edited by roseblack; 03-25-2022 at 12:30 AM. Reason: cross-posting update

+ 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. Pasting formula to multiple sheets and then hard coding the #s
    By MatchaLatte in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-07-2021, 07:36 AM
  2. [SOLVED] Conditional formatting using multiple sheets and search function in multiple rows & column
    By Unlimited007 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2020, 01:28 PM
  3. Replies: 12
    Last Post: 11-20-2017, 04:45 PM
  4. [SOLVED] Search Columns from Multiple Sheets If Match Populate Value from 1 of the sheets
    By kellyjo7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2014, 05:52 PM
  5. [SOLVED] Error with multiple search/copy/paste. I don't know how to finish the coding off.
    By Enigma1985 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-30-2012, 08:17 AM
  6. Need to Search for Value Across Multiple Sheets, Value Occur Multiple Times on Sheets
    By davidbriansmith in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-23-2011, 12:31 PM
  7. Search and Delete Across Multiple Sheets According to Values in Sheets
    By Tyler_Durden in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-12-2009, 04:40 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

X vBulletin 4.1.8 Debug Information

  • Page Generation 1.06215 seconds
  • Memory Usage 8,866KB
  • Queries Executed 16 (?)
More Information
Template Usage (33):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (1)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (1)postbit_attachment
  • (1)postbit_legacy
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (49):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1