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 (at left most …
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 row of data …
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 times that name …
[SOLVED] VBA Macro to search for a file in a folder - Excel Help Forum
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. chatGPT, …
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 columns and a …
Formula to show PC name, or IP, or personal windows ID - Excel Help …
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 subsequent …
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 filenames that are …
Lookup Sheet name and return cell value in that sheet. - Excel Help …
Jun 15, 2016 · Re: Lookup Sheet name and return cell value in that sheet. try this where A1 is on your main sheet and has the name of the sheet and A2 is the cell reference on sheet2 =INDIRECT …
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 existing list, …