| Thread | Last Post | Replies |
|
| Protectected cell ignore | 31 Jul 2004 23:33 GMT | 5 |
How do I prevent the warning message appearing when trying to alter a protected cell.
|
| Dim question | 31 Jul 2004 21:44 GMT | 4 |
How do you reset a Dim so I can set it back to zero or 1?
|
| Index/Match Function | 31 Jul 2004 20:28 GMT | 1 |
Using Excel XP. I have two worksheets, one named "TIMES" and the other "HI&LO". On sheet "TIMES" I have a month & year in column A and a time in column B, e.g: A B
|
| Array function? | 31 Jul 2004 18:40 GMT | 3 |
Wondering if anyone can help me with my worksheet... I need it so that cell A1 on Worksheet 1 displays an 'X' if and when "A" is entered in any row on column A and "1" is entered in column C in the same row on Worksheet 2. Does this make sense?
|
| Cell coordinates | 31 Jul 2004 17:55 GMT | 1 |
I have an imported sheet that has a ton of data on it. I want to have my worksheet find data on the imported sheet by heading. So, for example, I want the data from the cell in the column labeled
|
| Excel XP question, working with Array's | 31 Jul 2004 14:10 GMT | 3 |
Hello Guys/Girls, I have the following problem. I have one main-list (Row A and B) with all member numbers. Also I got a list (Row K and L) which contains a second List with financial information
|
| Which function to use to open an .asc file? | 31 Jul 2004 13:01 GMT | 1 |
Im writing a vba program to take the info from an asc file into sheet2. I must use the xldelimited so the info goes into each column properly and not just everything in one column ( it uses the comma to determine the column).
|
| Combining VBA modules | 31 Jul 2004 11:38 GMT | 3 |
I have 4 Visual basic modules that I want to appear in the same module. How do I go about doing it.
|
| Small Name Box | 31 Jul 2004 09:35 GMT | 1 |
The name box in MS Excel is rather small and narrow. Is there a way to expand it ?
 Signature Regards,
|
| Restrict % to 100 | 31 Jul 2004 05:01 GMT | 2 |
I have a spreadsheet where a calculated field can be greater the 100% for reasons that I cannot change. How do I write code to restrict the dispaly to be maximum 100% Thanks,
|
| excel vanishes | 31 Jul 2004 04:17 GMT | 5 |
I open an excel 2k spreadsheet. it says the spreadsheet oopens but nothing is there? any ideas?
|
| "real time charts"? | 31 Jul 2004 02:50 GMT | 3 |
I have a list of data, that goes from january to december. (every week day, where there was stock market activity) I am trying to make a chart to track price changes, day-to-day, the chart looks fine, from january to today, but after today, the chart plummets to 0 and makes the ...
|
| database report structure issues? | 31 Jul 2004 02:36 GMT | 5 |
Hi, I have a exel table which calculates # codes that needs to b associated to graphics and text for a 20 to 30 page formated report. stored the graphics on a few sheets of a workbook and the text also o
|
| VLOOKUP with variable "Table_Array" | 31 Jul 2004 02:03 GMT | 1 |
Rather than specifying a specific named array such as in Vlookup(A1, namedarray,2,false) I'd like the table_array value for the vlookup function to depend on which table name appears in a specific cell.
|
| Convert CSV Files to XLS | 31 Jul 2004 01:45 GMT | 2 |
I have approximately 1300 .csv files that I need to convert to .xls files so I can extract data from a master spreadsheet. Excel apparently requires a .csv file be open to extract the data. I could open each one individually and do a save as, but that would be
|