Results 1 to 4 of 4

Formula to enter value in cell down if not empty

Threaded View

  1. 09-07-2015, 03:23 PM #1
    bjnockle
    bjnockle is offline
    Forum Contributor
    Join Date
    02-06-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    1,000

    Formula to enter value in cell down if not empty

    Need a formula to enter value in cell from F3:F14. For example, if F3 has a value, value should be entered in F4. If F4 has a value, value should be in F5 and so on. See sample file

    Sales Price ($)	$345			Month	Sales Price
				Jan	$354
				Feb	
				Mar	
				Apr	
				May	
				Jun	
				Jul	
				Aug	
				Sep	
				Oct	
				Nov	
				Dec
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need to enter empty row in excel once the prefix of cell is changed
    By ajasmine in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2015, 04:41 AM
  2. [SOLVED] Find first empty cell in column and enter value from textbox
    By Kevin62 in forum Excel General
    Replies: 10
    Last Post: 09-23-2014, 02:19 PM
  3. [SOLVED] copy paste, but if cell empty enter a value
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-10-2013, 07:23 AM
  4. [SOLVED] Match data in cells then enter date in empty cell
    By MyComputerGuy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2012, 08:16 PM
  5. Enter value in next empty cell
    By tomy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-18-2010, 04:26 AM
  6. Enter data in next empty row after cell name
    By Mark Cover in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-04-2005, 03:05 PM
  7. [SOLVED] Not allowing users to enter data into certain cells if another cell is empty
    By KimberlyC in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-06-2005, 02:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1