| Thread | Last Post | Replies |
|
| create macro | 11 Feb 2005 12:23 GMT | 1 |
How can I create a TWO seperate macros in a spreadsheet in Excel: there are icons/pictures which have a macro attached to it. How do I attach the macro? macro 1:
|
| Excel | 11 Feb 2005 08:32 GMT | 2 |
How to paste formated sheets to new file sheet? Formated sheet has artwork (logo) and formulas that should carry as values only
|
| How to consolidate/sum a list | 11 Feb 2005 07:05 GMT | 5 |
I have a simple spreadsheet in the following format ... Cell A1 with a heading Part Number, B1 heading Description and C1 heading Quantity. Under the headings is a list of 100 rows and a part number can appear more
|
| Minimum Row Height? | 11 Feb 2005 06:02 GMT | 1 |
Is it possible to set a "Minimum Row Height", without restricting the ability for the row height to grow if required by a cells contents? I'm trying to find a way to introduce some white space in the line spacing. In word this would be similar to Format . . .Paragraph . . .Spacing ...
|
| Borders line weight | 11 Feb 2005 01:10 GMT | 5 |
Is there any way to control the line weight that Excel uses for the border line weights? In particular I'd like a thinner single line. It appears to default to about 1 pt. I'd like something equivalent to what you can do in Word, say
|
| Dynamic Getpivotdata in Excel XP | 11 Feb 2005 00:03 GMT | 1 |
Folks I urgently need help with this function. I'm trying to make this function dynamic, i.e. depending on some condition, make some members disappear or otherwise.
|
| Common data in VBA module. | 10 Feb 2005 21:55 GMT | 1 |
Simple question. I want build a common data module. all other modules can access to the data module. because data in module is private.
|
| How do i copy columns of data in notepad into microsoft excel? | 10 Feb 2005 21:48 GMT | 2 |
I have a several large columns of data stored in notepad. The columns are all next to each other. I need to put column 1 in column A in excel and column 2 into column B in excel etc. Copy and paste does not work. I can’t just highlight one column I end up highlighting all 6 ...
|
| looking for way to name columns (across sheets in wkbk) | 10 Feb 2005 21:33 GMT | 3 |
hi Group, I have named the columns of my first wksht as FY_2003, FY_2004, etc. That works fine. But, when I go to use those column names in a second worksheet,
|
| protections for objects | 10 Feb 2005 21:13 GMT | 1 |
I have notice that both comments and controls (command buttons, list boxes...) are afected in the same way by the protection "Edit objects" in Protect sheets is there any way to be able to allow insert/modify comments but not edit the
|
| Hi | 10 Feb 2005 20:48 GMT | 2 |
How do i trigger a macro when a spreasheet opens? Cheers! Neil
|
| DATES | 10 Feb 2005 20:31 GMT | 3 |
I am trying to perform a simple formula, but I can't figure it out. In cell A1, I have the date 02-01-2005. I would a formula in A3 to calculate the date 60 days from A1. For example A1 is 02-01-2005. A3 should be 04-01-2005 Thanks,
|
| Number to Words | 10 Feb 2005 19:45 GMT | 2 |
Please help me to convert numbers to words in excel Eg.: 123 one hundred twenty three. Vicky
|
| Occurrences of a date in a column | 10 Feb 2005 19:37 GMT | 1 |
I'm not a very good Excel user (yet!) and after going through the topics, I don't think I've found what I need, so I'll ask the question. I have one column of data which is dates: Col A
|
| need formula for percent off of column | 10 Feb 2005 18:45 GMT | 5 |
I know nothing about this and I am in a pickle. I don't even know where to type in the formula, so please spell it out for me in kindergarten language. I need a formula that will figure a percentage off. I have a column that is Retail Price and I need a formula that will auto
|