contact

I've been really frustrated trying to look up (oh god no pun intended) how to do this. I'm trying to do something so simple to understand but I'm having such a hard time trying to get Excel to understand what I want. Basically, I have 2 excel sheets. What I need to do is fill a contact list of...

Hey guys, I have two data sets that I want to combine. Data is currently on two different worksheets. Below is an example of what I am trying to do, but my actual data has more columns for both Opportunity and Contacts. I also have many more rows. <colgroup><col style="text-align...

I have at the moment a list in Column A; Unit number 124 Company Name What it does web address contact Unit number 127 Company Name What it does web address contact Unit number 145 Company Name What it does web address contact and want... Column 1 Column 2...

Hey guys, I have a long list of contact names and addresses, none of which have a unique identifier. I need a way to pull the contact name and address info from the list, and paste it into a new tab so that I can have all of the contact names listed as column headers. an example of two...

Hi, I've done this formula but it's returning an incorrect answer, any ideas what's wrong with it. Column E in contacts is the contact date and time in this format 13/11/2017 12:10 Column F is the contact type and is text Cell A9 is contact type and is text...

<tbody> A B C D E F G First Name Last Name Role Start Up Contact Unique + "Invested" <-- + "Acme Corp" George Aquino Invested Initech Justin Abad George Aquino ??? George Aquino Invested Acme Corporation Shaun Jai Femi Folami Alban Dushku Founded Massive Dynamic Sean Baako James Jones...

I know only enough excel to be dangerous these days, and need to sort one column of contact information into separate columns. Business, Contact Name, Title, Address1, Address2, City, State, Zip, Business Phone, Email, etc. This is what it looks like now. Text was extracted from a word...

Hi, I hope someone might be able to help me. I have a sheets named "Contact Details" and multiple sheets named "*** Patients" (Where *** could be any word or words). I need "Contact Details" to consolidate the data from the other sheets into one sheet based on the following criteria: IF sheet...

I'm working on a mail merge from excel. On some pages, the data comes over and is mostly spaced evenly but on other pages is spaced all over. Is there a way to get all the spacing to be consistent on each page so it doesn't look so sloppy? I've tried to put the merge fields into a table, but...

I am wanting to segment a contact list by creating a Segmented list name Column. I would like to segment the list by every 2000 contacts per state. I was thinking of having the column name be TX -1, TX -2, etc. for every 2000 contacts. But once a new state is presented then it should start back...

Hi, I have following problem: In the attached workbook I have a sheet where I need the answer "yes" or "no" in cell J based on the information in cell I. "Yes" if one of the cells in I does not have Frankfurt in it. The question is if a firm contact is known in another office than Frankfurt...

Hi Guys, I have a large set of data (12,000 Lines) that is a directory of contact information for around 5,000 business. I need to extract all of that contact data from separate excel list of around 500 companies. Is there a way to filter on the "company name" column for all 500 companies on...

<tbody> Table from Task sheet A B C D E F G H W X Y Z AA AB AC AD AE AH 2 ID Project Name Task ID Task Description Task Type Start Date End Date # of Days Resource 1 Resource 1 Contact Resource 2 Resource 2 Contact Resource 3 Resource 3 Contact...

I'm struggling to come up with a formula to do this. Can anyone help? OLD SHEET: B9: Contact 1 B10: Contact 2 B11: Contact 3 NEW SHEET: C5:9 are merged and I need B9 to populate from the old sheet C10:14 are merged and I need B10 to populate from the old sheet C15:19 are merged and I need...

I have some merged cells , namely C4 and D4. I am trying to run some code to check if the range (c4:D4) is empty and if so to have the msgbox popup and the macro end. It works fine but it continues to keep showing the Msgbox even after I have entered a contact name into the merged cells. I can...

Hi, I have data on seven worksheets, examples below: <colgroup><col><col><col span="2"></colgroup><tbody> Worksheet 1 Name Contact number Quantity Company Richard 1234 10000 Amazon Mike 2345 5000 Amazon Michael 5678 3000 Amazon Nancy 4567 5000 Amazon Alpha 6789 8000 Amazon Bravo...

Hello All, Really need some help! Assume Column A is an Account name and Column B is an email address. Basically, I want something that analyses the email address and compares it to the name of the account in Column A. If the email address contains any word from the Account name in Column A...

Hi, I am looking for formula that can split contact name properly. I have 1,000+ Contact names like below.. Jennifer Monroe Monroe, Jennifer Ali Talai Talai, Ali Kim Millman Millman, Kim Stephen E Wood Wood, Stephen E In above example person name is repeated 2 times with ",". Now I want...

Hi, I need to see the list of companies and associated details when I select a state. Please check the table I have and the desired list. List I have: <colgroup><col><col><col span="2"><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> s1 s2 s3 s4 s5 s6 s7 s8 s9 s10 name...

I have a table that contains the following fields Buyer Contact Date Contact Channel Contact Details I want to return records via VBA code where the Contact Date is < 30 days ago and to only return the latest record (max Contact Date) for the Buyer. I am struggling with the query string and...