| Thread | Last Post | Replies |
|
| A Simple Sort | 26 Sep 2007 17:16 GMT | 8 |
I think this is straight forward but I cannot seem to get it right. For example. In cells A1, B1, C3 i have three names - say Ron, Fred & George. In cells A53, B53, C53 i have thee scores - say 20, 9, 12
|
| Custom View problem | 26 Sep 2007 17:10 GMT | 2 |
I have a spreadsheet with an unwieldy number of columns, and I'm trying to use Custom View to make it easier to work with. Essentially, it is a business planning assumptions' log, with columns A-J detailing the assumption. Then, each department in the company has
|
| Comments | 26 Sep 2007 16:15 GMT | 1 |
I did some editing and now when I chose to show my comments they are all a thousand rows down. I have about a hundred of them. Do I have to straighten them all one at a time are is there someway I can straighten all of them to be with the cell they belong too. I am trying to save ...
|
| Query problem on table named 'resource' | 26 Sep 2007 16:04 GMT | 1 |
I can't execute query which is 100% right. It is accepted in different programs but not in excel (Microsoft Query) The Query is: select * from PUB.Resource
|
| IF/Hide Q. | 26 Sep 2007 15:23 GMT | 1 |
In my spread sheet, I have a fields called Amount Due. How do I hide all the rows that the Amount Due is zero? You help and knowledge is greatly appreciated. Respectfully,
|
| Cell format and lookups | 26 Sep 2007 15:14 GMT | 3 |
Hi Group, I have a time sheet which logs skills of those on duty. Cell formatting is applied to the duty skill manager to easily distinguish him on the time sheet.
|
| Macro question | 26 Sep 2007 15:06 GMT | 4 |
This is where I start Act 10 12 8 30 Bud 9 12 9 30 Trying to get here
|
| Pages with different Header and Footer | 26 Sep 2007 14:54 GMT | 2 |
I have a problem. I need to print first page of ActiveSheet with different Header and Footer then other pages in the sheet. I try to use also Visual Basic for that, but without success. Can someone help me?
|
| Full screen View in Excel (2007) | 26 Sep 2007 14:46 GMT | 3 |
I was assisted in the Word forum in recording a macro that results in being able to work with a full screen minus all the ribbons, etc at the top of the page. The macro appears as follows. The ribbons reappear after hitting the escape key.
|
| how to write formula for spreadsheet with moving row | 26 Sep 2007 14:06 GMT | 9 |
Excel 2002 SP3 Win XP HE Hi, I have a spreadsheet that automatically adds a row every day for some
|
| Macro Question | 26 Sep 2007 13:41 GMT | 3 |
Hi guys, I have an excel spreadsheet with a load of columns with various bits of data in them. Basically i am struggling to get the VB code together which will find specific entries in a specific column and then remove the relevant row
|
| total running balance | 26 Sep 2007 13:38 GMT | 1 |
I have a data with stocks (shares) purchased date and sold date Along with a price. I want to calculate my daily amount invested in stock market can someone tell me how can I see : bought entry $ sold price $
|
| Combining equal rows | 26 Sep 2007 13:10 GMT | 2 |
I have a fairly large file with about 10000 rows. I need to comine the rows with equal product numbers and add the amounts of these so that any product number only occurs once. The product description can be left out if it makes it easier.
|
| Randomly choosing a cell from a range of cells? | 26 Sep 2007 13:10 GMT | 3 |
Scenario: Worksheet A: ID CODE 1
|
| running total #N/A problem | 26 Sep 2007 09:49 GMT | 5 |
i am trying to make a stock register. I have the following row fields: Product, transaction_date and following data fields:
|