| Thread | Last Post | Replies |
|
| autosave | 28 Sep 2005 01:02 GMT | 2 |
Sent a post on autosave but can't located the right site. ???
|
| CONVERTING TIME (DAYS) TO ONTHS,YEARS, ETC. | 28 Sep 2005 00:49 GMT | 3 |
Hello, Gurus: I have multiple licenses (potentially 50+), each one with an expiration date. I have a sheet with expiration date column and another column with the difference between expiration date and current date. The
|
| Delete Define names across workbook | 28 Sep 2005 00:41 GMT | 4 |
I have a workbook with about 35 or so tabs. What happened was that on the first sheet, I named a cell "pe" and then copied that worsheet about 30 times or so. Each worksheet has a different set of data. The problem is that each worksheet now has a cell named "pe". I only ...
|
| Display the results not the formula in the task bar | 27 Sep 2005 23:55 GMT | 3 |
How do I display the results of a function in the task bar. I have set up a function from three adjacent columns the results are displayed in a fourth column but I would like to remove the function whilst keeping the results in column 4 how do I do this?
|
| radio button help | 27 Sep 2005 23:51 GMT | 1 |
What I want is if the radio button (named "VolorInvol") is selected, it performs the formula in the cell, if the radio button is not marked I want the cell to be blank. Here's my code but it doesn't work, what am I doing wrong?
|
| I need to protect cells that contain formulas but on a huge scale. | 27 Sep 2005 23:34 GMT | 1 |
In Excel, I need to protect cells that contain formulas but for thousands of files and sheets. The real trick is being able to go back into these files and allow macros to operate properly while under protection. Any suggestions? Thanks
|
| real-time countdown | 27 Sep 2005 23:30 GMT | 2 |
Can anyone help me out making a real-time countdown clock. What I' looking to do is make one that counts down the months, weeks, days minutes and seconds until it is time for me to leave the desert. W are novices with excel but are pretty sure that we could muddle throug
|
| AutoSave: How can I get it to save every 5 minutes & NO prompt? | 27 Sep 2005 22:53 GMT | 1 |
Have read several good answers regarding AutoSave but can't get mine to make any changes. Using WinXP PRO - O.S. and brought the AutoSave in from W/2000 Excel/ Works good / BUT it's set for 10 Minutes and "Prompt for Save". Want to change it to save every 5 minuters and NO ...
|
| i want to calculate the houers of workers 21:00 - 05:00 =8 | 27 Sep 2005 22:46 GMT | 3 |
i just want to put the time a worker come and the time he go and to have the number of houers he worked
|
| Amount of Increase of Wages | 27 Sep 2005 22:32 GMT | 8 |
I am trying to write a formula to calculate a annual amount of increase of wages. For example: I have a list of Current Wage rates. I also have a list of proposed wage rates. I want to take the difference between the two
|
| Can a date be used for conditional formatting? | 27 Sep 2005 21:42 GMT | 2 |
I have a spreadsheet like the following Date of call, Cust name, a/c no, amount, date due in, date for follow up, amount What I am looking for is on the date due in is for the cells to chage colour
|
| How do I display a formula on the worksheet | 27 Sep 2005 21:40 GMT | 4 |
Is there a way to display the formula on the worksheet insead of its value?
|
| IP Address in cells | 27 Sep 2005 21:31 GMT | 2 |
I want to copy a range of IP addresses thusly: In column 3 is the 3rd octet. In column 4 is the 4th octet. The first two octets are static. I want to append the first two octets with the 3rd and 4th, row by row. What is a formula that will accomplish this?
|
| How do I delete a drop list button | 27 Sep 2005 21:06 GMT | 1 |
An input worksheet referes to a vlookup list on another worksheet. One input cell has a drop list that shows the vlookup list for selection purposes. I have deleted the vlookup list but cannot delete the drop button.
|
| macro to hide columns | 27 Sep 2005 21:05 GMT | 2 |
My spreadsheet has data in cells A1:G20. I would like to create a macro to hide columns D, E, F&G. Similarly, I would like to create a macro to unhide the same columns. I appretiate your help with code to do this.
|