| Thread | Last Post | Replies |
|
| How do I convert copy and paste from web to data. | 18 Jun 2005 04:24 GMT | 11 |
The Abbey in its infinite wisdom chooses not to give their credit card customers the same options as they do their current account customers. Specifically they do not allow their credit card customers the ability to download their statements. The only way I can get this info
|
| Spreadsheet (use for test) | 18 Jun 2005 04:07 GMT | 2 |
I need help (direction) in creating a 50 question test in excel. I would like for the tester to select the answer for each question (multiple choice). At the end of the test, a button that will grade the test (Pass, Fail, Miss est..). The person taking the test can not go back ...
|
| Comment Box | 18 Jun 2005 04:05 GMT | 2 |
How can I change the comment font default from size Tahoma 8 to 10.
 Signature Bobby Atkinson batkinson@iquest.net
|
| linked data | 18 Jun 2005 00:26 GMT | 4 |
Thanks in advance for the assistance. In a pre-existing form with a drop-down box containing multiple text selections, I am trying to link the selection of that drop down box to auto-fill the rest of a form. (For example, when I select a name from a
|
| Cell Format problem, not changing | 17 Jun 2005 22:53 GMT | 1 |
This is a strange problem and searching all over google cant get any help. There is a row of dates, in format 10/23/1983, we are trying to change it to another format. When I click the cells properties and change the format, nothing happens. This includes the "sample section",
|
| Naming Sheets in Visual Basic | 17 Jun 2005 22:44 GMT | 1 |
I'm using VB and I have am in an unnamed sheet that was created when i selected to show detail in a pivot table. My question is - Is there a way to name the new sheet, which i am in, with out specifying what the current name is?
|
| Vlookup/Indirect Address Question | 17 Jun 2005 22:16 GMT | 2 |
I have a quick question. So I have three inputs into a formula. In Sheet1, The values in cells A1, B1, and C1.. I want to output to cell D1 Somewhere in column A of sheet 2 is the value of A1 (to be looked up).
|
| worksheet function | 17 Jun 2005 21:26 GMT | 8 |
when i put in IFTODAY()-D4>10,SUM(C4,J4),0 it comes up false I also tried IFTODAY()-D4>10,C4*5%,0) same thing. Here is an example of what I'm trying to get: C=Amt pd
|
| Format Text in spreadsheet based on text? | 17 Jun 2005 20:27 GMT | 2 |
I have a really bad spreadsheet that I am unable to sort or create a list out of without doing a bunch of manual editing so I was thinking that if I could highlight certain text with a different font, color, bold or whatever that would be good enough so I can visually make out the ...
|
| Add Text To Multiple cells | 17 Jun 2005 20:25 GMT | 2 |
I am working on this project & I cant figure out how to add a letter in front of each number in a cell without clicking in to each individual cell and typing it in. (very time consuming and tedious) The problem is - it's not all the cells but a majority, all of the numbers are in ...
|
| Transfer problems[Excel 97] | 17 Jun 2005 19:02 GMT | 1 |
I got a strange probs occuring with excel 97. I had to change the format of some cells from dd-mm-yy to dd-mm-yyyy So I used custum and added 2 year number.
|
| Macro Help... why does this error out? | 17 Jun 2005 18:56 GMT | 1 |
This macro exports some info from excel to notepad... it'll right about 4 records successfully then it'll give me a "Run-time error'5': Inavalid procedure call or arguement" on the line of code that reads "CellText = .Text & Space(ColWidth - Len(.Text))" If someone has some ...
|
| Payment Calculator not working correctly | 17 Jun 2005 18:38 GMT | 2 |
Recently I tried to program an Excel spreadsheet to calculate a mortgage Payment using the =PMT(Rate/12,Term,Loan Amount)*-1 formula that I have used on many other spreadsheets. These older spreadsheets all work properly, but they were all written on another computer and ...
|
| Why file opens so slowly? | 17 Jun 2005 18:03 GMT | 2 |
I would welcome any insights as to why one of my Excel files opens soooo slowly. I'm running Win 2K, Excel 2000, with plenty of ram and free disk space. Normally Excel files open in less than a second. But this one has been
|
| AUTOMATING JOB SHEETS IN EXCEL | 17 Jun 2005 17:51 GMT | 2 |
I have a lot of customer data for job sheets that need printing out. I was wondering would anyone know if it would be possible for Excel to read in a data file, or even another excel spreadsheet and for each record/row create a new Job Sheet. Otherwise I have to manually create ...
|