 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Repeat value from cell above
Setting up a data entry screen with 9 columns. The first 3 columns (Entry date, salesman, customer) might repeat several times: How do I repeat and display the value from the cell above if there is no value entered in the current cell? Thank you! Carl Try this: Select from the first category down through the last relevant blank cell Press the [F5] key......a shortcut for <edit><goto> Click the [special cells] button Check: Blanks Click the [OK] button (that will select all of the blank cells in that range) WHILE THOSE CELLS ARE STILL SELECTED... Type: =...to start building a formula Press the UP arrow one time Press CTRL + ENTER...to put that formula in each blank cell Does that help? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) Select the whole range of categories (hardcoded and formulas) <edit><copy> <edit><paste special>...Check: Values ...Click [OK] > Setting up a data entry screen with 9 columns. The first 3 columns (Entry > date, salesman, customer) might repeat several times: How do I repeat and > display the value from the cell above if there is no value entered in the > current cell? > Thank you! > Carl Thanks Ron, that seems to work after the fact... it fills all blank cells correctly. My goal is to do it as data entry takes place, i.e. : if nothing is entered at cell d14, it should default and print the content of d13. Is that possible? Carl > Try this: > [quoted text clipped - 30 lines] > > Thank you! > > Carl You'd need a VBA program to effect the activity you're describing. If it would be the only code in the workbook and it's not critical, it may not be worth the trouble of possibly changing everyone's security settings, editing the trusted site list, and getting prompted to enable macros whenever the workbook is opened Your call... -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) > Thanks Ron, that seems to work after the fact... it fills all blank cells > correctly. My goal is to do it as data entry takes place, i.e. : if [quoted text clipped - 40 lines] >> > Thank you! >> > Carl
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.