| Thread | Last Post | Replies |
|
| Calculate age | 28 Feb 2007 15:53 GMT | 4 |
How do I calcuate the age of a person if all I have is their date of birth in a cell? Is this possible in excel? Thanks for your help
|
| Excel97: Änderungverfolgung | 28 Feb 2007 15:12 GMT | 3 |
kennt jemand eine Lösung, damit man auf allen PC die Änderungverfolgung beim Ändern einer Excel97-Datei automatisch aktiviert hat? Irgendwie muß ich die immer per Hand aktivieren. Also auch bei jedem neuen Aufruf.
|
| Excel 2007 Minor Problem | 28 Feb 2007 15:11 GMT | 1 |
The color palette in 2007 does not match the old palette in 2003. Is it possible to write a program to automatically reset the theme to the old default colors from Excel 2003? Is the default theme stored in the registry? If so, does anyone know the key to change?
|
| Automatically place hyphen | 28 Feb 2007 14:47 GMT | 3 |
I want to set up a column that in each row I can enter numbers, ex.123-45678-9-0 without having to enter the hypens. Is there formula that I can input that will let me just type all the numbers and automatically have the hypen in place?.
|
| Counting number of rows with Cond. Formatting to avoid save problem (KB 215783) | 28 Feb 2007 14:20 GMT | 3 |
Hi Chaps I have hit the problem where I get the following message when I save my large, old xls: "Excel could not save all the data and formatting you recently added
|
| Data sheet populating into multiple sheets | 28 Feb 2007 13:31 GMT | 5 |
I'm looking to build a spreadsheet with one main page that can be populated with data and automatically pull that data over to other more specific sheets. For example, If I have sales on the main sheet and have check boxes for more
|
| Viewing Specific Columns at Various Times | 28 Feb 2007 11:59 GMT | 4 |
I have a spreadsheet that has accounts in Column A and data in some of the rest of the columns. For example Columns B through M are month columns and Column N is Year Total. Then Columns U through AF are Year- to-Date by month and Column AG is Total Year Y-T-D.
|
| VBA Code... | 28 Feb 2007 11:36 GMT | 1 |
I want to write a VBA (Excel) code to do the following... Recognise when "Yes" is typed into any cell in column "C" on "sheet1" and then cut that row, and paste it into the first empty row on "sheet2", and finally delete the row on "sheet1".
|
| Replies with attachments | 28 Feb 2007 10:16 GMT | 2 |
When I reply to an email I cannot find the setting that allows the file to stay attached. The only success I have is to forward the email to the same person. I would like to keep files attached when I reply to something. What setting am I missing?
|
| how to change a cell color based on its content using macro? | 28 Feb 2007 07:12 GMT | 2 |
Hi, I want to automatically change the color of a cell when a user select a color from a drop-down list. For example: user selects 'green' would change the color of the same cell to green. Appreicate any help to implement this.
|
| Basic Spreadsheet Help | 28 Feb 2007 04:55 GMT | 3 |
Could some of you Excel mavens help me design a basic worksheet for the following: On a piece of paper, Monday through Thursday we record how many people come into the lab from 5-9 p.m. We make an x for each person coming in
|
| Macro to Print Similar worksheets?? | 28 Feb 2007 04:38 GMT | 3 |
My workbook has multiple worksheets with different color tabs. Is it possible to print worksheets based on their tab color?
|
| How pull data always from same location? | 28 Feb 2007 02:33 GMT | 17 |
I want worksheet AA to pull data from a set location of worksheet BB. Worksheet BB is edited by a user who may add, delete and move the rows. If I make 'AA'!A10 set to ='BB'!A10 that works fine until my user moves the data on BB to row 50. At that point my 'AA'!A10 shows a ...
|
| Trouble with simple percentage formula | 28 Feb 2007 01:56 GMT | 3 |
Just learning Excel 2003. I have the discounted amounts and need to find the dollar amount of the discount to get back to the original price. When I use the help example of =A1/B1 (A1 is 15 B1 is 0.75) I get the correct answer. Yet when I do the same formula with my numbers I ...
|
| deleting phrases in Excel and/or Word | 28 Feb 2007 01:43 GMT | 2 |
My question is for beginners but I am working with spreadsheets and documents which contains a lot of the same words I want to delete. Can anyone please tell me how I can do this? THANK YOU BEFOREHAND FOR YOUR HELP!
|