names

I have this vba code but it returns ALL of the sheet names. But I want another-one that returns the sheets that start with the letter "D" and list them in column H58 on "switchboard". Sub WORKSHEETLIST() Dim ws As Worksheet Dim Counter As Integer Counter = 0 For Each ws In...

Hi All, I have about 15 sheets in one workbook, which are named using numbers eg. 12345, 54321, 65432....etc. I'd like to reference/link the names of all these sheets on to one main summary sheet. This is different from referencing the sheet name within that same sheet. Is there some way to...

If I import a table in Excel PowerQuery, what functions and syntax do I use to reference another table for the names of the different columns?

I am looking for a formula for the following: List of names and salaries for the top 10% of a compinies top earners List of names and salaries for the bottom 10% of a compinies top earners

Hi would appreciate any assistance here. I have a cell in sheet Fig 2 that has multiple names. this cell brings names based on a macro from Master_Data sheet. I would like to be able to know who is male and who is female. In Master_Data I have a column which specifies female or male, Column D...

Hello. In cell A1 I'm receiving Customer names an their home town in form of huge HTML code. I need to extract Customer names in column A (A3:A600) and their home towns in column B (B3:B600). Part of HTML code for names is always the same: <div class="customName--1gBeC">J. Jones</div> Part...

Hey. I had a question of exporting data from Excel to MySQL. There was an acute question with pictures. Pictures must be saved with the names that appear in the next column. How can I do that?

Hello So I have manged to find a formula to help produce a list of unique names based on rules, but i can only get it to return the first name from the whole list. {=IFERROR(INDEX(Master!$B$2:$B$500,MATCH(0,COUNTIF(H$2,IF(Master!A$2:A$500=H$2,Master!B$2:B$500,H$2)),0)),"")} "Master B" is the...

Hi. I'd like to have a button on Sheet 1 where the user clicks it and it creates an exact copy of Sheet 1* but up pops a little box that says "Please enter your name below then click Ok" and when they do that, it creates a new worksheet that is an exact replica of what's on Sheet 1 (even down...

Hello Team, we have requirement, where in i have the excel files in the folder, where i need to move in to one workbook with sheets names as workbooks names in the folder.

I would like to have names listed in sheet1 in column A, beginning at A3 and ending on A30. So if there is a name in A3 ( George) and (Sam) in A4, (John) in A5 and so on, I would like it to change the sheet names from Sheet2 to George, sheet3 to Sam, sheet4 to John, etc Is this possible?

Hello Team, i have all the files names(.xlsx) that is in the folder and currently i have to sum Column B from "sheet1" of each cell. NOTE: All the file will be closed, except the master with all the xlsx file names in the folder & in the same sheet i have the formula.

hi all, i am trying to work out a way of counting unique/distinct names in a list. Unfiltered is straightforward. In each row: countif($a$2:$a2,$a2). I need to be able to have a formula that will also operate on the same data when it is filtered. I aim to be able to identify distinct names by...

Hi everyone, I've tried finding an answer to this on my own, but to no avail. To sum up my problem, I'm trying to write a macro that could take the input data from Sheet2 (see below) and rearrange it so that it can be used for data import in Sheet1. Name IDs would need to be repeated...

Hi. On my useform i select a name from a list & then press the transfer button. Now on my worksheet todays date has been entered in the cell which refers to the name i had selected on the userform. Normally the list on the userform has many names so this is a first for me because now there are...

I’m trying to return the number of times a name appears in a range of cells based on the criteria of another cell. In column AT I have names of departments: Safety, Quality, FI, etc. In columns AX:BG I have a bunch of people’s names. On another sheet I’m trying to find how many times a name...

Hello I need a vba form with two fields, one of which is a drop down list of names and the other is a decimal value to store names in the cell and a decimal in the comment. Then I want to formulate and calculate on the decimals inside the comments. Can anyone help me?

Hi, I'm working on a stats project and need some help. I've got my two columns, one for first names and the other for last names, and I'm trying to figure out how to merge them so they read in one cell as the full name and then alphabetize them by last name; if it is possible. I've gone as...

I don't know if it is possible, but is there a way to use index/match in an IF statement? Or maybe something else will work. I have a range of A5:F250 with a list of events for different entries. Column A = First Names Column B = Last Names Column D = Name of Events (Birthday, Deceased...

Hello. I am trying to import a webpage and its tables into excel I use the data tab, then from web, and import the webpage When I do this, the web view on the pop-up displays the webpage perfectly. Note - It does have the "table highlighting is disabled because...." On this webpage, there...