Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-17-2006, 08:37 AM
dipdog dipdog is offline
Novice
Automatically entering/fill data in cells in Excel 2003
 
Join Date: Aug 2006
Posts: 1
dipdog
Default Automatically entering/fill data in cells in Excel 2003

I'm sorry if this has been posted before, but I am having difficulty finding an answer that works for me. I'd like to write a simple Excel file that would do 3 things.



1) Automatically fill in the next sequential row number every time a cell is selected in the A column. ie. after filling row #1 with data and hitting enter, cell A2 would automatically fill with the number 2, and then, after hitting enter, A3 would automatically fill with the number 3, etc.

2) Automatically fill in today's date (static, so that the value will not change tomorrow) every time a cell is selected in the B column. I've tried adding a couple different versions of macros/module to the VBAproject, but I'm having difficulty getting that to work, and perhaps I need step-by-step directions. One thing I didn't understand is, does a macro have to be manually started (ie. Tools>Macro>Macros>Run) every time you select a cell in order for it to run?

3) Automatically fill in a word every time a cell is selected in the C column, such that if I hit Tab the word will remain or if I hit Backspace I can type in a different word.

I'm a novice with Excel, so I'm hoping these are easy questions!

Thanx for your help

- Scott
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically entering/fill data in cells in Excel 2003 Excel not saving all data and formatting TRT Excel 2 04-09-2009 12:51 PM
format cells to automatically place quotes around text dirtleg Excel 1 09-16-2008 01:52 PM
How to count cells containing data and meet certain criteria AdamNT Excel 1 08-11-2006 11:51 PM
Saving only "DATA" on excel? No white bottom? jrasche2003@yahoo.com Excel 0 08-07-2006 09:27 AM
Automatically entering/fill data in cells in Excel 2003 Refreshing Data in Excel jamal420 Office 3 06-13-2005 03:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:27 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft