Hi guys. Can you help me with a macro that will place data into specified columns so I can import it into a card file in MYOB.
Basically I paste a row of data into a worksheet but I need the macro to take this data and line it up in with certain columns as shown.
I enclose a file to demonstrate.
The data will always look like this but sometimes some of the cells may be blank eg we may only get one phone number instead of both or there may be no email. So if one of the cells is missing the macro should leave it blank.
I do not need the macro to import. I only need it to paste into the specified columns.
Thanks for your help
Mal
Basically I paste a row of data into a worksheet but I need the macro to take this data and line it up in with certain columns as shown.
I enclose a file to demonstrate.
The data will always look like this but sometimes some of the cells may be blank eg we may only get one phone number instead of both or there may be no email. So if one of the cells is missing the macro should leave it blank.
I do not need the macro to import. I only need it to paste into the specified columns.
Thanks for your help
Mal