Paste data from specified cells to another when just typing comp [Closed]

Report
-
 Blocked Profile -
Hello,
Hello,
I am trying to use macros to copy data from several cells into different cells in another sheet. My data is consisting of Organization contact details. So i want to write only organization name in the specified cell thin all other details past into each different specific cell. For Example:
Organization name is x
P.O. Box 77777
Tripoli, 67890
Email: xxxxxxx@hhhhhh
Tel: 123456789
I want when typing as example organization name x in cell number B11 need to past PO box to cell B22, city in cell B14, email in cell k7, Tel Nr in cell j14 and so on.
all this data to appear automatically in specified cells.

note: I have about 30 organization's details in table in on other page in same spread sheet.
Regards
Maher



1 reply


So what part are you stuck with? We can help where you are stuck, but we cannot deploy a turn key solution for you!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!