address

Hi, I have column with Names, (unique) ID, and Address. The problem is some addresses have their street address in one row and the row below it is their city, state and zip. I would like to have their street address, city, state, and zip in concatenated in on line based on their ID. For...

Hi All, Im trying to get outlook global email address and userId in to my workbook What is the best way to achieve this Please can you help me Many many many thanks

I would like a formula to extraxt the first and last name from an email address and as well as for the first and last name to start with upper case for e.g email address patrick.davids@syke.pl.com this should appear as Patrick Davids using a formula your assistance in this regard is most...

I have over 900 individual invoices created by excel, all are stored in a directory d:\invoices and are named Inv10001.xlsx to inv100909.xlsx I have a new spreadsheet called Address Book with one sheet called Address list. I want a macro or a vba code to open each of the invoice files and copy...

Hi I have lets say 5 cells. The first one has an email address in hyperlink format (blue underlined). How can I select these cells (highlight them). when I click on the first one it will open the email address. It wont allow me to select cell A1. So I went to A5 first, selected it then drag the...

Hi I want to ask user to enter address for example 100 main street, and then my code will split the number and street name. I tried the following but got error message. I am thinking of array must be use or do you think there is easier way to do that thank you very much Sub myfirst() Dim...

Hi I wrote a code to ask user to enter first and last name and then the code will msgbox fullname. Now I want to improve the code. I want to msgbox the first letter for the first name then last name. So later I can msgbox the email address. For example, if user enter John Smith I want to...

I want to build a hyperlink or a macro which when clicked on will open an new Outlook email with a copy of the file and the email address automatically populated. Is this possible? Ian

Hi All , and thankyou in advance for looking at this problem. I am adding 2 cells together for an email address , first name , last name with a . inbetween , then the email address ;EG STEVE SMITH , it should read as steve.smith@blah.com. However only on a few occasions there appears a space in...

Can anyone help with this please? I want to extract the MAC address (used for IP) then store this value after Excel is closed down. On reopening I'd like to check that the previously stored MAC address = the current MAC address. Ideally I'd like this to work in an Add-In xlam rather than an...

cell address of a particular text or value, which is in 2nd or 3rd column, (or in any column) A B C D E 1 2 Rose 3 5132 4...

I have a table Column A, Column B, Column C Row1 2 Red Apple Row2 5 Green Mango Row3 2 Yellow Banana Selected row3 with duplicate in Column A = value 2. I need a code or function to find...

Hi dear forum members, Is there a formula that would take a cell address and return the corresponding cell reference so I can then use this reference as an argument in other fonctions such as INDEX etc... ? Looking for a Non-UDF solution. Regards.

<tbody> Number Fill Address 1026 902 E. Fremont 902 E. Fremont 1063 871 Main Street 829 Main </tbody> 1263 Hello All, I need help. I'm looking for statement that will help me fill the middle Column. For Example, If the address ha a row number then fill it with the...

Dear Expert, I need an help from you. I need a VBA code from you for the below scenario. Currently I am doing it manually and i want to automate it. Current Scenario: I am from invoicing Team and i Generate multiple invoices for the day. I store all these Invoices in PDF mode and save it under...

I have created a userform that asks for an email address. Does anybody have some code that would verify the email address has the correct format (I don't need to verify the address actually exists). Thanks so much !! The web is just getting me lost and confused.

I am trying to compare an address on sheet A with an address on sheet B and if they match put data from column E on sheet 2 into column H on sheet 1. Here is the formula I have that is not working. =VLOOKUP(F2,ActiveCustomerListing!$D$2:$E$36000,3,0) Column F on sheet 1 is an address Column D...

Looking to extract the City from an address (which can be more than one or two words (ex: Winter Garden or Miami). The format I have is as follows: Address [space] City [comma] State Abbv [Space] Zip examples below: 6615 Mahan Dr Tallahassee, FL 32308 3838 S Dale Mabry Hwy Tampa, FL 33611 999 E...

Hello All, So I have office locations in sheet 1 as follows: <tbody> Location Address City State Zipcode Chicago 243 W Jackson Chicago IL 60605 New York 505 W 50th St New York NY 10019 Los Angeles 20 Calabasas Road Los Angeles CA 98490 </tbody> Now I m looking to auto populate data...

I have a spreadsheet with some data and addresses. I am wanting to do a formula where if sheet1 b2 (address) = sheet 2 b2 through b45 address then sheet 1 a2 = displays sheet 2 a2. If that makes any sense at all sheet 1 A2 123 FAKE ST sheet 2 B2 123 FAKE ST B15 123 FAKE ST sheet 1 A1 FAKE_123