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 / New Users / March 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
determining user-defined chart definition25 Mar 2005 15:17 GMT1
How can I look at the code/description of a user-defined chart?
How do i make doctor's duty rota in the hospital?25 Mar 2005 13:22 GMT1
how do i make Duty rota for doctors using MS office.? Please help it is
difficult to make fairly distributed rota according to sequence and equal
owrking hours.
IF help25 Mar 2005 07:31 GMT1
I am building a calendar that records events by month.  For example I would
type an event in the Jan 04 cell.  I would like to have the Jan 05 cell
return the entry with an ³04² in front of it.
I am able to use the IF function to return the value in the Jan 05 cell
Vlookup from First Three Characters of Codes25 Mar 2005 04:51 GMT6
I have posted this on Excel WorksheetFunctions.
No help yet.. therefore posting it here.. Can somebody help me
Thanks
Hello All,
Property?25 Mar 2005 04:09 GMT1
In an example referenced by another posting I found a lot of code that
looks like:
Property Get ChartSeries()
   ChartSeries = CurrSeries
How do I force a reload of the workbook?25 Mar 2005 01:56 GMT1
I want to execute an occasional reload of a workbook, reverting to the last
saved version, discarding any current changes. I tried the Refresh command
from the Web toolbar but this doesn't always work - it becomes greyed
out/unavailable.
sound files in excel?25 Mar 2005 01:06 GMT1
Is there a way to put a wav file into an excel spreadsheet?  Like in it's own
cell, like how you can do with a clip art graphic?
Displaying a ratio25 Mar 2005 00:36 GMT5
Is there a way to display a calculated ration such as 14.5:1?
Example: Liabilities in cell D23 (28000) divided by Equity (25000) in cell
D28 = 1.12
How do I convert that to a ratio?  Or display it as a ratio?
insert worksheet24 Mar 2005 23:51 GMT2
How do you insert a worksheet after the last worksheet?
How do I properly attach vba code to a workbook24 Mar 2005 23:39 GMT2
I have a function and entered it into the vba editor, syntax and all is
clean, but my spreadsheet won't recognize the new command when I go to use
it.  displays #name? etc. etc. This is my first time to actually use the vba
editor, so obviously I'm missing some basics somewhere.. ...
Concananate Function for Multiple Rows24 Mar 2005 23:18 GMT4
Everyone,
I am looking to take text data from Column 1, Column 3, and add text after
these values for every row in my spreadsheet.  Is there a universal equation
that I can use instead of having to insert values from each row individually
conditional formatting24 Mar 2005 23:13 GMT1
i have conditional formatting on a cell.  the cell will turn green based on
another cells value (if it changes to 0).  so cell 1,C will be green if cell
1,F is 0.
is there a way to copy this formating and paste to cells 2,C through 20,C.
SUMPRODUCT24 Mar 2005 22:33 GMT6
Can anyone help me?
A while back Biff supplied me with a formula that found a city name in two
different counties and added them together.
=sumproduct(--(index(ilsort,,1)="chicago"),--(index(ilsort,,2)="cook")+(index(ilsort,,2) = "page"),index(ilsort,,4))
Cells don't display color - Anyone know why?24 Mar 2005 22:19 GMT3
I have a user who is not able to see the color formatting of the cells
unless he shows the worksheet in print preview mode.  For example, he'll
select a range of cells and will color them yellow.  Nothing appears to
change, however, if he does a print preview, he can see the ...
Excel will not recognise Macro24 Mar 2005 22:06 GMT4
Ladies & Gentlemen,
A small problem which is either me being stupid or Excel.
I have borrowed some code from David McRichie's site which I have then
pasted into a Module in the VBA Editor window. When I click on the Run
 
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.