| Thread | Last Post | Replies |
|
| Web Query Updating Question | 21 Dec 2007 10:50 GMT | 1 |
I'm updating sports scores in excel 2002, The first set of Columns Are the Team Names and the Final Score of the Game (These 2 columns update after each game). My other 2 columns are used for notes and other information. When ever I refresh the data, the first 2 sets of ...
|
| Cannot unhide toolbars/menus | 21 Dec 2007 10:40 GMT | 1 |
Through reading the posts on here, I have created my first bit of VB code to hide menus/toobars within my workbook (or so I thought). The problem is, I have realised this is the case for all Excel files I open (not the intention!). If I press Alt-F11 to get back to the VB module, ...
|
| Fix content of cells (not allow users to change) | 21 Dec 2007 09:40 GMT | 3 |
I want to fix all content in "row 1". meaning, users can only update content from row 2 on wards, all headers in row 1 should not be changed. Thanks a lot, experts !
|
| how do i copy values between tables using relative formulas | 21 Dec 2007 09:23 GMT | 1 |
I've created a workbook in Excel 2007 and I'm trying to use the copy feature to insert relative formulas into several adjacent cells by draging the relative formula one one cell into several adjacent cells. While the resulting formulas are corret the relative values are not.
|
| How do I delete a header in Microsoft Excel? | 21 Dec 2007 08:27 GMT | 6 |
I would like to know how to delete a header in Microsoft Excel. Can you help?
|
| Excel 2007 - cannot print several sheets in color | 21 Dec 2007 07:55 GMT | 5 |
Since getting 2007 when I print several sheets only the first sheet comes out in color, even though I in the print box specifically chose color. I print on Xerox. The rest comes out in color, like it's separate printjobs and it uses the
|
| Counting combinations of numbers | 21 Dec 2007 06:12 GMT | 4 |
I have some rows of numbers that I need to count certain combinations, here is an example: 2 4 6 8 1 2 4 7
|
| Help with Text import and data extraction | 21 Dec 2007 05:07 GMT | 19 |
We are converting to new software and want to import project data from the old system. I import the text file (I think it’s a print file as text) and skip the first two columns. This eliminates the group headers and leaves me with a
|
| Frequency | 21 Dec 2007 04:13 GMT | 5 |
I am trying to run a daily total of the # of responses to 5 questions. Each question has 5 possible responses. Question 1 had 5 responses rated as 5, questions 2 had 2 responses rated as 2, etc. I thought I could create a formula, but I'm stumped. TIA.
|
| Multiple comparisons in a cell | 21 Dec 2007 01:49 GMT | 3 |
I'm still learning what Excel 2003 can do for me, so this may be a stupid question. I am tracking equipment maintenance records and I need to create a cell that will say "OK" if the machine has over a certain of hours since the last maintenance, "DUE NOW" if it is within 300 ...
|
| can i set a button in excel to automatically send the page when | 21 Dec 2007 01:33 GMT | 1 |
i would like to insert a button to automatically email a spreadsheet to a certain person
|
| Excel Formula | 21 Dec 2007 01:29 GMT | 1 |
I need to set up a formula for mileage expense, with the formula multiplying the reimbursement amount against mileage. How do I do this?
 Signature weejinit
|
| Chart location | 21 Dec 2007 00:13 GMT | 1 |
On one spreadsheet I am not able to embed my chart on the worksheet with the data. When I go to location the only option it will let me have is "as new sheet" The "as object in" choice is grayed out and I can't choose that option.
|
| Insert Worksheet Names into Cells | 20 Dec 2007 23:25 GMT | 1 |
I'm creating a summary sheet of names of work sheets, all in the same workbook, that will vertically list the sheet names in a column. I want to be able to change the work sheet names on their respective tabs and have ths automatically reflected in the list on the summary sheet. ...
|
| transpose delete | 20 Dec 2007 23:24 GMT | 3 |
Hi: I have 3 columns of data; the first column is just a descriptive field giving the file name, and the data in the 2nd column are all the same with values next to them: like this separate house: 200
|