Creating a new field based on conditions
I have a database that tracks insurance information for our various vendors.
Each insurance type has 2 fields - a requirement field (yes/no), and an
effective field (some show an expiration date, some are yes/no). I have
created a query that will return only the records for which insurance is
required but is expired/missing. My problem is that I want to create a new
field that is calculated based on the values in the other two fields in order
to make the resulting report more user-friendly.
For example, if GLRequired is True and GLExpiration is <Now(), I want the
new field to say...Hyperlink via indirect cell reference
I have workbook that contains a number of sheets. On a separate sheet I
would like to be able to insert a hyperlink so that I can jump to a specific
However, rather than inserting all of the hyperlinks manually (I will have
to replicate this over many workbooks) I wondered if there was a formula to
allow me to jump to a cell (say A1) in another worksheet, based on the name
of that worksheet being entered in a cell reference.
For example - a number of worksheets called "Sheet1", "Sheet2", "Sheet3",
In another sh...Exchange 2000 DST Changes
How is one supposed to address the DST changes for Exchange 2000 if
they do not have extended support to get the patch? Will Microsoft be
providing a workaround like they did for Windows 2000?
I'm referencing the following article:
It states :
What to do before you run the Exchange tool
Install DST updates
Before you run the Exchange tool, make sure that client and server
computers are updated correctly with the operating system and
application DST updates. These updates must be installed in the
1. Install the Windows DST upda...Excel, how do I change the column headings from letters to number
I have a spreadsheet that has numbered columns as opposed to the standard
letters. How can I change this back to letters?
Go to the Tools menu, choose Options, then the General tab.
There, uncheck the R1C1 reference style setting.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"lazybee" <email@example.com> wrote in message
>I have a spreadsheet that has numbered columns as opposed to the
> letters. How can I change this ...how do i change tick marks of excel graph from vb.net
I'm trying to change using VB.NET the tick marks from their default outside
position and place them inside the graph. How can this be done?
...How do I freeze or lock cells to show up on each page without typ.
I have a 4 page sheet. I have a header already. But I want to freeze the
cells that head up the first page. I've done it before in school but can't
remember what it is called or how to do it...that's why I'm doing this.
Anyway, I want these cells to print off on each new page without having to
type them on each page. I hope that makes sense and I hope that someone can
If you mean for printing do file>page setup>sheet and select rows to repeat
otherwise for viewing you can select a2 if the headers start in row 1 and do
window> freeze panes
...font in outlook 2003 reply
when i reply to an email with plain text my reply is in plain text
eventhough my setting for replying and forward is set to arial 10. my
email editor is msword 2003 sp3. how do i fix this?
Fix what? That is the intended behavior. Outlook replies with the same
format the sender uses. That is considered common courtesy. You can override
it manually if you think that's what the sender wants you to do.
"nlehrer" <firstname.lastname@example.org> wrote in message
> when ...Rename Cell
How can I rename column A to read "bills" instead of the letter A?
You can't. The closest you will get is to hide column headings, via Excel
Option, and then create your own.
"shoe" <email@example.com> wrote in message
> How can I rename column A to read "bills" instead of the letter A?
you cant change the headers or row labels but you can define you data as a
list (or table) and the headings can then be used to refer...Trying to create an Update query based on HR data to find upline V
Hi All, looking for some advice. I have an HR table that contains employee
information but does not contain management chain info. Basically i am trying
to determine who the employees upline VP is. The fields i have to work with
are [Employee Name], [Manager Name] and [Job Title]. I figure the logic would
be to check the employees' manager and if the manager is a VP (based on job
title), return the manager's name to a field called [VP]. If the manager is
not a VP then check that manager's manager, so on and so forth until a VP is
Any ideas would be much appr...Create static text from cell reference
I have two columns of text which I'm combining in a third column using the
formula (for C1, for example) =A1 & char(10) & B1
This gives me the contents of A1 on a line above the contents of B1 and
What I NEED to do is somehow create column C as TEXT, not as a REFERENCED
data from columns A and B. How do I create a cell that contains the actual
TEXT content of another cell instead of a REFERENCE to the other cell?
Select all the cells in "C" that have content. R-click them and select
"Copy" then r-click again, sele...merging 2 cells without losing data?
How can I merge 2 cells without losing data from the other cell?
Not possible I'm afraid. Try placing the dat from both cells into one
and use "Center across selection" under Format>Cells>Alignment
Merge cells always end up causing grief. they are best avoided.
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
"bob" <firstname.lastname@example.org> wrote in message
> How can I merge 2 cells without losing data from the other...Changing Item #'s
Is it possible to change the item #'s after the item has already been entered?
No there isn't in the "base" product, but MBS does have a tool that you can
use called Item Modifier - this will allow you to change an Item number from
one value to another.
You can email this address below and they can answer any questions you have
about the tool and can tell you what the cost of it is.
Hope that helps you out,
> Is it possible to change the item #'s after the item has already been entered?
...Cell Format #4
Is there a way to have a cell format based on contents of an i
if(C1="Input",and(C3,Format $#.##),if(C1="% of Revenue",and(C5,Forma
I want the If statement to test a condition, return contents of th
correct cell and format automatically.
Any help is appreciated
bforster1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1177
View this thread: http://www.excelforum.com/showthread.php?threadid=26133
You can't change the fo...Getting contents of adjacent cells
I want to divide the y1-axis column and save it to radius (y1/2) column. How
do I do that?
x-axis y1-axis radius(y1/2)
0 0.00 8.0000
1 0.25 8.0242
2 0.50 8.0691
3 0.75 8.1281
4 1.00 8.1989
5 1.25 8.2803
6 1.50 8.3716
7 1.75 8.4729
8 2.00 8.5832
divide the y1-axis by what?
2 as an guess with y1-axis in column c
in the y1/2 column(d?), enter
> I want to divide the y1-axis column and save it to radius (y1/2) column. How
> do I do that?
> x-axis y1-axis radius(y1/2)
> 0 ...How to sort calendar entries on "size"
I would like to remove large size calendar entries by
being able to sort on "size". I am able to sort Inbox
items on size but not calendar. My company's exchange
server has email account size quota and a 3rd of that
quota is being held up by calendar entries on the server
side, so I would like to get rid of the unwanted past
celndar entries that occupy portion of my account quota.
Any help is appreciated.
On 11/18/03 9:21 PM, in article email@example.com,
"Umesh" <firstname.lastname@example.org> wrote:
> I would...Using atl based win dll with CString functions from the mfc projec #3
I have atl based general windows dll with class which contains functions
which uses CString as parameters or return values. This dll might be used
from the atl or mfc project. Dll can be used from ATL project without
problems but whenever I try to use this class from the MFC project I get the
following linker errors:
error LNK2019: unresolved external symbol "__declspec(dllimport) public: int
__thiscall MyClass::AddMenu(long,class ATL::CStringT<wchar_t,class
StrTraitMFC_DLL<wchar_t,class ATL::ChTraitsCRT<wchar_t> > > const &,long)" ...
If I replace CStri...Getting font properties
I have a LOGFONT - complete with all desired properties including face name.
I use CFont::CreateFontIndirect() to create a font.
If the font I have specified is not available on my machine then it uses the
nearest available in some appropriate sense.
So far so good.
But CFont::GetLogfont() just returns me the LOGFONT which I used to create
the font, and not the one it actually adopted - in particular as regards
Is there an easy way to get the face name of the font it actually used?
Author MOZART the music processor for Windows -
http://www.mozart.co.uk...cell selection gone crazy on Excel 2003
All of a sudden the mouse is acting like it is held down, and will not stop
selecting cells. Have tried double clicking, playing with the Function keys,
all sorts of things, but to no avail... don't want to force quit.
Any clues? TIA, Geri
See David McRitchie's notes at:
"Tweedie-Vaughan" <Tweedie-Vaughan@discussions.microsoft.com> wrote in
> All of a sudden the mouse is acting like it is held down, a...Sum amount if = 2 value's
I have a spreadsheet of payment types for which I want to sum the tota
amount per type per month
A B C
Type Amount Month
I'm able to get the total amount per type by usin
=SUMIF(A:A,"TYPE",B:B), but can't work out how to get a total for eac
type each month
Somthing along these lines: =SUMIF((A:A,"TYPE",B:B)&C:C,"MONTH")) ????
loscherland's Profile: http://www.excelforum.com/member.ph...Average of logic cells
I used a logic test to determine some levels from raw scores. For EG
>120 =5, 119-110 = 4, etc. I now want to dtermine an average score of
several of the the results from the logic tests but it doesnt seem to
work. (AVG does not recognise cells with logic tests) Can anyone help,
ckdkvk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29245
View this thread: http://www.excelforum.com/showthread.php?threadid=489704
hi, ckdkvk !
> I used a logic test to determine so...Formatting Linked Cells
I have a project to do. I have to create an input worksheet that is the originator of other worksheets that are linked to the input worksheet. Is there a way to have the linked cells shown as a blank cell if the data (especially text data) is not enter in the input worksheet yet.
(Don't use my reply address - it's spam-trap)
"MT" <MT@discussions.microsoft.com> wrote in message
> I have a project to do. I have to create an input ...Cell References..
I have a 12 month rolling report with a seperate worksheet within th
workbook which refers to the column containing current month's Numbers
When I "Cut" Column C (which contains the oldest Month) and "insert
column C between N & O it shifts my cells left and all I need to do i
input all of the current Month Data into Column N. The formulas al
remain intact and everything is peachy. Until I goto the Workshee
that refers to the Current Month on the 12 month rolling report.
My problem is that when I shift the columns on the "Report" workshee
it chages the cell...Use a VBA Macro inside an Excel Cell
This is a multi-part message in MIME format.
its been helpful to me so maybe it will do good for you too:
how to create a simple macro within Microsoft Excel, and then how to use =
that macro to calculate a single cell value.
&l...IF statement based on True/False that activates a certain list box
I've been asked to create a formula that will react to either "yes" or "no"
entered into a cell which will show options in another cell based on a
Cells D3:D5 contain the values Monday, Tuesday, Wednesday (list named BegWeek)
Cells E3:E5 contain the values Thursday, Friday, Saturday (list named EndWeek)
Cell A3 accepts either "yes" or "no" entry only from a list
If A3 = "Yes" then B3 will = drop down list BegWeek
If A3 = "No" then B3 will = drop down list End Week
I don't even know if thi...Changing named range reference depending on a cell's content
Where to start?!
I've got the following formula pulling data in from a secon
spreadsheet within the same workbook:
We have 8 different locations ("MICH" being one of them) that we nee
to be able to access. I can write a nested IF formula that looks a
cell I7 (that contains a list of all 8 locations) and, depending o
I7's content, brings back the desired values.
I was hoping someone in the forum could help me write a simpler formul
that would not have 7 IF statements embedded in it.
Any help w...