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
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.
Paste data from specified cells to another when just typing comp