| Thread | Last Post | Replies |
|
| Delete a row if blank cell | 13 Apr 2006 16:39 GMT | 2 |
I would like to delete a row if the a cell in a column is blank. For e.g. if a cell in column E is blank I would like to delete the whole row. I would like to do this in VBA code
|
| VLOOKUP across multiple workbooks | 13 Apr 2006 16:00 GMT | 1 |
I have inherited a problem. I use Excel 2003. I work with two workbooks, both having multiple worksheets (tabs). The first workbook is the Report Master.xls. Data is downloaded from an outside service into one tab called “Input.” The data from Input is then pulled into other ...
|
| Formatting Issue | 13 Apr 2006 15:47 GMT | 7 |
I have a problem with julian dates together with identification # that come into a grid through a web query. Example: The julian date plus the id number is 101:01
|
| I need complete idiot proof excel setup database help. please | 13 Apr 2006 15:32 GMT | 6 |
I need to learn all about Excel and how to make a database.. I have read and read and done practise tutorials but I just cannot grasp the concept, it completely goes over my head everytime. I am quick to learn when I am being shown or told exactly what to do, can anyone help ...
|
| Excel Spreadsheet comes up not responding. what causes this? | 13 Apr 2006 14:55 GMT | 1 |
I have a spreadsheet that looks up the total supplies ordered and gives quarterly and monthly reports per person. The problem is that it just recently started not responding when I selected it to "UPDATE" the formulas that I have. Any idea what could cause this?
|
| Make cells flash. | 13 Apr 2006 14:29 GMT | 3 |
I need to know the ste-by-step process on how to make cells flash.
 Signature aacstv ------------------------------------------------------------------------
|
| That old #VALUE! problem | 13 Apr 2006 14:02 GMT | 4 |
I have made up a spreadsheet that has lots of cells with IF formulas but I want the result of those cells to add up as a total. However, no matter how I try, the total cell keeps coming out with the dreaded #VALUE!. All the IF formulas are fine and work well but I need them all to ...
|
| Comparing a formated result with a harcoded value | 13 Apr 2006 13:53 GMT | 3 |
I have a cell containing the numeric value. I use cell formatting to present the numeric value as which month it is. The formats value is "april" In another cell I have the hardcoded text value "april".
|
| XML Advantages in Excell | 13 Apr 2006 13:06 GMT | 3 |
I have hard about great XML futures in Excel, but I cant find any examples how to use and what are the advantages, could anyone give me some good link or some info about how could I improve my day to day task with use of XML ?
|
| How to create a new couple of worksheets with same characteristics as... | 13 Apr 2006 12:25 GMT | 2 |
I've searched the forum for a similar question but no results found. I don't know if it is possible to be done, but I will ask. Well, I have two worksheets in my workbook - the first one I use as a data base and enter my data in a few tables; the second one I use for
|
| Limits to nesting IF formula | 13 Apr 2006 10:51 GMT | 2 |
Is there a limit to how many nested IF formulas can be used? I have 11 cases I need to test for a cell but I seem to be hitting error conditions after about 8 and the error message is generic. Thanks
|
| Clipboard | 13 Apr 2006 10:01 GMT | 1 |
I've configured the clipboard to appear only when I press Ctrl+c twice. Can I close the clipboard with a keyboard shortcut?
|
| save a spreadsheet file with same name but different version | 13 Apr 2006 09:27 GMT | 1 |
We are trying to make some changes to a spreadsheet then save it back with the same name but a different version, there is an option in Word to do this but not in Excel (under File) - As there is a toolbar button for 'version history' there should be a wy to do this but we can't ...
|
| Copy- paste from Excel to Outlook Express email | 13 Apr 2006 04:54 GMT | 1 |
How can I copy-paste a row of cells containing a name, addresses and etc., from Excel to OE with the ability to work with the text once I get it into OE? I can get it over there, but it seems locked into some format with-out the ability to work with the text. Is there no way to ...
|
| align 3 concatenated strings for column appearnace | 13 Apr 2006 04:38 GMT | 1 |
I combined 3 cells to make a drop down list. However I am not pleased with the final appearance as the texts scrawls over the page. I'd like to align the text strings so that its appearance is more appealing while still using the drop down lists. Thanks for your help.
|