LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 25
Default Finding Next Blank Cell in Blank Row

Using Excel 2007 - I have a workbook with two worksheets. The front sheet
has a list of headers along the top such as date and then some data that is
going to be filled in down the columns. The second sheet is the work-out
sheet with the formulas that is going to work out the figures to go into the
first sheet. However, what I want to do to make it simple for the people
using the sheet, is to have one simple line of formulae that they type into
each week and the solutions to those formulae are then placed in the first
sheet but in the next available cell going down the rows. i.e. this week the
solutions would go into Row 3 Columns A, B, C, D; next week they would go
into Row 4 Columns A, B, C, D - all this without them having to do anything
other than type in the data on the second sheet. I know all about the
Worksheet! formula, etc but it is the looking for the next blank row
business that puzzles me.

Is this possible?

Nick


 
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
Average Formula to display blank cell if named range is blank Rachael F Excel Worksheet Functions 3 February 22nd 08 05:05 PM
finding last non-blank cell and then copying it to the next cell mike_vr Excel Discussion (Misc queries) 0 January 17th 08 05:02 PM
Finding next non-blank cell Stu[_2_] Excel Discussion (Misc queries) 4 October 23rd 07 01:29 PM
Finding the bottom non-blank cell in a range Fenneth Excel Discussion (Misc queries) 7 July 6th 06 06:05 PM
finding blank cell and moving specific data into it BeJay Excel Worksheet Functions 1 May 30th 06 07:06 PM


All times are GMT +1. The time now is 03:49 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"