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
|