Team,
I need to fill a series of cells down when the CONCATENATE function is in the cell. I want it to keep the column refs and advance the row refs.
1st cell contains:
=CONCATENATE(CONCATENATE($C$4," ","(",$B$4,")"))
2nd cell:
=CONCATENATE(CONCATENATE($C$5," ","(",$B$5,")"))
so i want the next cell to read:
=CONCATENATE(CONCATENATE($C$6," ","(",$B$6,")"))
I'm kind-a low intermediate level hack.
the clock's ticking dude...
thanks in advance for any help.
db
Bookmarks