![]() |
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