Hi,
I have a table which contain the clients name and on the next row it has the further details, basically I would like to fill the empty cells with the cell value (field "Client") above until a new cell value is found so it will look like:
North Bay
North Bay
North Bay
North Bay
North Bay...
I would like to know how I make VB read a table, find a specific text and look into the coloum next to it to see if the number is positive or negative.
Thanks