Question about Microsoft Office 2003 Basic Edition English (s55-00066) for PC

1 Answer

Excel support I consider myself fairly good with excel, however my co-workers thinking anything is possible in excel! This is what I need to do: I have a column with 6 rows and the months "Jan thru June" in the rows. Can you program it to know when its a new month and add it automatically. When July comes can the 6 rows be hidden (not deleted) and show the next 6 months July thru Dec. Is tihs possible?

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Sniper:

    An expert who has posted more than 50 answers, of which 90% or more were rated as helpful.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 52 Answers

Hi,
Cool problem I use this to track stocks for the latest 5 days, 15 days and so on.

First I have a sheet that is titled "DataRecord" this has my individual data in columns and the days recorded in rows. This is a complete record or all recorded stock activity. This is where all the entrys are made in rows. I freeze window to make the column headings and the left most column(the date) always visible to prevent errors.

Next I have a sheet that is titled "L5DaysData' I have sevreral rows of data like avg, & what ever. and the latest 5 days data starts on line say 6. a typ. cell ='DataRecord'!B970
The next cell down has a value of ='DataRecord'!B971 and so and on until B974

My Graphs are built on these individual "L5 or 15 or 60 or90 day" sheets of data.

Next I make a macro that translates the last line of data down one row and deletes the row just above the earliest that I want to save on "L5DaysData" so it always shows only the latest 5 days of information.

All the information shown on that worksheet is the data for graphs or tables refering to the latest 5 days activity.
The graphs are automatically updated with the data each time the macro is run.

You can also use a formula to adjust the date column by adding a value of one to a specfic dated cell untill you reach Sat or Sun and add 3 or 2 to that date cell and translate that down a column and use a work sheet that records only the latest 3Mo. with macros that updates the information when you want it to.
Hope this helps.
Glad to be of assistance - please rate the solution I can learn from you. Thanks

Posted on Oct 26, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

Excel Corruption files


Without seeing the file, it is difficult to diagnose what is going on, but I will offer some ideas.

What version of Excel are you using? Are you using Excel 2003? Was the file you are trying to open created in Excel 2007 or Excel 2010. If so, it might be using the new format and therefore will not open in Excel 2003 and older.

It is possible the Excel file is data that was imported from a source in which Excel cannot import. Does the Excel spreadsheet contain any imported data?
Try to use: XLSX Viewer Tool here : http://www.xlsx.viewertool.com/
Those are the most likely causes of the corrupt data. Is every file you open in Excel corrupt, or just this one workbook? If it is just this one workbook, then, yes, it sounds like it is corrupted. If every file you open with Excel is corrupt, then your version of Excel could be corrupt, but that is unlikely.

Jul 10, 2015 | Microsoft Excel for PC

4 Answers

Excel 2007


You can only put a password to the spreadsheet but there's no time expiration option, perhaps it isn't possible to do it.. Its an MS Excel limitation.

Oct 16, 2008 | Microsoft Excel for PC

1 Answer

I only have pc access at my mom's retirement center and want to buy and download ez numbers proforma excel software. What do I need to do so I can use and download this program? I'm not sure if they are...


hi there debbie

your computer come out with the excel on it if out
i can sale you excel to you with a code
that you can load on you computer

you can email me on info@jvcomp.co.za

Dec 14, 2009 | Microsoft Excel for PC

1 Answer

I WANT Free MS Office 2000 EXCEL SOFTWARE


I don't think you can get any free MSOffice Excel. you can get a reader, but not anything you can use to create spreadsheets, etc. without purchase.

I would recommend trying OpenOffice.org and using that freeware. Works just as good, and opens most Microsoft office extensions.

Aug 29, 2009 | Microsoft Excel for PC

1 Answer

Query for Excel


i dont think it is possible

Nov 01, 2008 | Microsoft Excel for PC

1 Answer

Excel Formula


Yes you can and there are two choices. The simple solution is to label a cell "divide by" and put your number in that filed. Then, by changing only that, your answer (in a separate cell) will be available.
There are more complex solutions -assuming your divide by number had some rhyme and reason that could be put in place but.....try this first and at a later date go back and play. Learning to do that will give you more than a fair amount of Excel expertise....something you may find fairly valuable as you continue on using Excel. FYI...I have developed full blown applications on Excel....it is an excellent tool. Hope this helps....Tango.

Feb 05, 2008 | Microsoft Excel for PC

9 Answers

Excel password recovery


you just try Excel password recovery software which is best solution to recover excel your lost and forgotten excel file password, this software perfectly works on locked Excel file and easily unlock excel file because i have also used this software it work very well............

Jan 14, 2008 | Microsoft Excel for PC

2 Answers

2007 version running SLOW!!


Are you trying to open a .xls file instead of an .xlsx file? Xlsx is the excel 2007 file format. Another cause could be a lack of free space on your hard drive. Uninstalling the 2003 version or defragging could do it. One last question: XP or Vista? I find Office 2007 works better with Vista. Good Luck! ---- JG

Jun 21, 2007 | Microsoft Excel for PC

3 Answers

SOOO SLOOOWW!!! Excel 2007


Are you trying to open a .xls file instead of an .xlsx file? Xlsx is the excel 2007 file format. Another cause could be a lack of free space on your hard drive. Uninstalling the 2003 version or defragging could do it. One last question: XP or Vista? I find Office 2007 works better with Vista. Good Luck! ---- JG

Jun 21, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Office 2003 Basic Edition English (s55-00066) for PC Logo

171 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...