Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / September 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
autosave28 Sep 2005 01:02 GMT2
Sent a post on autosave but can't located the right site. ???
CONVERTING TIME (DAYS) TO ONTHS,YEARS, ETC.28 Sep 2005 00:49 GMT3
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 workbook28 Sep 2005 00:41 GMT4
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 bar27 Sep 2005 23:55 GMT3
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 help27 Sep 2005 23:51 GMT1
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 GMT1
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 countdown27 Sep 2005 23:30 GMT2
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 GMT1
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 =827 Sep 2005 22:46 GMT3
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 Wages27 Sep 2005 22:32 GMT8
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 GMT2
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 worksheet27 Sep 2005 21:40 GMT4
Is there a way to display the formula on the worksheet insead of its value?
IP Address in cells27 Sep 2005 21:31 GMT2
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 button27 Sep 2005 21:06 GMT1
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 columns27 Sep 2005 21:05 GMT2
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.