| Thread | Last Post | Replies |
|
| Conditional Drop Down Boxes | 29 Aug 2007 22:38 GMT | 1 |
I am trying to set up a worksheet for a pipeline report. I need to set up Conditional Drop Down Boxes that are contingent upon the drop down Choice in a previous Drop Down Box. The problem is that I have to set up more than one Dependent Drop Down Box for the same master Data ...
|
| Please help. Remove dups automaic of same name,price,month. | 29 Aug 2007 22:24 GMT | 6 |
I have a spreadsheet called Book1 with 2000 lines. Where there is a dup in rate , name and month I want to remove the dup lines from the spreadsheet. Keeping just one line. If the price is diff but same month, name and rate i want to keep in the
|
| Attaching Macro to Cell instead of button? | 29 Aug 2007 22:20 GMT | 2 |
I have a cell that is a list. Instead of attaching a Macro to a button, I would like it to run everytime a new selection from this list is selected. Is this possible? If so, how? Much thanks!
|
| VBA/Excel help - Coding ComboBoses...... | 29 Aug 2007 21:57 GMT | 2 |
Perhaps someone can help me.......... I have the following code written in VBA. Private Sub SupervisorComboBox_Change() Sheets("Sheet2").Range("C1") = SupervisorComboBox.Value
|
| erase page #1 | 29 Aug 2007 21:34 GMT | 1 |
how do i erase the large page "#1 in the middle of the spreadsheet
|
| Insert blank column every other column | 29 Aug 2007 21:05 GMT | 2 |
I have many columns with data A:ACW and I would like to insert a empty column between every other columns so i could enter data. is there any way i could run a macro to do that? thx.
|
| Hyperlinks won't work when file is viewed in email | 29 Aug 2007 20:54 GMT | 2 |
I have a hyperlink to another file in an Excel workbook, which works fine when opened from within Excel. However, if I send the email as an attachment and a user opens and views (doesn't save) the email, the hyperlinks won't work. Any idea why? Thanks.
|
| Linking Cells | 29 Aug 2007 20:28 GMT | 1 |
When linking cells from one tab to another, where the cell from the source cell is blank, the return value shows a 0. How can I get that to be blank as well? Same issue with dates, when the source cell is blank, the date returned is 1/1/1900. I need a blank there as well.
|
| Selecting Page Tabs | 29 Aug 2007 20:24 GMT | 2 |
Is there a keyboard shortcut to selecting page tabs (sheets) in Excel?
|
| Problem with dates in excel | 29 Aug 2007 20:14 GMT | 9 |
I have been working on a spreadsheet for a couple of months now and in the past two day I have begun having a problem when entering the date in to a cell. Everything was working fine
|
| conditional formatting max | 29 Aug 2007 20:07 GMT | 13 |
I am using excel 2003 and would like to use conditional formatting to highlite the 120 day column with the highest % for each site regardless of month. For example for Phil it would be 98.16, for Mech it would be 96.42. Any help would be much appreciated. Thanks.
|
| Building criteria string for Advanced Filter variable not resolvin | 29 Aug 2007 19:52 GMT | 1 |
I am building a criteria string for an Advanced Filter feature. The string values exist in a spreadsheet. I need to prepend ="= and append a trailing quote. When I do the varialbe myCriteria does not resolve. Here is the code snippet:
|
| Add-in files filling up My Recent Documents - Excel 2007 | 29 Aug 2007 19:48 GMT | 1 |
Recently upgraded to Office 2007. After I activated a few Add-ins in Excel, the add-in files (*.xla and *.xlam) appear in Start=>My Recent Documents, which basically renders "My Recent Documents" useless since it happens every time I start Excel. Any idea how to correct this ...
|
| Insert symbol in front of value | 29 Aug 2007 19:46 GMT | 3 |
I have a basic formula of =Sum(J2-I2) for an entire column and I am needing a specific format. If the sum equals a value greater than the value in cell J2 place a + sumbol in front of that value.
|
| Asynchronous call (macro) | 29 Aug 2007 19:41 GMT | 1 |
I want to execute 2 subs (Macro1 and Macro2) at the same time, how can I do it? I don't want to wait for the end of Macro1 to execute Macro2
|