ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Is there a way to go to next empty cell in a formula (https://www.excelbanter.com/excel-worksheet-functions/22728-there-way-go-next-empty-cell-formula.html)

Hopeful Exel User

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







All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com