Tranpose Mulltiple Contacts From One Row
Apr 21, 2009
I would like to ask about How to Tranpose mulltiple contacts from one row.
Example:
Company1Firstname Lastname1 Firstname Lastname2 Firstname Lastname3Title1 Title2 Title3Company2Firstname Lastname1 Firstname Lastname2 Firstname Lastname3Title1 Title2 Title3
result need to be.
Company1Firstname1Lastname1Title1Company1Firstname2Lastname2Title2Company1Firstname3Lastname3Title3Company2Firstname1Lastname1Title1Company2Firstname2Lastname2Title2Company2Firstname3Lastname3Title3
View 9 Replies
ADVERTISEMENT
Jul 27, 2006
i have a sheet of database which is aligned from left to right (row). now i want to "tranpose" it from up to down. how can i do it?
View 4 Replies
View Related
Aug 15, 2006
I need write a macro that will take rows of data and put them in column form where the first column stays the same. The input to the macro is a single row. The output will vary depending on the columns in the input row. Here is a sample of the data and the needed output.
Input:
0044502232 000445022322 500445022327 600445022324 700445022321 800445022328
Output:
0044502232000445022322
0044502232500445022327
0044502232600445022324
0044502232700445022321
0044502232800445022328
View 7 Replies
View Related
Jun 25, 2008
I have an extract file that is in excel and lists contract numbers with a payment amount to the right. Each contract has multiple payments by period and thus there are multiple rows for each contract representing the multiple periods. The number of periods for each contract varies. The extract file contains multiple contracts. What I would like to do is have the contract number listed in one row and copy, paste, transpose the payments to the right of the contract number. The resulting file or sheet will have only one row per contract. The issue is that the code will have to recognize when the file number changes. I know I can do this manually but with 10 files and over 450 contracts this is a bit time consuming. Attached is a sample file with two tabs titled "Extract File" and "Desired Format". Extract File - is a sample of the main file that contains the data. Desired Format - is a sample of what I would like the final result to be. It can be in another sheet or another file.
View 3 Replies
View Related
Jun 17, 2013
Imported contacts to appear in Autocomplete?
View 1 Replies
View Related
Aug 29, 2013
I have a workbook with a list of new contacts in one sheet, and a list of old contacts on another sheet.
I want to run a duplicate check throughout the workbook to highlight and delete any contacts on my new list, that have already been contacted on my old list.
Also, I need the the duplicate checker to check for non specific names, regardless of punctuation, upper/lower case, etc.
I need to to highlight all of the following variations as possible duplicates which i can then review & delete manually;
Apple Corp,
Apple Ltd
APPLE LTD
Apple.com
etc...
What I can use to do this?
View 3 Replies
View Related
Oct 17, 2013
I am trying to merge my boss's contacts. He has one enormous set of contacts in GMail (5000+) and one enormous set of contacts in Excel (5000+) I've exported both sets into excel but how to I merge them?
The headers for each set are in a slightly different order (Home Address, Office Address, Email ...vs.....Office Address, Home Address, Email) Do I need to make sure the order of the headers match in both the GMail Sheet and the Outlook Sheet and is there a faster way to do that than just rearranging them manually?
My second question is how do I merge them? There are a lot of over-laps of people but some info might be different in Outlook than in GMail. For example I might have John Smith as a contact in both Gmail and Outlook but two different email addresses for him under the header "Email 1" how do I make sure one email doesn't eliminate the other? I just want to merge both sets of contact info for each person into one super contact.
View 4 Replies
View Related
Sep 23, 2009
Client Id Contact No. Unique Contacts 111123 12 3 111123 12 3 221123 2 2 111123 34 3 111123 5 3 221123 1 2 821123 4 1 221123 2 2
I am trying to calculate the number of unique contacts that each client has made. So in the example above Client No. 111123 has made 3 unique contacts - numbers 12,34 and 5.
However I'm not having any luck - as I suspect it will be a fiendish array formulae. Alternatively I'd settle for some VBA.
View 9 Replies
View Related
Jun 5, 2007
I have been trying to use VB to send contacts from contacts.xls to outlook. I have some code from MSDN that shows me how to put in ONE contact (which is already declared in the code). Well I was thinking of writing something to take a worksheet that has x number of contacts and automating x number of contacts. The problem is, I am familiar with using SQL to pull records, but I was thinking there was something easier like importing the excel namespace. So I decided to try it out this way and found this little tidbit of code which is:
Dim xlApp As New Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
xlApp = New Excel.Application
xlApp.Visible = False
xlBook = xlApp.Workbooks.Open("contacts.xls")
xlSheet = xlBook.Worksheets(1)
'READ FILE HERE
Dim pXLRange As Object
pXLRange = xlSheet.UsedRange
Dim i = 0
Dim j = 0
For i = 1 To UBound(pXLRange, 1)
For j = 1 To UBound(pXLRange, 2)
Debug.Print(pXLRange(i, j))
Next
Next
It gives me this error for the FOR i=1 to UBound line:
Unable to cast COM object of type 'System.__ComObject' to class type 'System. Array'. Instances of types that represent COM components cannot be cast to types that do not represent COM components; however they can be cast to interfaces as long as the underlying COM component supports QueryInterface calls for the IID of the interface.
here's the namespaces i have imported:
Imports Outlook = Microsoft.Office.Interop.Outlook
Imports System.Reflection
Imports System.Data.OleDb
Imports Excel = Microsoft.Office.Interop.Excel
View 5 Replies
View Related
Dec 20, 2012
i have a excel sheet which i use to estimate of course i have many contractors i use
my question is, is it possible to create a drop down menu with the contractors name and autofill the cells below with the address
Cell_B5 Company (Dropdown)
Cell_B6 111 Street Rd
Cell_B7 TownCity State 11111
or is it without a dropdown possible by just typing the first few letters and then autofill and how to do this
View 3 Replies
View Related
May 17, 2013
Wanted to know can I transfer excel sheet to outlook pst?? If yes then how can I do so??? As I have lots of contacts list in Excel sheet but now I wanted to import those contacts to Outlook.
View 2 Replies
View Related
May 15, 2007
How do i go about importing contacts - names, numbers, addresses that are in excel into Microsoft Outlook?
View 2 Replies
View Related
May 13, 2014
Work on a spreadsheet with multiple sheets , that will then be emailed once a month, with different sheets going to different contacts because of our timezone difference.
If a sheet could be used to maintain a list of contacts and which sheet to email out Also in which format PDF, Excel (locked down) or both would be useful.
A button maybe on the contact sheet to start the process / but also with an option to set-up to email on a certain day per month would be good.
the number of contacts at the moment varies between 1 and 4 for each sheet - perhaps , we could set-up to email up to 10 contacts per sheet
The email client is Outlook
Each contact should only receive their sheet and not see any of the other sheets , also the contacts should not be able to alter the spreadsheet at all. hence the possibility of using PDF , but most still would like to see the report in excel format.
there would be about 20 sheets , to go to between 1 and 10 contacts for each sheet
I have attached a dummy workbook , which has 4 example worksheets in
In the real workbook, the worksheet names , also will have spaces in them.
I could setup a Start Sheet and a finish sheet - so that the macro - can go through each worksheet in between , if that offers a solution also a maintenance sheet which has the sheet name , email contacts email address and PDF, Excel or both format.
I have outlook on my PC , so i can play - BUT its not connected via exchange server, if that makes any difference.
View 2 Replies
View Related
Mar 14, 2014
How to get the outlook contacts for the organization using excel macro vba.
View 14 Replies
View Related
Jul 15, 2007
I have 2 books right now. Each book has 2 colums of data (See attached jpg.):
Book 1 has a column for "phone number" and another for "street"
Book 2 has a column for "phone number" and another for "house number"
I would like to merge these books together so that all the information I have about these contacts is in the same book. Column A will be the phone numbers, column B will be the street name, and column C will be the house number. As you can see by looking at book 2, I only have house numbers for some of the phone numbers in book 1. My goal here is to have book 2 "look at" book 1, and add any information book 1 does not have (such as house number) to the relevant row (the row where the phone numbers match). This new book will by my book 3. I've attached a jpg. with how book 1 looks, book 2 looks, and how I want book 3 to look.
View 2 Replies
View Related
May 2, 2014
I have come up the code below. It imports contact information from Outlook contacts in a contact folder called Private Contacts. The below code has been copied and modified from this forum.
As it stands the macro creates a new workbook and places the data on that. What I need it to do is create a new worksheet with the name of private compare on the active workbook and then place the data on that worksheet.
[Code] .....
View 6 Replies
View Related