Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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





Reply
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 12:57 PM
Textbox.caption to cell if empty, how? WTG Excel Discussion (Misc queries) 2 February 27th 05 05:03 AM
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 02:01 PM
Display a dialog box if cell is empty jst Excel Discussion (Misc queries) 2 December 28th 04 12:59 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 03:07 AM.

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"