How to search a tab name. - Excel Help Forum
Oct 5, 2007 · You cannot search for text on sheet tabs. However if have a lot of tabs and you are tired of scrolling them to get to the required tab, you can right click on sheet scrolling arrows …
Returning a column header name if a cell has a value in it [SOLVED]
Mar 14, 2024 · Hi, I have 8 columns of data each with a header name (Row 1) For each row of data I need a formula that will return the header name if there is a value in that column. Each …
Search Entire Workbook [SOLVED] - Excel Help Forum
Jan 7, 2015 · Search Entire Workbook Good Morning, I'm looking to search my entire workbook for text. What I would like to do is type a name in cell M4 and then show in M5 how many …
[SOLVED] VBA Macro to search for a file in a folder - Excel Help …
May 29, 2025 · Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros [SOLVED] VBA Macro to search for a file in a folder The use of AI tools (e.g. …
Searching multiple names in an Excel document [SOLVED]
Aug 4, 2013 · Actually, you could make my life so much easier! If I have an Excel list with a lot of names (3 columns: first name, last name and pseudonym) and another document with more …
Formula to show PC name, or IP, or personal windows ID - Excel …
Jan 31, 2006 · Is it posible some formula to show PC name, or IP, or personal windows ID? ...or some computer characteristic that is different on every computer.
locating pivot tables in workbook - Excel Help Forum
Dec 12, 2013 · How can I locate pivot tables that exist in my workbook? Sometimes I create a pivot table, but I don't remember in what cell it was created. It is very difficult to locate it during …
[SOLVED] Lookup (index/match) and return column headers
Jun 8, 2017 · Forum Microsoft Office Application Help - Excel Help forum Excel Formulas & Functions [SOLVED] Lookup (index/match) and return column headers The use of AI tools …
How to Search for all files in folder starting with a defined string ...
Jun 10, 2020 · You search for all filenames that match the search term, sSearch in the selected folder, sFolder and copy all filenames into the temporary file, sTmpFile. You then copy all …
Extract names from list only once [SOLVED] - Excel Help Forum
Sep 26, 2017 · Hello forum. I have in a column, a list (B10:B1000) of names and empty cells, but the names are repeated several times. How can i have a new list, with all the names of the …