| Thread | Last Post | Replies |
|
| sortable list | 10 Apr 2005 14:37 GMT | 2 |
Is there a way to create a sortable (Excel data sort) list that can flow or expand over two columns (WORD ie: bottom of col 1 continues at top of col 2). Which Office can do both?? TIA
|
| vba to print Form from Excel ? | 10 Apr 2005 14:32 GMT | 1 |
I've got a for for entering data into a spreadsheet. Can you print the Form as it is using Excel VBA ? If so, any code snippits that may give me the idea? thanks for any help.
|
| Formula to Return a Value Q | 10 Apr 2005 10:45 GMT | 4 |
I have a database of Sales Mixes by Location by Sales Date. What I am trying to achieve is to produce a simple table that will detail to be for what Location and Sales date any Sales Mixes are missing. My Report will look something like this
|
| How to alphabetize my created list? | 10 Apr 2005 09:49 GMT | 3 |
I am not very computer literate so I will need step by step instructions how to create a list then alphabetize it. Thanks
|
| Simple Hyperlink Macro | 10 Apr 2005 08:21 GMT | 3 |
Hi. I am using MS Excel 2003, and I am very new to the program. I don't know how to use visual basic or programming of any kind. I need help with a macro, and I'm hoping this is the best place to ask for help. I have a worksheet entitled "NT." In column "A" I have a very long ...
|
| Displaying Excel 97 Formula Bar | 10 Apr 2005 05:35 GMT | 2 |
This sounds crazy, but I can't display the Formula bar. The Standard and Fromatting bars are displayed. What do I do?
|
| transfering forms | 10 Apr 2005 04:37 GMT | 2 |
is it possible to scan blank form into excel program and use as templete.have tried unsucessfully ,unable to fill in blanks .thanks,john i am using excel 2003
|
| Horizontal split | 10 Apr 2005 04:36 GMT | 4 |
Office 2003 I can do a vertical split window, but I've also seen worksheets in which you could scroll down a page but still keep the header rows at the top visible, to keep the column descriptions visible.
|
| Change legend text in Excel Chart | 10 Apr 2005 02:30 GMT | 1 |
Dim appAs Excel.Application Dim chart As Excel.Chart Set app = CreateObject("Excel.Application") chart.HasLegend = true
|
| How do i get page 1 of 1 in a custom Footer | 09 Apr 2005 17:55 GMT | 3 |
It's only a simple thing but i don't know how to get page 1 of 1 without typing it in myself can anybody help Thank's
|
| Sheet Protection Problem | 09 Apr 2005 17:46 GMT | 4 |
Using Excel XP. I have 100 worksheets in a workbook where I have a range in each one that I have the cells protected. I am using VB code to protect and unprotect the worksheets. (see below). The problem that I am having is after unprotecting the sheets and then
|
| Pivot - Calculated field | 09 Apr 2005 17:12 GMT | 1 |
I have a database of the following columns based on which a Pivot is created. There are various other parameters/Columns by which Sales, Margin are broken down. Each month may have hundreds of lines. The below is just a simple overview.
|
| Protecting Formulas | 09 Apr 2005 16:37 GMT | 1 |
I have a formula in a cell which is copied to several other cells for future calculations. How do I prevent the formulas in those cells from being erased? I am preparing this for others to use. Thanks in advance.
|
| Displaying cell references next to embedded cells in Word 2000 | 09 Apr 2005 14:59 GMT | 1 |
Hello Group. I've embedded some excel cells into my report written in Word 2000. Is there a way I can display the cell references next to the embedded object in the printout.
|
| Excel: How can I get numbers without decimals ? | 09 Apr 2005 13:43 GMT | 2 |
After entering numbers in a cell they appear as decimals. I have tried going into Format and changing it to 0 decimal but then I get 0. Can you please help me.
|