address

  1. D

    Excel/Word Mail Merge - Same Address...different names

    Not sure if more of an excel question or a Word Question but here is my issue. We use an EHR where the contact report that is exported has every contact separated into their own row in excel... for example: mom and dad, living in the same house, have separate entries in the form and are on...
  2. Sharid

    Cleaning up data from web in a cell

    Please could someone help. I have been doing this by hand, I'm hoping a vba code can do this I am pulling data from the web into a spreedsheet, I need a VBA code that will clean the data so it is formated better, see below I have several columns about 20 and to the last row with data in it...
  3. S

    Use FileDialog to copy a file address

    Morning All I am trying different methods of getting links to files into a Listbox. One method is to paste the file address into a Textbox and then transfer that over to the Listbox as a hyperlink (posted on this forum). The next method I want to explore, which I think may be a little cleaner...
  4. A

    multi sheet reference for 1 cell/Impossible??

    I have an excel doc with several worksheets 1 summary sheet The rest are all different addresses, the address in each sheet is in cell B2 I would like a formula in the summary sheet the give the address in cell B2 and be able to drag the formula down to give the addresses for each different...
  5. Sharid

    Sort data in rows and columns that is a mess

    I have a list of data, it come in a mess and it takes forever to sort out with filters. The data comes like this <tbody> A B C 10 %John ADD:1 My Address 10 #Jane 1 My Address 15 %bob% ADD: 1 My Address 5 #peter? ADD: 1 My Address 10 ADD: 11 My Address #Joe 10 #Jane ADDS: 11 My...
  6. D

    Get Name from Alias in Global Address List

    Hi Everyone, Im currently using the following method to obtain the Alias out of the user name, and works very fast and accurate. Public Function GetAliasFromName(sAddressEntry As String) As String With New Outlook.Application GetAliasFromName = .Session.AddressLists("Global...
  7. K

    Changes Subject Corresponding to Email Address

    Hi, I'm using Ron Debruin's AutoEmail Macro I've been using it for a while with a lot of success, and now I'm migrating it to another task. It works perfectly, but I want one additional piece to make my life easier. In the subject of the email, I want the value from Columns I. Now I know...
  8. books4cars

    Mark duplicate emails

    I have 2 columns and about 7000 rows. Column 1 is name, column 2 is email address. I want to ensure each email address is associated with only 1 name. Either by conditional formatting or otherwise. Much obliged.
  9. D

    Array Formula?

    Hi all, I think I need an Array formula, and I'm not competent with those. I have two documents I need to compare. Salesforce and KPHC. There are duplicate values In Salesforce: CustomerID - Column D Address - Column U In KPHC: Customer ID - Column L Address - Column E There ARE duplicates...
  10. synergy16

    splitting text after previous space

    good afternoon all. i have a vba program that populates text/list boxes on a form, based on a users request in the form. it reads off a excel sheet that has delivery information for fedex shipments. the cells that contain the delivery "street address" are giving me an issue because they...
  11. J

    adding spaces in front of text and "alt enter:" tabs in one cell (address)

    I have an address that is in one cell formatted with: Name address address2 city state zip There is a hard tab (alt tenter) between the lines after the first line. (the bolded lines) I need to keep everything in one cell, and add five spaces in front of each line. I need to be able to do this...
  12. D

    lookup address

    All, Trying to use lookup and address for the first time and think i am doing it wrong. SUMPRODUCT(--ISTEXT(address(7,LOOKUP(2,1/(G5:G15245<>""),ROW(G5:G15245))):LOOKUP(address(7(2,1/(G5:G15245<>""),ROW(G5:G15245)-300)))) So i have a ton of stuff in coulmn G I need to find the last value that...
  13. JenniferMurphy

    Passing range as range vs name of range

    I've run into a little speed bump in some code that is trying to access a named range of data using the name of that range, rather than the range itself. I know some will argue against doing that, but let's leave that aside for now. To illustrate the problem, I wrote the two little test UDFs...
  14. V

    VBA to check the value in all the files in directory

    Hi All, Looking for VBA code which helps in finding a value in list of files in the directory. It should fetch the filename, sheet name and address of the cell where the value holds. For instance if I want to search "December 2019" in directory which has files name say file1, file2, file3...
  15. T

    One Click Excel Information and send out thru Email

    Can you please help me with making this happen? 1.) Just to keep this simple...Here is the raw Data from Excel (These cells are formatted with boarder lines surrounding each cell) PO Date Po# Vendor Provide Tracking# Vendor Email 3/15/19 WZ-54244-P NISSAN tracey.noe@abc.com 2/12/19...
  16. T

    Easy question for those who know - data population into a template...for printing.

    HI Folks.....Just a regular Pool Service guy here....Looking to use Excel to maintain Route Sheets. I want to have one sheet that has a long list of customer names, address, and other things...and be able to populate a single template when I print them out. The template will have the names...
  17. T

    Lookup customer name on IE and return address using VBA

    Hi, I have a list of business names in Excel starting in cell A2 going down to A3, A4 etc. The record-set is pretty large as it contains over 100,000 rows. What I need to do is to retrieve the address for these business using IE and return the corresponding address in cell B2, B3 etc.. I'm...
  18. F

    textBox formatting

    Good Day I m trying to capture MAC Addresses on computer onto a user form. When capturing the NAC Address the cell is returning a value of True whereas I want the cell to display the MAC Address. My code is as follows: [CODEws.Cells(iRow, 40).Value = Me.TextBox77.Value =...
  19. M

    Adding Data From Multiple Cells to One Cell

    I don't know if there is a way to do this, but i suspect that someone may have had this need My column A represents "Complete Address" Column B is the "Number and Street" Column C is the "Dock" Column D is the "City" Column E is the "State" Column F is the "ZipCode" I am trying to make column...
  20. D

    Names and Address columns to rows?

    Hi Guys, Could someone help me work out the script or formula to index these columns and create new rows with the names in different columns? This data columns containing names address and address turns into address with rows of names -> <style type="text/css"><!--td {border: 1px solid...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top