| Thread | Last Post | Replies |
|
| Workbook protection | 09 Sep 2006 23:19 GMT | 3 |
I have a excel document with an serial nummer protection. It is a trailversion for 30days. i got it from somebody but the trail period is over. Now some funktions are not working. My knowledge of VBA is not great and i don`t know where to look. So can somebody help me tho get ...
|
| ASCII text file import more than 65536 entries | 09 Sep 2006 23:17 GMT | 5 |
I have used this macro to import the ASCII text file in excel. It is importing everything in the column A. I need to divide that into multiple columns as the normal import does. Can someone suggest a quick way of doing this?
|
| Decision Tree style logic in Excel | 09 Sep 2006 23:16 GMT | 2 |
Anyone can give me some advice on a decision tree style presentation in XL? I want to do a survey which is to guide the user to a proper result. Since I have already had all the tree structure, the only thing I have to do is input the tree structure, and let the program keep
|
| Counting with numerous citeria..complicated | 09 Sep 2006 23:14 GMT | 2 |
I have a complicated question for help. I hope that I make it sound ok. First thing to remember is that this sheet is linked to another, which is in-turn link to another...ive been filtering data! so what i have is:
|
| Can more as 1 user use Excel File in Intranet in the same Time | 09 Sep 2006 23:11 GMT | 1 |
Can more as 1 user use or modify Excel File in Intranet in the same ??
|
| Looping through records | 09 Sep 2006 23:06 GMT | 2 |
Hi, I am learning some basic VBA in Excel. I know that using inout boxes is not the best way to input multiple cells, but as I said I am playing with VBA. The following code takes me through cells on a single row and allows me to
|
| Locking all cells accross when sorting columns | 09 Sep 2006 20:54 GMT | 1 |
Is there any way of locking all cells next to each other accross so that the document can only be ssorted via columns? I want to use Excel as a DVD database whereby all the information of a particualr DVD is stored as fields accross the documnet i.e. title, genre,
|
| find and delete 2 rows | 09 Sep 2006 20:02 GMT | 9 |
Worksheet1 (names list) Column A column B NameA 1 NameB 2
|
| How do I not print the column letters A-Z but keep the row #'s | 09 Sep 2006 19:59 GMT | 5 |
I am trying to print a chart where I want to keep the row numbers but not the column headings A-Z printed. Choosing Page setup under the Sheets tab only lists them together not as single choices. Is there a way to customize the sheet to only list the row numbers?
|
| How do I set up a program just for income and expense? | 09 Sep 2006 17:05 GMT | 2 |
I have started a small business and am in need of a very simple income and expense spreadsheet. Any suggestions?
|
| Count with difficult/multiple citeria | 09 Sep 2006 14:43 GMT | 3 |
I have a complicated question for help. I hope that I make it sound ok. First thing to remember is that this sheet is linked to another, which is in-turn link to another...ive been filtering data! so what i have is:
|
| How do i copy a scramble file with 20970 rows to excel? | 09 Sep 2006 14:31 GMT | 4 |
I try to copy a big file to excel, but the files i am working on now is not in line and how do i get it in line with over 20970 rows. Please help me here. Thanks
|
| Changing data from imported .txt file | 09 Sep 2006 13:26 GMT | 1 |
When i import data from an old (dos based) program negative numbers appear with the minus behind the number. Does anyone have any idea how i can change them all from 1,234.56- to -1,234.56 so Excel will recognise them? Changing them by hand takes forever. Thank you.
|
| pivot table question for Excel gurus .. seems difficult. | 09 Sep 2006 10:28 GMT | 1 |
I would like to create a report using following sample data in excel ticket month application T1 2006-06 ABC T2 2006-06 ABC
|
| Macro to insert data into next blank row? | 09 Sep 2006 09:40 GMT | 2 |
I have a list of names, addresses, etc that I'm setting up for a mail merge. I already have a macro that converts the names from a format like this: Col A Name
|