View Single Post
  #1   Report Post  
Hopeful Exel User
 
Posts: n/a
Default Is there a way to go to next empty cell in a formula

I have a workbook that the first sheet is called "Login Sheet". On this
sheet we login the incoming country clubs that are going to run that day.
See example of sheet:

TODAY()

0000 1125 2250 3000 4000 5000 6000 7000 8000 9000

The sheets that are after this are sheets for each country club.

What I want to do is if the club is listed on the "Login Sheet", I want the
date to move into the next empty field of the corresponding worksheet.

Example of corresponding worksheet:

Date Received Date Returned
04/11/05

Each time that country club is logged into the front sheet we want a new
date in the next empty cell.

Example
Date Received Date Returned
04/11/05
05/24/05

The formulas I use will work correctly on the first cell, but when I go to
next empty cell the previous cell is returned with a "false" statement.

Please Help.

Thanks