Hi I have been trying to write a Macro for weeks but cant get everything I want to work, to work.
I want to be able to produce a new cell from the data attached :-
First of all I need excel to look at columns P,Q,V,W and see if it contains a number starting with a 7. Then I need it to add a 0 to the number as for some reason the report that produces this data takes off the leading zero. I then need it to combine the number with the following information into 1 cell. Then I can copy and paste these numbers into Outlook so we can send a text/sms message to our clients. I dont know if it is possible to export this data directly to Outlook?
A C D G NEW NUMBER
13006 Mr Peter Joseph <[email protected]>
For each row it could produce 4 new entries if there is a number starting with 7 in each column PQVW. The report can be any length but never more than 500 rows.
Many thanks if you can help me.
Bookmarks