New_Here
04-21-2017, 12:11 PM
Hi Good Evening (http://www.vbaexpress.com/forum/#) from Sri Lanka (http://www.vbaexpress.com/forum/#),
Please help if possible.
The below WAS my requirement and the solution to it is Below,
Data I had :-
Cell A1 = Phone (http://www.vbaexpress.com/forum/#): 81-74568943 (http://www.vbaexpress.com/forum/#) Fax: -
Cell A2 = Phone (http://www.vbaexpress.com/forum/#): 51-83-9498756 (http://www.vbaexpress.com/forum/#), 5583772359 (http://www.vbaexpress.com/forum/#) Fax: 61-88-4932516 (http://www.vbaexpress.com/forum/#)
Cell A3 = Phone (http://www.vbaexpress.com/forum/#): 51-6785239556 (http://www.vbaexpress.com/forum/#), Fax: 31-13-45225335 (http://www.vbaexpress.com/forum/#)
Cell A4 = Phone (http://www.vbaexpress.com/forum/#): 51-6785239556 (http://www.vbaexpress.com/forum/#), Fax: 31-13-45225335 (http://www.vbaexpress.com/forum/#), Mobile (http://www.vbaexpress.com/forum/#): -
Outcome :-
B1 = Phone (http://www.vbaexpress.com/forum/#)
C1 = 81-74568943 (http://www.vbaexpress.com/forum/#)
D1 = Fax
E1 = - (Or N/A - Not the N/A Error (http://www.vbaexpress.com/forum/#)Message (http://www.vbaexpress.com/forum/#) or a value! error (http://www.vbaexpress.com/forum/#)message (http://www.vbaexpress.com/forum/#), But just the letters (http://www.vbaexpress.com/forum/#) : N/A)
F1 = Mobile (http://www.vbaexpress.com/forum/#)
G1 = - (Or N/A - Not the N/A Error (http://www.vbaexpress.com/forum/#)Message (http://www.vbaexpress.com/forum/#) or a value! error (http://www.vbaexpress.com/forum/#)message (http://www.vbaexpress.com/forum/#), But just the letters (http://www.vbaexpress.com/forum/#) : N/A)
The Formula to get it done is below,
http://www.vbaexpress.com/forum/showthread.php?59246-To-Pull-out-Certain-Set-of-Data-from-a-Cell-Urgent&p=360078#post360078
How should I remodel the above in
My Issue;
A1=Contact (http://www.vbaexpress.com/forum/#) Person: James Anderson Designation: Proprietor
A2=Contact (http://www.vbaexpress.com/forum/#) Person: Gordan Designation: Seller
A3=Contact (http://www.vbaexpress.com/forum/#) Person: David Cameron Miller Designation: Vice President
Solution I require:
to
B1=Contact (http://www.vbaexpress.com/forum/#) Person
C1=James Anderson
D1=Designation
E1=Proprietor
B2=Contact (http://www.vbaexpress.com/forum/#) Person
C2=Gordan
D2=Designation
E2=Seller
B3=Contact (http://www.vbaexpress.com/forum/#) Person
C3=David Cameron Miller
D3=Designation
E3=Vice President
?
Please Help !!!
Please help if possible.
The below WAS my requirement and the solution to it is Below,
Data I had :-
Cell A1 = Phone (http://www.vbaexpress.com/forum/#): 81-74568943 (http://www.vbaexpress.com/forum/#) Fax: -
Cell A2 = Phone (http://www.vbaexpress.com/forum/#): 51-83-9498756 (http://www.vbaexpress.com/forum/#), 5583772359 (http://www.vbaexpress.com/forum/#) Fax: 61-88-4932516 (http://www.vbaexpress.com/forum/#)
Cell A3 = Phone (http://www.vbaexpress.com/forum/#): 51-6785239556 (http://www.vbaexpress.com/forum/#), Fax: 31-13-45225335 (http://www.vbaexpress.com/forum/#)
Cell A4 = Phone (http://www.vbaexpress.com/forum/#): 51-6785239556 (http://www.vbaexpress.com/forum/#), Fax: 31-13-45225335 (http://www.vbaexpress.com/forum/#), Mobile (http://www.vbaexpress.com/forum/#): -
Outcome :-
B1 = Phone (http://www.vbaexpress.com/forum/#)
C1 = 81-74568943 (http://www.vbaexpress.com/forum/#)
D1 = Fax
E1 = - (Or N/A - Not the N/A Error (http://www.vbaexpress.com/forum/#)Message (http://www.vbaexpress.com/forum/#) or a value! error (http://www.vbaexpress.com/forum/#)message (http://www.vbaexpress.com/forum/#), But just the letters (http://www.vbaexpress.com/forum/#) : N/A)
F1 = Mobile (http://www.vbaexpress.com/forum/#)
G1 = - (Or N/A - Not the N/A Error (http://www.vbaexpress.com/forum/#)Message (http://www.vbaexpress.com/forum/#) or a value! error (http://www.vbaexpress.com/forum/#)message (http://www.vbaexpress.com/forum/#), But just the letters (http://www.vbaexpress.com/forum/#) : N/A)
The Formula to get it done is below,
http://www.vbaexpress.com/forum/showthread.php?59246-To-Pull-out-Certain-Set-of-Data-from-a-Cell-Urgent&p=360078#post360078
How should I remodel the above in
My Issue;
A1=Contact (http://www.vbaexpress.com/forum/#) Person: James Anderson Designation: Proprietor
A2=Contact (http://www.vbaexpress.com/forum/#) Person: Gordan Designation: Seller
A3=Contact (http://www.vbaexpress.com/forum/#) Person: David Cameron Miller Designation: Vice President
Solution I require:
to
B1=Contact (http://www.vbaexpress.com/forum/#) Person
C1=James Anderson
D1=Designation
E1=Proprietor
B2=Contact (http://www.vbaexpress.com/forum/#) Person
C2=Gordan
D2=Designation
E2=Seller
B3=Contact (http://www.vbaexpress.com/forum/#) Person
C3=David Cameron Miller
D3=Designation
E3=Vice President
?
Please Help !!!