Closed Thread
Results 1 to 2 of 2

A script that find strings, list Sheets with matches, and hyperlinks to results

  1. #1
    Registered User
    Join Date
    10-18-2022
    Location
    Berlin
    MS-Off Ver
    2019
    Posts
    1

    Question A script that find strings, list Sheets with matches, and hyperlinks to results

    Hello,

    My question would be better posted in Commercial Service since I have little code to alter, but I don't have Paypal and am unable to mix and match what I found. The output is always a message box, which I don't need. Basically, I need a script from scratch. I am interviewing for a position, and it's hardcore, so a script would help me prepare for it.

    What does the script need to do?

    1) On Start tab, Cell C5 is a text field to enter search text
    2) Next to it is a Go button
    3) Look through all Sheets in WB and list sheet names that contain search value in F6, F7, F8, etc.
    4) List entire cell content with search value into G6, G7, G8, next match in I6, I7, I8, and so on, wrap text
    5) In H6, H7, H8, etc. list cell address as hyperlink, continue in J6, J7, J8 for next match and so on
    6) Reset button to erase matches for next round on Start tab
    7) Bonus, freeze the first tab

    It's a lot to ask, right? But I am desperate and don't have time, of course. If you can think of partial script matches solved here, can you send links? Maybe I overlooked something and can piece it together myself, but I am literally the dummy that finds free scripts and alters it until I fail or succeed.

    Any help is so much appreciated, as I really need to get out of my current position and get that job.

    Thanks, Monika
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,990

    Re: A script that find strings, list Sheets with matches, and hyperlinks to results

    How will you explain the script that you want us to hand to you on a plate when you are interviewed?

    Sorry, but it would not be ethical to help you to get a job in this way.

    I am closing the thread.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 11
    Last Post: 03-30-2022, 02:12 PM
  2. Find pattern matches in hundreds of thousands of strings - speeding it up.
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2017, 12:28 PM
  3. Comparing Data between sheets to find matches and no matches
    By tysont in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-26-2015, 03:07 PM
  4. Find and Display results VBA Code - Loop to find all Matches
    By i2rule in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-16-2014, 03:14 PM
  5. [SOLVED] Find Exact matches on 2 sheets and export results to 3rd Sheet
    By gadrummer65 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 05-27-2014, 01:41 PM
  6. Macro to search rows for matches from a list of strings, then copy to a new worksheet
    By Conundrum4000 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-23-2014, 08:31 AM
  7. How to find number of pairs of strings from list of strings?
    By greg_overholt in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-27-2006, 06:45 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