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
Bookmarks