Alphacsulb
Active Member
- Joined
- Mar 20, 2008
- Messages
- 414
Ive searched and searched to try and find what I am looking for but I can't find it.
This is what I am trying to do.
Search Column AV for "CALCA"
Then look at Column AL in that row for data.
If there is data in that cell then do nothing.
If there is no data in that cell then do the following:
[IM GOING TO USE ROW 1 FOR EXAMPLE]
Cell AL1=K1&" "&L1&" "&M1&" "&N1&" "&O1&" "&Q1&" "&R1
Cell AM1=S1
Cell AN=T1
Cell AO1=U1
Hope that is not too complicated.
My goal with this macro is the following, CALCA is a type of customer. Look to see if they have mailing address if they do then do nothing. If they dont then put the residence address as their mailing address.
This is what I am trying to do.
Search Column AV for "CALCA"
Then look at Column AL in that row for data.
If there is data in that cell then do nothing.
If there is no data in that cell then do the following:
[IM GOING TO USE ROW 1 FOR EXAMPLE]
Cell AL1=K1&" "&L1&" "&M1&" "&N1&" "&O1&" "&Q1&" "&R1
Cell AM1=S1
Cell AN=T1
Cell AO1=U1
Hope that is not too complicated.
My goal with this macro is the following, CALCA is a type of customer. Look to see if they have mailing address if they do then do nothing. If they dont then put the residence address as their mailing address.