address

Can anybody explain why this happens? With the third case I expect the result to be $A$12 $B$13 not $A$12 $A$13 Sub Sel() Debug.Print "C:" & Selection.Count Debug.Print Selection(1).Address Debug.Print Selection(2).Address Debug.Print "---" End Sub The grey areas are the cells...

I am trying to get my table to look like table 2. Any help would be appreciated. <tbody> Name Address Insured Address Policy Policy2 John Doe 123 ABC ST 123 ABC ST 8888A John Doe 123 ABC ST 123 ABC ST 9999B MIKE A 345 CCC ST 345 CCC ST 5555C MIKE A 345 CCC ST 345 CCC ST...

Hi, I’m trying to find the address of the First Five Row numbers in a given column where continuously the cell values are >= X. There can be multiple instance where we can find continuous rows where cell values are >=X, but I need the first occurrence only. For example in column A...

Hi everyone! I used a concatenate formula to combine a set of address columns into a full address column. My only issue is that the spaces were not added between words. Can you help me do this? Currently all the addresses look like this: <tbody> 000 Peach StreetDentonTX76209 How can I...

Hello, Please could any help on a vlookup issue? i have the following lookup =HYPERLINK(IF(IFERROR(VLOOKUP($C$29,Supplier,11,FALSE),"")=0,"",IFERROR(VLOOKUP($C$29,Supplier,11,FALSE),""))) I have a invoice and when i populate the suppliers details i would like to have a hyperlink to their...

I wonder if there is a way to extract a website address from within a text. noting that : 1- text field contains mix of email addresses and website address 2- email address can be before the website address or after it 3-some cells contain more than a mail address and a website address 4- there...

Hi Team. Bit hard to describe here, but what I am doing is adding an address from a list onto a datasheet, using a userform,(oddly enough called "SearchUF"). So the code adds the new address in Col B using xlup and the remainder of that row is populated using a series of formulas. Which works...

I have an excel workbook with multiple tabs. I am looking to send each tab to a different email address. The individual email address will be located in the same cell on each tab. Is there a VBA code that will perform this task?

Hi I've downloaded some data which comprises of business name, address and post/zip code. The data has arrived in a single column but I now need to sort so that I can effectively swivel the company data 90 degrees so each business lists across a row. Not all of the data is consistent as some...

I am trying to create a tool that will allow you to paste a column of IP addresses and have each address searched for in a range of IP addresses. For each address found in a range then Excel returns "yes", otherwise "no" The table below is a sample of the pasted addresses (column F) To the...

Dear Team, i am new in VBA using macro by record macro only. Kindly help to correct the below mention VBA code. I want to select a cell in sheet1 based on the cell value in sheet2(cell E3). E3 contain the Cell address of required cell selection. like in below macro address is "A10". but it...

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

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

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

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

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

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

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

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.

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