| Thread | Last Post | Replies |
|
| help with debug | 02 Feb 2005 03:17 GMT | 3 |
Sub CheckBox3_Click() ' ' CheckBox3_Click Macro ' Macro recorded 2/1/2005 by Geo. Z'
|
| What is the main thing to remember to get started in EXCEL? | 02 Feb 2005 03:10 GMT | 3 |
What are some tips to make Excel easier to understand and employ?
|
| Convert general to Time | 02 Feb 2005 02:30 GMT | 1 |
Here is my data- i need to convert it to time format.. Any help would be appreciated 1:00:05 PM 1:00:10 PM
|
| getting date and time information- Masking? | 02 Feb 2005 02:23 GMT | 1 |
I have the following data that I want to mask off the minutes and seconds - yet keep the hour and am/pm how do I do that? 1:00:05 PM 1:00:10 PM
|
| right click option "pick from a list" | 02 Feb 2005 00:14 GMT | 2 |
i'm wanting to know can the information from the "pick from a drop down list" list be exported some how? I've been handed a load of spread sheets and been told to create a database with the information. not that good with either excel or access as you may guess. So i;m trying to ...
|
| a formula dictionary? | 02 Feb 2005 00:02 GMT | 2 |
Does anyone here know of a 'dictionary' for translating xls formulas to/from local languages to/from english. Such a thing would make it easier for non-english version users to give take advice to/from this newsgroup aswell as elsewhere. A mere list of
|
| Graphing Database Growth Rate | 02 Feb 2005 00:02 GMT | 1 |
Hello, all -- I have a job that grabs the size of each SQL Server database and log file size and saves one row per database into a table. I run this routine on a daily basis, so I basically grab the size each day and can monitor growth.
|
| Copy to new spreadsheet | 01 Feb 2005 21:51 GMT | 1 |
Is there a way to make an excel sheet covered in formulas copy itself and create a new spreadsheet with values instead of formulas to be emailed as just one sheet of information?
|
| Color cells | 01 Feb 2005 21:39 GMT | 7 |
Hi, I'm working with the loan amortization template that is shipped with Excel 2002. The bacground on a number of cells are colored pale yellow. I don't know how to clear the color or change it. I've tried the paint
|
| Pivot Table Dates | 01 Feb 2005 20:49 GMT | 2 |
I'm bringing in data from an external database & creating a Pivot table with grouped dates (Eg months) when this table is copied and the date grouping changed from say months to qtrs it changes the original to qtrs as well
|
| Date and time imports | 01 Feb 2005 20:31 GMT | 1 |
I would appreciate any help on the following: We import a number of rows of data from two time recorders - both include the date, time, minutes, seconds. One is much more frequent than another giving data every second whereas the other only polls every 3 seconds or so.
|
| chart displaying horizontal line for zero data | 01 Feb 2005 20:22 GMT | 3 |
I am using a column chart in Excel. The chart is currently displaying a horizontal line when there are zeros for the data. It is working as it was designed to do... however I would like to make the graph not display a line when there is all zero data. Is there an easy
|
| Time Formula ??? | 01 Feb 2005 20:17 GMT | 12 |
I have been trying to do this myself, but just can't get around it. I have various worksheets with bus routes and timetables. These are the columns. A BusNo
|
| Macro compatibility in xls2003 | 01 Feb 2005 19:04 GMT | 11 |
I'm having trouble exporting data from a source program (SAP) to excel. It worked fine with the '97 version, but since we upgraded to '03, nothing happens. I'm not too experienced with scripts, but I'm told that the macro in the SAP
|
| How can I combine 3 separate mailing list? | 01 Feb 2005 16:54 GMT | 3 |
I am working with 3 separate mailing lists stored in 3 excel workbooks. I want to keep separate files, but occasionally need to combine all three into one file or workbook to do a large mailing. Do I have to create a fourth workbook and copy and paste the three existing files ...
|