| Thread | Last Post | Replies |
|
| Pulldown | 31 Jan 2005 05:06 GMT | 5 |
I have in the past put a pulldown in a cell, letting the user click a little downward triangle and then click a choice to populate the cell. I can't remember what this is called, so can't use the help to look it up. Could someone remind me? Thanks. Also I seem to recall ...
|
| Protecting macros | 31 Jan 2005 04:39 GMT | 4 |
I need to password protect macros attached to a workbook - not the same as protecting the sheets. All help gratefully received. TIA, Dan
|
| design form? | 31 Jan 2005 03:26 GMT | 5 |
What software should I use to design a form for listing my DVD collection? Are there templates available somewhere?
|
| if/then question | 31 Jan 2005 00:55 GMT | 2 |
Here's what I hope is a pretty basic question. I have 5 rows of inventory data. They are the following: A1: Product Name A2: Product Cost
|
| Currency Format Change In Styles-Justification | 31 Jan 2005 00:24 GMT | 5 |
Can anyone tell me how to change the currency format in the styles area to match the format in the manner as when you got to Format Cell Currency. For some reason the justification is in the affected cell is different
|
| Selecting some cells in a column for formatting? | 31 Jan 2005 00:07 GMT | 13 |
I need a macro to select cells in a user input column, only in rows where the contents of the cell in column AT (say) is X, then apply a set of formatting commands to the selection. My VBA syntax and vocabulary are too shaky for me to be confident of what should be an easy piece ...
|
| Formatting text in a CONCATENATEd sentence. | 31 Jan 2005 00:00 GMT | 14 |
Is there any way to format certain portions of a concatenated sentence? For instance, On Friday January 28th, 2005 I earned $ 100.00. Can I format the date (say bold and blue) and also format the amount (say red if it is below $ 200.00)?
|
| how to lookup value on another sheet? | 30 Jan 2005 21:56 GMT | 2 |
I'm going to oversimply my example for the sake of making my point, so please don't ask "why bother doing that?" Sheet1 has a list of product ID (SKU) values. Sheet2 has a list of *some* of those values, plus another cell that represents the cost of that item.
|
| Chart layover...transparency | 30 Jan 2005 20:44 GMT | 4 |
I need to take three different line charts and put them together and be able to simply see the plot on each one. Think of it as putting three different transparencies on top of one another for a presentation. Three different groups produced each chart but they have to do with the ...
|
| Run-time Error 7 | 30 Jan 2005 20:16 GMT | 1 |
Every time that I open Microsoft Excel 2002 (opening a blank spreadsheet), I get a Visual Basic dialog box that says "Run-Time Error 7". It does not seem to be a problem, really. I just press the "End" button in this VBA dialogue box and Excel opens just fine. It's more of a ...
|
| How do I determine if a value in one column exists in another column? | 30 Jan 2005 19:24 GMT | 11 |
I tried =IF(MATCH(A2,'Equipment Data'!A:A,0),"T","F"), but it produces "T" for all values - even if they do not exist. Thanks in advance,
|
| Can I download a free invoce/purchace orders template in Excel? | 30 Jan 2005 19:01 GMT | 1 |
Can you please help me? thanks
|
| How do I eliminate the "A" designation in column "1" and substitu. | 30 Jan 2005 18:57 GMT | 2 |
I want to substitute my own designations at the top instead of A, B, etc I want my columns labeled "Last Name", "First Name", etc. How? My chart is all finished
|
| column (a) | 30 Jan 2005 18:54 GMT | 2 |
When I change the style in column (a) a date it also changes column (b) which is hour format or style.
 Signature Wayne
|
| Vlookup problem | 30 Jan 2005 17:55 GMT | 7 |
I have two worksheets with some matching data. I'm trying to use the following formula to determine if the values in column A on WS1 exist in Column A on WS2. =IF(VLOOKUP(A2,'Equipment Data'!$A$2:'Equipment Data'!$B$9000,1),"T","F") I am getting #N/A and #VALUE responses. What have ...
|