names

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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.
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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?
  17. 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...
  18. 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...
  19. Q

    Reference Multiple Sheet Names on one sheet

    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...
  20. M

    Rename table headings using Names in another column.

    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?

Some videos you may like

This Week's Hot Topics

Top