| Thread | Last Post | Replies |
|
| Column titles | 26 Aug 2007 18:20 GMT | 3 |
Hello, All! Perhaps I have not woken up properly yet but I have a sheet that is updated daily and there are several sets of columns derived from the input values. I sometimes forget which columns are
|
| Error messages not printing | 26 Aug 2007 17:28 GMT | 2 |
Good day, Can someone please tell me what I forgot to do? My Excel worksheet has errors (voluntary) and I want to print them. On File>Page Setup>Page, I activated the option (Cell errors as displayed). Somehow, they won't print
|
| Junk Characters in Excel Documents | 26 Aug 2007 17:12 GMT | 1 |
I have problem in Excel files which i recoverd from the Formatted Hard disk specially the 2048 kb size has junk character
|
| How do I print two separate cells in a certain space on a form | 26 Aug 2007 15:34 GMT | 2 |
We have a gift card that has a space for the sender's name/comment and order number. These items will be downloaded into an excel spreadsheet daily from a website. The name/comment is in one cell, the ordernumber in another cell. We need a way to print this information on each ...
|
| How do I use Excel 2007 to determine late payment amounts | 26 Aug 2007 15:24 GMT | 3 |
I was told a spreadsheet program could figure this for me easily. I know the basics of Excel but I'm not an expert. Here's the situation. I sold land to Sam on contract for $35,000 with no interest. The terms of the contract require payments of $500 per month due on or before ...
|
| How do i can lock more than one range in worksheet | 26 Aug 2007 15:06 GMT | 2 |
without any doubt excel is a great help to Accountants. I do a lot work on excel. Even once I maintain company account for a year in 2000 and 2001. Now my question is that how I can lock more than one range (Row & Coloumn) in a worksheet.
|
| new day in next worksheet Day 1 plus 1? | 26 Aug 2007 13:54 GMT | 1 |
add the value to a date in 1st worksheet to the value in the date in the new work sheet. using a macro function I would like to add a new worksheet and use the date value in the previous
|
| Creating Nested Functions | 26 Aug 2007 13:16 GMT | 3 |
Creating Nested Functions using IF AND and IF OR Help Please. Its for an assignment and I just can't get it. The problem is as followed: 5 days for Full time employees who have worked 1 or more years.
|
| Can i count how many letters A from cell e10 to sell h10 ? | 26 Aug 2007 13:08 GMT | 1 |
Can i count how many letters A from cell e10 to sell h10 ? i need to count all value countin letter a . I have attendence sheet and I alwayes put letter p for present student and letter a for student who is absent . So in the total list of absenties i
|
| Excel - how do I delete data but not formulae? | 26 Aug 2007 11:26 GMT | 3 |
I've got quite a complicated workbook, and have entered test data to check it. I now want to delete the test data, but not the various formulae. I think I read somewhere in a magazine that this was possible, but can't now find how. Any thoughts gratefully received.
|
| Optimum Solution for range of values | 26 Aug 2007 10:46 GMT | 1 |
Please help! I have a range of values between 1 and 20 as follows: 18 3 15 9 2 4 11 5 13 16 20 1 14 3 8 17 11 How do I use Excel/Visual Basic to determine a single optimum value in the range?
|
| How to get month wise total of a worksheet having a years data? | 26 Aug 2007 10:20 GMT | 1 |
In Excel sheet I want total of the month after 30 days of data, date wise. This sheet contains data of about 8 years date wise.
|
| Conditionally Hiding or Showing the cell content | 26 Aug 2007 07:52 GMT | 4 |
In the cells c20 to c30 I might have, or might have not some (text) data. In the adjacent cells d20 to d30 I have a formula showing me some results. I want that the formula results in cells d20 to d30 to be displayed only if there is data in the nearby correspondents "c" cells
|
| automaticly paste info from another sheet | 26 Aug 2007 07:18 GMT | 1 |
2003 Excell - I'm asking a customer what they need, expected responses are in column "B". Column A is a small box to be "X" 'd alongside the need they express (column "B"). I want my "features and benefits" from another sheet to automaticly paste to this sheet when I've placed an ...
|
| Maximum Size Pivot Table | 26 Aug 2007 07:01 GMT | 1 |
I have a pivot table set up, reporting on a data table made up of almost 12,000 rows of data. The pivot table has been working fine. Today I added more data to the data table, now bringing it to 11,990 rows. However, my Pivot table does pick up data below row 11,923.
|