Understanding Computers/Excel


Each month I create a running sheet ie dates 1-31 down left side with appropriate days beside each one and space to the right to insert work scheduled. I wonder if Excel can create this info automatically once I insert the appropriate day to the number at beginning of each month? Can always remove the 31 as needed!

Hello ann:
Thanks for asking this question.  
Although I can not give you exact steps, I remember you can do this using macro command. You may have to use Date function of excel.  Macro command in excel is simply the collection of manual instructions/steps that you need to do without automatic method.  Please search more on macro function in excel. It was for a long time since I used macro.  I hope this gives you a direction.

Understanding Computers

All Answers

Answers by Expert:

Ask Experts




I can answer questions regarding general computers, data base, software, system design, Mainframe, SAP system, and word processing packages and programming.
I am also an avid golfer, and welcome to Simple Golf Swing and Secrets!
iPAD Video Lesson is available now for great training. Please check this site. iPAD Video Lesson Site!

Natural Vision Care, Eye Exercise!

Have a great day!


I have been working in Computer Information Systems area for past 20 years. My expertise includes programming, system design, data base design, and end user computing and ERP/SAP implementation. Currently I am actively involved in SAP System Design and Implementation.
...SAP Training Place!

...Ultimate SAP Training System - Computer Based Training!
...my Learn SAP - Knowledge is Power for IT Pros!
...SAP Book review from Amazon!

...Learn how to earn income online via Affiliate Internet Marketing (AIM), Check below!
=>Click this!
=>Click this for fun AIM!


To Learn SAP:
How to grasp High Level and Fundamental Understandings of SAP system?

SAP Training Place!
VLOOKUP is a simple and powerful tool in EXCEL.
How to merge Excel files using VLOOKUP?
Make an International Phone Call
my Learn SAP - Knowledge is Power for IT Pros!
my Learn Golf - Simple and Straight!

I have completed Master degree in Computer Information Systems.

Past/Present Clients
TOSHIBA PC - Smart Choice!

©2017 About.com. All rights reserved.