contact

Hi All, I have an extract in csv format that I want to import into a database to be able to use it with other data sources. In the file I have 3 columns: Company Ref, Company Name, Contact email If we have 3 contacts for a supplier then there will be 3 lines e.g. AAA001,xyz,john@xyz.com...

I know there are great plug-ins for Fuzzy Lookups on Windows machines but I work in a Mac office. I have 3 cols of data: Col A = My accounts Col B = Each account's point of contact Col C = Attendee list I want to know if an account I own in col A is in the attendee list in col C but there...

Probably not the best title to get the point across but now that you are here...: Have a spreadsheet with rows of company names and multiple contacts per company. The company name data is only in the row of the first contact for the company. The subsequent company name rows are blank until the...

Hello, I am trying to get this nested IF formula to work, however it keeps returning FALSE. Any help appreciated. =IF(D3="Monthly",IF(COUNTA(E3)<1,"Action Required",IF(D3="Hub Contact",IF(COUNTA(E3)>1,"Action Required",IF(D3="Bi-Monthly",IF(COUNTA(E3)<>E3/B1,"Action Required","No Action"))))))...

I am working on a form where if B14 is populated with a Person's Name C22 populates their contact info... (which is easily done) However, I am looking to have if B14 is blank (no name populated) but B20 has a name the same C22 populates the same contact info... Is there a formula or work around...

Hello, I'm trying to create a formula for column C in the examples below. Column B is static, it never changes. I included it in case there's a clever way to use it that I'm not seeing. Column A is input by the user. I've been at it for a while and can't find a solution. Basically I want...

Hello I have a gym and i want to create a worksheet that reminds me when i should contact a member to upgrade is training plan. This is the workbook: The ideia is that i insert the delivery date and then it gives me automaticly the 1º contact, 2 contact, 3 contact and 4 contact, each one...

Dear all, I am new to Excel VBA. Been trying to deal with the following problem for days but could not figure out a solution. I want to enter data for individuals. Each individual has data that are "static" e.g. ID, age, gender and data that "varies" e.g. addresses and contact numbers I...

Hi everyone, I created an application whereby the user is required to communicate data via email to specific users. The current methodology requires the user to fill up a table with the intended destinations and then Excel takes over and generates the appropriate emails. I was about to create...

<tbody> SNO NAME CONTACT 1 PUBLIC SCHOOL 1 9855666 930000 2 PUB SCHOOL 2 82899633 </tbody>

I have a task that I can’t figure out how to achieve. I have 2 workbooks. One contains a list of "Selected" customers in Col A The other contains a "Dump" of all customers with all contact names and details. Again Col A contains names and subsequent Cols contact names and details. What I would...

Hi Everyone, I am trying to find a solution for the below. I have 2 separate spreadsheets that users fill in however, that populate a another workbook. For example the user on form 1 enters their Surname and DOB. On the second Form they then enter their Surname, address and contact number...

I'm tinkering with this in an attempt to merge all pdf files in a folder into 1; Sub MergePDF() 'Relies on the Adobe Acrobat 6.0 Type Library Dim objCAcroPDDocDestination As Acrobat.CAcroPDDoc Dim objCAcroPDDocSource As Acrobat.CAcroPDDoc 'Initialize the objects Set objCAcroPDDocDestination =...

I have a spreadsheet with 4 columns: A - Child, B - Parent, C - Child contact, D - Parent contact Each Parent belongs to the same parent(this is needed for reasons unrelated to this issue) Each child belongs to a parent Each child can have none, 1, or multiple contacts. Each Parent can have...

I have a table such as this one. I have set up the formula =IF(B2="Yes",A2+182,"NA"),and so one, for the further cells. This is successfully giving me what I need, which is to take the cells in column B in which I have been provided a "Yes" for recontact, look back at the date of initial...

<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} Page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black...

Hi All, I work in a call centre environment where we log our calls/emails etc. When I run the stats, I have a column called 'Contact Type' and a column called 'Caller' (as well as 50 other columns). I need a formula to give me the total number of tickets where the Caller equals "Third Party"...