bluebird1927
New Member
- Joined
- Aug 17, 2007
- Messages
- 1
Hi, i'm trying to find and replace all blanks in column B based on the value in column A. When it replaces the blank it will be a few letters and a number that increments e.g AN1 AN2 AN3 etc
When Column A is blank the code stops.
when
For example
______A____ B
1 ___text1 textA - fine move to next row
2 ___text2 textB - fine move to next row
3 ___text3 ( ) - replace this blank with AN1
4 ___text4 ( ) - replace this blank with AN2 and so on
5 ___( ) - when Column A is blank, code stops.
I have tried a few things but cannot get it to loop correctly.
Please help
Mike
When Column A is blank the code stops.
when
For example
______A____ B
1 ___text1 textA - fine move to next row
2 ___text2 textB - fine move to next row
3 ___text3 ( ) - replace this blank with AN1
4 ___text4 ( ) - replace this blank with AN2 and so on
5 ___( ) - when Column A is blank, code stops.
I have tried a few things but cannot get it to loop correctly.
Please help
Mike