| Thread | Last Post | Replies |
|
| Data sharing | 23 Nov 2007 19:16 GMT | 4 |
I have one excel file where we insert information constantly on one desk. But we also have another person who needs to insert more information on his side on another part of the office. How can I share some columns so every time the second person needs to add
|
| Excel Formula to add stock | 23 Nov 2007 18:08 GMT | 7 |
Is it Possible to have have one target sell change one way only? For example i want to use one cell only to add stock. What ever stock arrives i just enter this number into the one cell and it changes. I have the formula configured to change the stock held when stock in and ...
|
| Graph Re-size Macro | 23 Nov 2007 18:01 GMT | 5 |
I want to be able to create a button that will automatically enlarge a graph, and then when it is pushed again will shrink the graph back to its original size. I tried doing this and the graph kept shifting to the left every time I pressed the button. I do not want the graph to ...
|
| stop entry of data that causes a negative value from a formula | 23 Nov 2007 17:30 GMT | 3 |
Excel 2002. I tried to use "Validation" on the "Data" menu but that only works on entered data. I have a formula in a cell and if the answer becomes a negative number I want it to stop the user and "force" them to fix it. I used an IF condition but that only displays a message ...
|
| Date calculations in Excel | 23 Nov 2007 17:08 GMT | 2 |
I am a very basic Excel user and I'm trying to set up a formula that will calculate a date based on me providing a "Due Date" and a "Number of Days Prior Item is Due". I also want to be able to change these fields and have the formula recalculate the date.
|
| Hyperlink to web does not return to original Excel worksheet | 23 Nov 2007 17:04 GMT | 1 |
I have an excel file which has 12 worksheets. On every worksheet there is a hyperlink to the same webpage (copywrite info). When the hyperlink is activated the first time it returns to the original worksheet but if you change to another worksheet it will always go back to the ...
|
| IF Fill Color = Green, then "G" | 23 Nov 2007 16:42 GMT | 2 |
Hi, Is this possible? I would like to create a statement saying...if the FILL COLOR of cell D1234 = Green, then type "G". Can this be done (with or without VBA)...and well, how if possible.
|
| Problems Coping and moving sheets between files Excell 2007 | 23 Nov 2007 16:37 GMT | 2 |
I am trying to copy a Excel sheet from a file to other, excel shows the following warning. Excel can not insert sheets because the destiny have
|
| Navigation of Excel 2003 | 23 Nov 2007 16:14 GMT | 2 |
I am unable to move down through the rows by using my enter/return key. Does anyone know how to adjust my settings in order that this is rectified. FYI I also had problems with tabbing however, this has been corrected by removing the tick in the Transition navigation keys which ...
|
| Trying to create an overdue message based on set dates | 23 Nov 2007 16:05 GMT | 5 |
I have a simple grid spreadsheet with a list of road names down the left and 1st cut, 2nd cut, 3rd cut etc along the top. The idea is to show how many times the grass in each road is cut. There should be one cut every two weeks and the date of that cut is then entered. What i ...
|
| Rounding up totals. | 23 Nov 2007 16:05 GMT | 6 |
I am trying to total (in cell F4) the percentage of a range of cells but with a minimum value. In cells F14:F63 I have the amounts: F14 600
|
| I can no longer edit hyperlinks via right-click menu, help please | 23 Nov 2007 15:43 GMT | 3 |
have i accidentally turned this option off somehow ?
|
| Date Questions | 23 Nov 2007 14:54 GMT | 2 |
I have two problems with the format of two different columns of dates i have coppied onto an excel sheet. I need to be able to have the dates in a standard date format in order to be able to work with them. The problems are as follows:
|
| Excel IF statement | 23 Nov 2007 14:52 GMT | 2 |
I am struggling with an IF Statement in Excel. I want to have a sheet which says if it is mon -thurs add these totals and if it is Friday add these totals together. Does anyone know a way around this
|
| Pivot table | 23 Nov 2007 14:43 GMT | 1 |
I want to display in my pivot table report data fields which have no value yet but I dont want those fields to up as "blank", instead they need to be displayed empty as in the database. How do I accomplish that ? I have tried formating them via table options checkbos for empty ...
|