names

  1. S

    Extract Last Name from Email Address

    There is a similar thread to this that was not answered. I would like to extract just the last name from an email address. My email naming format is First.Middle.last@email, or First.Last@email. Basically, I want the name between the @ and the ".". I found this formula online...
  2. T

    VBA bug in deleting a Name if there are two Names with the same name property but differing scope

    Names can either have workbook scope of worksheet scope. Excel allows you to create multiple names with the same Name property if they have different scope. So for example, I could have two names called "test" where one has workbook scope and one has worksheet scope. The problem is that if I...
  3. T

    Move names into a text box and pushing data back

    Hi Everyone So I need to get some names and make userform inputs so heres what i need, I have 5 Cells with headers and 5 cells which need readings I have userform1 I want to take userform1 and Place the headers from Cells A10,C10,E10,G10,I10 to header boxes Below the header boxes I have Input...
  4. J

    Index/Match and Concatenate

    Hello: I have a list of first and last names and amounts in a range. I want to find the amount that corresponds to both the first and last names and return that value. I've used Index/match in the past when there was only the last name and it worked fine. Now, when I added the first name, I...
  5. MrManBoy

    Split full name w/single and multiple middle names

    Hi All, Problem: I have a data-set that has a list of full names. Splitting the first and last name is fine enough however, some of the names have multiple names between first and last name. Looking for a way (preferably w/a formula),that splits these multiple names as well splitting first and...
  6. H

    Pull results from a defined column region and list one instance of each in another cell

    Hi. I've got a list of names in Col G from row 14 down. Users add the name or names of the owner/s of the associated task described on that row. VBA allows the user to enter more than one name in the cell as sometimes two people are involved on a single task. What I'd like is to have a...
  7. W

    VBA Random selection from list of names

    Hi All, I'm working on a spreadsheet that I would like to pick a random name from a list of 10 names using a vba button. the list of names are in cells C3:C12 and I would like the selected name to appear in cell D3 Thanks in advance.
  8. A

    VBA to go to previous workbook

    Hello, I have little knowledge of VBA and I usually do my macros by recording and cleaning the code slightly. I want to know if I am working with two different workbooks I can move between them with my macro without referring to their names because everytime I use the macro the names of the...
  9. D

    type mismatch??

    if i have this finalrow = Cells(Rows.Count, "A").End(xlUp).Row Set myrange = range("c3:c" & finalrow).SpecialCells(xlVisible) If Application.CountIf(myrange, "Repo") = 0 Then im basically filtering, one at a time, each name in column A and looking if there are repos in column...
  10. N

    VBA Code to insert the same data for many clients!!

    Hi, I have a userform with many controls, and below are some of them txtBarCode (TextBox) [where I insert the needed Item's Barcode] cmbNum (ComboBox) [(List from 1 to 8) to Identify the clients number] txt_Name1, txt_Name2 ...txt_Name8 (TextBox) [To insert the client names, (if cmbNum = 3...
  11. N

    Data Cleaning - help

    Dear Experts I had to complete a huge excel cleaning job and was not provided time. Please refer to the attached input and reference output tabs. I have excel column, with names in various formats, I need to compare each cell of this with master database and if matching print the row number...
  12. M

    1004 error on Macro to Delete All Names in ActiveWorkbook

    Hi- My Company's software macro creates hidden names in our workbooks making them clunky and unnecessarily large, so I am trying to get a macro to first unhide all names in the name manger, then delete all, except the print range. Except I am gettin a 1004 name syntax error on the n.Delete...
  13. W

    Copy sheet with same row values to another sheet

    Hi, I'm a newbie when it comes to excel, to be honest all I know was the basic stuff, I just learned the word macro earlier this day from my boss, currently reading some of it. I was tasked to sort/clean output of data to our sheets, I would like to ask on how to copy the rows with the same...
  14. K

    Determine if ActiveX ComboBox is deselected

    I have a Private Sub that runs if an ActiveX ComboBox is CHANGED. The problem is, every time you type a letter in the open field (if a selection is not available) the code fires and slows down your typing. Is there a way to determine if the text field of the combobox is deselected and if so...
  15. S

    Copy from one sheet to another baed on an IF AND OR

    I'm not sure if what I'm asking is possible to accomplish with excel. But what I would like to do is on sheet one copy list names that meet specific criteria based on IF AND OR of contents of columns next to their names. <tbody> Name Y N M YES jim 1 1 y jeff 1 y bill 1 n sam 1 y...
  16. T

    Is it Possible to add a dummy column to auto populate name from another column

    Hello all, hope you can help me on this. Since I cannot attached any spreadsheet I will have to explain it a bit... Row #1 are the headers of each column Column A contains agents' names. However, a lot of the cells are blanks since this is how the cleaned up data I will be getting. For...
  17. M

    CopyPaste data from multiple excel files

    Hi Team, I need a macro to Copy and Paste (values) data from multiple excel files to Common Excel file. I have below files which need to get pasted in Main.xlsx file I have a New file called CopyPaste where I will update the file names and range details of copy and paste as below...
  18. N

    If and then or similar

    I have a workbook that has 400+ business names with 20 to 30 products each, I really need to add business names to another column, Column a (business name) Column b(product name) Column c (hopefully business address) Am I stuck with copy and paste?
  19. R

    Separating multiple email addresses and names in Excel

    Hi, I need help with an Excel sheet. I have a list of users names and email addresses along with other data columns. Some of the Name and email cells contain multiple names and corresponing email address. I want to have these moved to their own row with all the other row/column data duplicated...
  20. K

    get all sheet names starting with a specific letter

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top