| Thread | Last Post | Replies |
|
| Creating multiple charts in an excel sheet | 12 Jun 2007 21:03 GMT | 2 |
Is it possible to create multiple charts (around 9 charts ) in a single excel sheet? Creating the charts have to be programmatic by running a VB code. Please somebody provide some help. Thanks and Regards,
|
| Getting started tab | 12 Jun 2007 20:57 GMT | 7 |
I downloaded and installed (supposedly) the getting started tab, it said it was successfully installed. When I open Excel, I cannot locate the tab. Where is it?
|
| Disappearing Text in new excel files after format - wrap text | 12 Jun 2007 20:53 GMT | 1 |
Something has apparently changed on my Dell Latitude 610 laptop with my installation of Excel 2003. If I type text in a cell and then choose Format Cell - Wrap Text, the text disappears from the cell. It is still there, because you can see it on the edit text box at the top
|
| linking data | 12 Jun 2007 20:51 GMT | 4 |
I know how to copy data from one Excel file and do a Paste Special, Paste as Link onto another file. That works fine but the updated data flows in one way only. Is there a way of linking two Excel files so that you have the same data on each one, but they are linked so that ...
|
| S.O.S..... | 12 Jun 2007 19:57 GMT | 9 |
I have a spreadsheet set up with column A for the date (one day per row), and column D as the total daily takings. I want a formula that changes automatically when I enter each new daily amount, and if I enter a daily taking of $0, I don't want excel to include that day in the ...
|
| Protect formula cells | 12 Jun 2007 17:07 GMT | 3 |
I am using Excel 2003 and I am wondering if there is a easy way in protecting formula cells in my workbook. I have about 25 formula cells and it is all over the workbook. My users keep changes the formula cells, they suppose to enter data not changing formulas. I have about 20 ...
|
| Linking Cells Between Sheets | 12 Jun 2007 16:05 GMT | 5 |
This very straight forward function no longer works for me. When I enter "=" the cell reference cell changes to "ACOSH" as opposed to "VLOOKUP" on other computers. This will not eference cells on other worksheets within the same spreadsheet
|
| locking text in a cell, but allowing new text to be added | 12 Jun 2007 15:47 GMT | 2 |
Sorry for such a newbie question. I have created a form and in some cells, I have text that I want to lock, but allowing others to add to the text in the cell. For example, if I put "Resolution Suggestions: " I would like that to be locked, but enable others to add their ...
|
| How to Loop a macro in Excel | 12 Jun 2007 14:10 GMT | 4 |
I've looked at some of the other reponses, but I'm an absolute beginner, because I haven't done macros for many years now. All I'm trying to do is copy a cell down a column until it hits the next value, then loop. There are irregular rows between each value.
|
| Simple way to enable just my personal macros in Excel (& Office) 2007 | 12 Jun 2007 12:55 GMT | 13 |
We recently upgraded to Office 2007. I have a number of macros in Excel. I just opened a spreadsheet I use periodically and I get a #NAME? error in every cell with a macro reference. These are my own personal macros. How do I enable them without opening
|
| Vlookup question | 12 Jun 2007 12:54 GMT | 12 |
I have to search and put values in one of my sheets after looking in a field of a field. I believe i need to to a nested vlookup, but im not sure how to go about it. I copied the relevant portions of the data
|
| Off Set printing | 12 Jun 2007 12:36 GMT | 1 |
Folks: On my spreadsheet I would sometimes like to print the row & column headings. I can do this by going to the PAGE SETUP >> Sheet Tab >> check the "Row & Column headings" Box.
|
| excel vba question | 12 Jun 2007 11:52 GMT | 2 |
How can you hide the option dialog box in Excel (2003) (Tools - Option). Which VBA code can be used or is this possible through protection. Thanks Groet
|
| TRIM function | 12 Jun 2007 11:06 GMT | 2 |
Is it possible to trim an entire worksheet?
|
| Vlookup | 12 Jun 2007 09:05 GMT | 1 |
I am facing a problem. I have 2 work books. The 1st is masterlist.xls and the 2nd is source.xls. I want to check under the column "acc no" and "acc officer" of the masterlist against the source to see if there is any updates/change in "acc officer"
|