| Thread | Last Post | Replies |
|
| Hide sheets using vba | 23 Sep 2006 11:41 GMT | 3 |
I have a sheet initally hidden(Contact) and the rest visiable, what I am trying to do is when today() = 1-11-06 it automatically unhides the Contact sheet and hides all the rest. I am trying to do it with having a button assigned to a macro - Having no
|
| MS Excel formula | 23 Sep 2006 07:40 GMT | 2 |
How can I fill color in one cell related to another cell values. For example: If 10>A1>0, A2 to be filled with yelow. If A1<0, A2 to be filled with red. I want to use this in a maintenance worksheet.
|
| Tab Name | 23 Sep 2006 04:28 GMT | 2 |
How can I display the tab name on a sheet? I'm looking to have a template that pulls the name of the tab that I assign and displays it in the sheet. Something similar to "&TAB" used in the Header and Footer option. Thanks
|
| hyperlinks - macro not working to take them off the sheet | 23 Sep 2006 02:18 GMT | 1 |
I asked a question earlier, and the answer was to make a macro This explains what you need to do: http://www.techonthenet.com/excel/macros/delete_hl.php Basically you have to create a macro to remove all hyperlinks at once. The
|
| Sliding Scale Percentage via IF? | 22 Sep 2006 23:58 GMT | 4 |
I'm trying to do a formula for a sliding scale percentage fee, for which it references the item price of an object. Ie: First $25.00 = 10%, $25.01-100 = 10% of first $25 + 7% of remaining price, $100.01-1000 = 10% of first $25, 7% of first $25.01-100, and 5% of remaining price, ...
|
| data entry and saves it to sheet 2 | 22 Sep 2006 23:40 GMT | 1 |
Basically I need a simpler data entry with submit button and saves it on the sheet 2. I have 2 sheets: 1st sheet would be entry fields that I would enter data on, such as:
|
| Calendar day not days | 22 Sep 2006 23:16 GMT | 2 |
I am trying to figure a way in which I can add a specified number of calendar days to a date (ex: 9/21/2006 + 14 days = Calendar date). I thought it would be an easy thing to do, but when I try what is on MS help, I get the total days from 1 Jan 1900 and can't figure out how
|
| data entry and saves it to sheet 2 | 22 Sep 2006 22:21 GMT | 1 |
Basically I need a simpler data entry with submit button and saves it on the sheet 2. I have 2 sheets: 1st sheet would be entry fields that I would enter data on, such as:
|
| Replace Help Please | 22 Sep 2006 22:08 GMT | 4 |
I have a spreadsheet with all kinds of names in one column. The names are in rows. Each of the names are for example - moving san diego, del mar moving... I want to replace each of them so that there is a " at the start and a " at
|
| Excel - Validation | 22 Sep 2006 21:52 GMT | 1 |
I'm trying to create a "drop down list" but don't know how to validate, define and/or create a source box. Trying to follow the instructions using the "help" featur, but I'm still confused. Thanks!
|
| Can I alphabetize the info in my columns? | 22 Sep 2006 21:49 GMT | 2 |
I need to alphabetize the information in my columns...I am making a chart that has book titles across the top columns and student names down the first column, I would like to have the books in alphabetical. Thanks for any help!
|
| Detect cell colour | 22 Sep 2006 21:36 GMT | 1 |
I have spreadsheets where 5 cells have general titles and have different background colours. In other sheets, dozens of cells list topics and are also colour coded to show which general title they refer to.
|
| Apologies for triple post | 22 Sep 2006 20:56 GMT | 2 |
Sorry about the triple post - I was having trouble with usenet. Janev
|
| I want to print labels from my excel document | 22 Sep 2006 20:49 GMT | 1 |
I think that my original document on excel is not set up right. When i go to Microsoft word to do mail merge wizard, my information to print labels is not showing up. Can anyone help me?
|
| how do you make the cursor position have a color ? | 22 Sep 2006 20:15 GMT | 1 |
I am trying to be able to locate when my cursor is located in a spradsheet easier by coloring the highlighted cell it is at. How do I accomplish this?
|