LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to look for empty cell esrei Excel Discussion (Misc queries) 1 April 14th 05 11:57 AM
Textbox.caption to cell if empty, how? WTG Excel Discussion (Misc queries) 2 February 27th 05 04:03 AM
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 01:01 PM
Display a dialog box if cell is empty jst Excel Discussion (Misc queries) 2 December 28th 04 11:59 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"