View Single Post
 
Old 07-04-2011, 12:44 AM
devcon devcon is offline Windows 7 Office 2010 (Version 14.0)
Novice
 
Join Date: Jul 2010
Posts: 3
devcon is on a distinguished road
Default If, move and concatenate in VBA

Good day,
Please need your help to solve the following problem.
I need to concatenate all cells in the column B if the column A is empty till to found the word “Offer”. Then from the cell with the word “Offer” to move the contents is the column C.
As it’s very difficult to explain in plain words what exactly I need to do, I’ve attached an example. I hope to be clear.
Thank you in advance.
Devcon
Attached Files
File Type: xls Example.xls (30.0 KB, 13 views)
Reply With Quote