find the first blank cell in a range and return me it's position
Hi,
in my invoice sheet I want to look up on the sales sheet
the first blank cell in a range (c10:c500) and return me
the cell adjacent to the right of it i.e
the formual finds c20 is the first blank cell and it
returns me the cell to the right, the next invoice number
avaiable, 121
anyone any ideas how to achieve this please
thanks
steve
|