Using VLOOKUP to display required information

This is a multi-part message in MIME format.

------=_NextPart_000_000C_01C6D81E.1375E5F0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hey all,

I'm trying to create a spreadsheet that references an existing Excel =
file that contains data in the following format:

Supervisor    Name    Email    Phone #
Bob           Joe     a@b.com  555-555-1234
Bob           Joy     b@c.com  555-555-2345
Bob           John    c@d.com  555-555-3456
Colin         Ricky   d@e.com  555-555-4567
Colin         Roy     e@f.com 555-555-5678
Jerry         Alex    f@g.com  555-555-6789

Basically, what I want to do with this information is pull only, say, =
Colin's employees names and phone #'s, and not display anyone elses. So =
basically, I'd want it to look like this:

Colin's Employees
Name        Phone            Email
Ricky       555-555-4567     d@e.com
Roy         555-555-5678     e@f.com

I'm almost certain that the VLOOKUP command is what I want to use, but =
I'm unsure how to apply it to work in my case. I've tried a few =
different techniques such as...

=3DVLOOKUP("Colin",'[Existing Sheet.xls]Book1'!$A$2:$D$100,2,FALSE)

However this will display something like:

Colin's Employees
Name
Ricky
Ricky
Ricky
Ricky
Ricky

But will not show the other employees under Colin (In this case, Roy)..

If anyone has any idea, please save me from certain failure!

Thanks.

-Will
------=_NextPart_000_000C_01C6D81E.1375E5F0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2963" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hey all,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I'm trying to create a spreadsheet that =
references=20
an existing Excel file that contains data in the following =
format:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Courier New" =
size=3D2><STRONG>Supervisor&nbsp;&nbsp;&nbsp;=20
Name&nbsp;&nbsp;&nbsp; Email&nbsp;&nbsp;&nbsp; Phone =
#</STRONG></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><FONT=20
face=3D"Courier =
New">Bob&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;Joe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<A=20
href=3D"mailto:a@b.com">a@b.com</A>&nbsp;&nbsp;555-555-1234</FONT></FONT>=
</DIV>
<DIV><FONT face=3D"Courier New"=20
size=3D2>Bob&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;Joy&nbsp;&nbsp;&nbsp;&nbsp;=20
<A =
href=3D"mailto:b@c.com">b@c.com</A>&nbsp;&nbsp;555-555-2345</FONT></DIV>
<DIV><FONT face=3D"Courier New"=20
size=3D2>Bob&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;John&nbsp;&nbsp;&nbsp;&nbsp;<A=20
href=3D"mailto:c@d.com">c@d.com</A>&nbsp; 555-555-3456</FONT></DIV>
<DIV><FONT face=3D"Courier New"=20
size=3D2>Colin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ricky=
&nbsp;&nbsp;=20
<A href=3D"mailto:d@e.com">d@e.com</A>&nbsp; 555-555-4567</FONT></DIV>
<DIV><FONT face=3D"Courier New"=20
size=3D2>Colin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Roy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<A href=3D"mailto:e@f.com">e@f.com</A>=20
555-555-5678</FONT></DIV>
<DIV><FONT face=3D"Courier New"=20
size=3D2>Jerry&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Alex&=
nbsp;&nbsp;&nbsp;=20
<A href=3D"mailto:f@g.com">f@g.com</A>&nbsp; 555-555-6789</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Basically, what I want to do with this =
information=20
is pull only, say, Colin's employees names and phone #'s, and not =
display anyone=20
elses. So basically, I'd want it to look like this:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Courier New" size=3D2><STRONG><U>Colin's=20
Employees</U></STRONG></FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2><STRONG>Name&nbsp;&nbsp;&nbsp;=20
&nbsp;&nbsp;&nbsp; Phone&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;=20
Email</STRONG></FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>Ricky&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;=20
555-555-4567&nbsp;&nbsp;&nbsp;&nbsp; <A=20
href=3D"mailto:d@e.com">d@e.com</A></FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>Roy&nbsp;&nbsp;&nbsp;=20
&nbsp;&nbsp;&nbsp;&nbsp; 555-555-5678&nbsp;&nbsp;&nbsp;&nbsp; <A=20
href=3D"mailto:e@f.com">e@f.com</A></FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I'm almost certain that the VLOOKUP =
command is what=20
I want to use, but I'm unsure how to apply it to work in my case. I've =
tried a=20
few different techniques such as...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>=3DVLOOKUP("Colin",'[Existing=20
Sheet.xls]Book1'!$A$2:$D$100,2,FALSE)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>However this will display something=20
like:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Courier New" size=3D2><U><STRONG>Colin's=20
Employees</STRONG></U></FONT></DIV>
<DIV><FONT face=3D"Courier New" =
size=3D2><STRONG>Name</STRONG></FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>Ricky</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>Ricky</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>Ricky</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>Ricky</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>Ricky</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>But will not show the other employees =
under Colin=20
(In this case, Roy)..</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>If anyone has any idea, please save me =
from certain=20
failure!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>-Will</FONT></DIV></BODY></HTML>

------=_NextPart_000_000C_01C6D81E.1375E5F0--

0
9/14/2006 11:51:56 PM
excel 39879 articles. 2 followers. Follow

1 Replies
342 Views

Similar Articles

[PageSpeed] 56

A simple way is just to apply autofilter to your Supervisor column -
select Colin and you will just see the two employees' details.

Hope this helps.

Pete

KD Tech wrote:
> Hey all,
>
> I'm trying to create a spreadsheet that references an existing Excel file that contains data in the following format:
>
> Supervisor    Name    Email    Phone #
> Bob           Joe     a@b.com  555-555-1234
> Bob           Joy     b@c.com  555-555-2345
> Bob           John    c@d.com  555-555-3456
> Colin         Ricky   d@e.com  555-555-4567
> Colin         Roy     e@f.com 555-555-5678
> Jerry         Alex    f@g.com  555-555-6789
>
> Basically, what I want to do with this information is pull only, say, Colin's employees names and phone #'s, and not display anyone elses. So basically, I'd want it to look like this:
>
> Colin's Employees
> Name        Phone            Email
> Ricky       555-555-4567     d@e.com
> Roy         555-555-5678     e@f.com
>
> I'm almost certain that the VLOOKUP command is what I want to use, but I'm unsure how to apply it to work in my case. I've tried a few different techniques such as...
>
> =VLOOKUP("Colin",'[Existing Sheet.xls]Book1'!$A$2:$D$100,2,FALSE)
>
> However this will display something like:
>
> Colin's Employees
> Name
> Ricky
> Ricky
> Ricky
> Ricky
> Ricky
>
> But will not show the other employees under Colin (In this case, Roy)..
>
> If anyone has any idea, please save me from certain failure!
>
> Thanks.
>
> -Will
> ------=_NextPart_000_000C_01C6D81E.1375E5F0
> Content-Type: text/html; charset=iso-8859-1
> Content-Transfer-Encoding: quoted-printable
> X-Google-AttachSize: 4759
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
> <META content="MSHTML 6.00.2900.2963" name=GENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=#ffffff>
> <DIV><FONT face=Arial size=2>Hey all,</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
> <DIV><FONT face=Arial size=2>I'm trying to create a spreadsheet that references
> an existing Excel file that contains data in the following format:</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
> <DIV><FONT face="Courier New" size=2><STRONG>Supervisor&nbsp;&nbsp;&nbsp;
> Name&nbsp;&nbsp;&nbsp; Email&nbsp;&nbsp;&nbsp; Phone #</STRONG></FONT></DIV>
> <DIV><FONT face=Arial size=2><FONT
> face="Courier New">Bob&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Joe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<A
> href="mailto:a@b.com">a@b.com</A>&nbsp;&nbsp;555-555-1234</FONT></FONT></DIV>
> <DIV><FONT face="Courier New"
> size=2>Bob&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Joy&nbsp;&nbsp;&nbsp;&nbsp;
> <A href="mailto:b@c.com">b@c.com</A>&nbsp;&nbsp;555-555-2345</FONT></DIV>
> <DIV><FONT face="Courier New"
> size=2>Bob&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;John&nbsp;&nbsp;&nbsp;&nbsp;<A
> href="mailto:c@d.com">c@d.com</A>&nbsp; 555-555-3456</FONT></DIV>
> <DIV><FONT face="Courier New"
> size=2>Colin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ricky&nbsp;&nbsp;
> <A href="mailto:d@e.com">d@e.com</A>&nbsp; 555-555-4567</FONT></DIV>
> <DIV><FONT face="Courier New"
> size=2>Colin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> Roy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<A href="mailto:e@f.com">e@f.com</A>
> 555-555-5678</FONT></DIV>
> <DIV><FONT face="Courier New"
> size=2>Jerry&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Alex&nbsp;&nbsp;&nbsp;
> <A href="mailto:f@g.com">f@g.com</A>&nbsp; 555-555-6789</FONT></DIV>
> <DIV><FONT face="Courier New" size=2></FONT>&nbsp;</DIV>
> <DIV><FONT face=Arial size=2>Basically, what I want to do with this information
> is pull only, say, Colin's employees names and phone #'s, and not display anyone
> elses. So basically, I'd want it to look like this:</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
> <DIV><FONT face="Courier New" size=2><STRONG><U>Colin's
> Employees</U></STRONG></FONT></DIV>
> <DIV><FONT face="Courier New" size=2><STRONG>Name&nbsp;&nbsp;&nbsp;
> &nbsp;&nbsp;&nbsp; Phone&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
> Email</STRONG></FONT></DIV>
> <DIV><FONT face="Courier New" size=2>Ricky&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;
> 555-555-4567&nbsp;&nbsp;&nbsp;&nbsp; <A
> href="mailto:d@e.com">d@e.com</A></FONT></DIV>
> <DIV><FONT face="Courier New" size=2>Roy&nbsp;&nbsp;&nbsp;
> &nbsp;&nbsp;&nbsp;&nbsp; 555-555-5678&nbsp;&nbsp;&nbsp;&nbsp; <A
> href="mailto:e@f.com">e@f.com</A></FONT></DIV>
> <DIV><FONT face="Courier New" size=2></FONT>&nbsp;</DIV>
> <DIV><FONT face=Arial size=2>I'm almost certain that the VLOOKUP command is what
> I want to use, but I'm unsure how to apply it to work in my case. I've tried a
> few different techniques such as...</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
> <DIV><FONT face=Arial size=2>=VLOOKUP("Colin",'[Existing
> Sheet.xls]Book1'!$A$2:$D$100,2,FALSE)</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
> <DIV><FONT face=Arial size=2>However this will display something
> like:</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
> <DIV><FONT face="Courier New" size=2><U><STRONG>Colin's
> Employees</STRONG></U></FONT></DIV>
> <DIV><FONT face="Courier New" size=2><STRONG>Name</STRONG></FONT></DIV>
> <DIV><FONT face="Courier New" size=2>Ricky</FONT></DIV>
> <DIV><FONT face="Courier New" size=2>Ricky</FONT></DIV>
> <DIV><FONT face="Courier New" size=2>Ricky</FONT></DIV>
> <DIV><FONT face="Courier New" size=2>Ricky</FONT></DIV>
> <DIV><FONT face="Courier New" size=2>Ricky</FONT></DIV>
> <DIV><FONT face="Courier New" size=2></FONT>&nbsp;</DIV>
> <DIV><FONT face=Arial size=2>But will not show the other employees under Colin
> (In this case, Roy)..</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
> <DIV><FONT face=Arial size=2>If anyone has any idea, please save me from certain
> failure!</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
> <DIV><FONT face=Arial size=2>Thanks.</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
> <DIV><FONT face=Arial size=2>-Will</FONT></DIV></BODY></HTML>
> 
> ------=_NextPart_000_000C_01C6D81E.1375E5F0--

0
pashurst (2576)
9/15/2006 12:55:36 AM
Reply:

Similar Artilces:

how to use RichInk control for Mobile word
Hi all, I am trying to view the word documents in Pocket PC. I got some MFC code in the following link. http://www.pocketpcdn.com/articles/word_embed.html It is doing well for reading Pocket PC 2003 word document (.psw). I tried this to read Mobile word ( Word document for WM 5.0).It showing some same invalid data for any input. If anybody has idea on it please help me.. Thank you, Supriya. ...

Editing individual pages when using merge fields
So I am making a catalog of sorts. (Actually it is a Class Reunion book of classmates) I am merging data from a Excel database into the catalog. Each item (Class-member) is to have its own page I have set up a Publisher "form" where I have inserted the merge fields where I would normally want them displayed. My problem is some items in the database do not have all the fields filled in. The Class-members opted to not fill them in. Some will need more pictures inserted and text blocks will need to be moved to accommodate that. So, if I complete a merge and go to a page where I...

#REF Displayed
>-----Original Message----- >There are formulas, but they may be as simple as > >='C:\foo\bar\[xyz.zls]SheetX'!Y99 > >Show us the *full* formulas in the cells containing external reference links >that evaluate to #REF! or #N/A. > In the examples below, both data links access data from the same file and worksheet. One formula works, the other does not. Once I open the file the formulas link to, all formulas work. There are a total of 21 cells that link to data from the same file. 19 links work, two return the #REF or #N/A. Here's a forumla from a ...

vb6 run time error 5 when Outlook 2007 Explorer object displayed
hi all I have a vb6 program which integrates with MS Outlook and was working fine until the client upgraded their PC's - the OS stayed at XP Pro but Office was upgraded from 2003 to 2007. The app is now throwing a runtime error 5 "invalid procedure call or argument". This is difficult for me to debug as I my dev machine is W2K so I cannot install Office 2007 on it. But as far as I can tell the error is occurring when the code gets to the line myExplorer.Display - this is in response to the user double clicking a calendar item in Outlook. Just wondering is...

Search and display based on cell value
On page one. I have various full names listed throughout the worksheet in various places. When a user clicks on a cell with a name in it, I want them to be directed to sheet 2 where the same name (cell values) is found in column A. (There will be profile info starting with their name in column A.) I think the following may do what you are looking for. Right click the tab at the bottom of Sheet1 (which is what I assumed you meant by "page one"), select View Code from the popup menu that appears and then copy/paste the following into the code window that appeared... ...

Page cannot be displayed error
I can access the hotmail home page, but cannot get to my inbox. Message says " this page cannot be displayed" I have tried everything to fix - restarting, refreshing, change security setting, reset LAN settings, restore computer system to an earlier date (this would not restore to an earlier date, kept saying "cannot restore to an earlier date") delete cookies, delete temporary files, enable/disable every possible combination...Please help!!! I have spent HOURS on trying to fix this This is the Windows Live Mail forum and forum of your peers(not Microsoft) ...

outlook auto-complete and global address list issue with display n
Hi all, We have a strange issue which has started to occur with auto-complete in outlook 2003. We don't think its an outlook issue but rather a GAL issue. When someone sends an email and types in the first few characters autocomplete displays a display name similar to this - Bloggs, Joe <Joe.Bloggs00120540> This has only started to occur in the last couple of days. Anyone experienced this and found out what causes it? Thanks in advance. Hello: Does this issue happen in Outlook NON-cached mode also? Does the e-mail get delivered to the recipient anyway? ...

Form display
Hello, I have created a form in Access for users to use. My form is about 6" x 6". Everytime I double click the Access file to open, I setup the form to be automatically opened. But the Access backgroud is also displayed. Is there a way to not show the Access background? To make it more like a real application. thanks. In startup options (Tools--Startup), uncheck 'display database window'. This is for version 2003. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "Boon"...

Search information using the main form
I am making a access db with a main form and linked a subform. I can show the record by entering the primary key in the main form and the subform will show the relevant information --- that is ok! But i try to enter infomation in the other text box in main form but no action only the table content changed! ---- problem How to use the other text boxes to search the record and the result can be seen in main form and of course related record will be shown in the sub-form as using the primary key. How to prevent the content to be changed as mentioned but only after the button will created lat...

If function using cell format as the condition
I would like to create an "If" logical function formula, where the "true" condition is based on the format of the cell. For instance, if cell b3 is formatting with a fill color, then add that number; if not, then add zero. Can anyone help? That will need VBA, unless the fill colour is derived from conditional formatting (in which case you could impose an equivalent condition). -- David Biddulph "Janie" <Janie@discussions.microsoft.com> wrote in message news:25499DED-25B8-4E7D-8CA2-A22788839E56@microsoft.com... >I would like to create...

How to use the countif() function to count items in a table
I have a table contains multple columns of info as shown in the below AcctID ProjectName PMName Phase Status EIG Project 1 Wellie Initiation New MLI Project 2 John Develop Active EIG Project 11 Wellie Qualify Active EIG Project UUU John Design InActive MLI Project XX Carol Deployment Completed MLI Project YYY Carol Design Active I'd like to use the countif() function to complete the following metric such that I know how many projects for each status for each AcctID. EIG ...

What do you miss out on if you don't use Exchange?
When you use CRM3 without Exchange what do you miss out on? Antony Antony See the white paper at http://www.microsoft.com/downloads/details.aspx?FamilyId=2417E918-2E30-41DB-A3B2-2F800BF76FFE&displaylang=en Tells you all you should need to know Cozy "Antony" <info AT webpc DOT biz> wrote in message news:uxjZpqkWGHA.1192@TK2MSFTNGP04.phx.gbl... > When you use CRM3 without Exchange what do you miss out on? > > Antony ...

i cant use the sales for outlook for more than one user
i cant use the sales for outlook for more than one user (the user who install the app) in the same machine can you help me thanx "elamir" wrote: > i cant use the sales for outlook for more than one user (the user who install > the app) in the same machine > can you help me > thanx Elamir, Please note that SFO can be installed for only one profile on a system. Once you install SFO for the first time, it uses the logged users profile and thats it. Dave Banerjee "elamir" wrote: > i cant use the sales for outlook for more than one user (the user w...

Controlling display of forms
Hi, I'm trying to control what parts of a form are visible or not depending on the user of the computer. I've managed to find and adapt some code to tell me who the user is and I have a table set up with user names and a permission level (1 or 0) I can manually alter the On_Load event of my form to hide the parts I want (tabs) Can anybody help me out with putting it all together so that the forms On_Load event looks at GetUserName function which looks at the UserPermissions table and sets Visible True or False accordingly. This is taking me so long and it looks like it ought ...

Using Windows Service and CRM
Happy Holidays, All! This isn't covered in the SDK, that I can see, but we have a service running that needs to query the CRM database (using the SDK) - but it is running on an application server out side of CRM. We can do this with impersonation, using an existing user in CRM - but the password needs to be hardcoded that way - making it necessary to revisit the applicatin every 90 days... Any other thoughts on how to run a windows service against CRM? Thanks! Kristina Kristina, Ideally (and technically, legally), the service sould have it's own ID. What we've done though i...

Multi Line SOP Transaction using Integration Manager
I am using Integration Manager 7.0 to try and load a Sales Quote that has several hundred line items. I am using 2 text files as the source. The first is the header file which hasthe SOP Doc Number and other fields. The second is the detail file, and has the SOP Doc Number, item qty, date site etc. I am joining them by SOP Doc Number in the query relationships window, and checking Option 3 in the relationship type window. The destination is Sales Transactions and I am using the Dynamics/eEnterprise 7.0 adapter. (Not the SQL optimized) When I run the integration, only the first recor...

Use different formula to calculation based on conditions
Hi. It's the look of my Excel file: Item 1----Amount Category---Details: ... Item 2----Amount Category---Details: ... Item 3----Amount Category---Details: ... Item 4----Amount Category---Details: ... As you see: - A1 is the item's name; A2 is the price/amount/cost/value of the item - B1 is the category the item belongs to; B2 is the description of the item. Now I would like to do some math which are the following: 1) If the category type is income, add all of them 2) If the category type is one-off expense, add all of them & put a minus sign in front of the value 3) If the cat...

referencing a workbook using string var = error9
I'm getting a subs out of range error for the following (section taken from sub)- For j = 1 To 4 c = "dataname" & Format(j) If j = 1 Or j = 2 Then u = v Else u = "TOTAL DATA" MsgBox c 'first iter gives dataname1 as i would expect MsgBox u 'first iter gives worksheet name in v as i would expect MsgBox Workbooks(c).Worksheets(u).Name 'generates error 9 Exit Sub With Workbooks(c).Worksheets(u) 'generates error 9 .Cells(1, 1).Value = "p" .Cells(1, 2).Value = "q .Cells(1, 3).Value = "r" ...

Exchange 2000 servers using X400 as intersite protocol
We have two Exchange 2000 servers whose ExchangeMTA services are using X400 as their intersite transport rather than SMTP. How would I change this so that all servers within the network are using SMTP as the default transport? The Exchange 2000 servers are running on Windows 2000 AS SP4. The Exchange Servers are running on Windows 2003 SP1. Sounds like you're still in mixed mode for Exchange. X.400 should only be used for mixed mode communications between 5.5 and 2000 servers. When all 5.5 servers are gone, X.400 should not be used and the MTA service is no longer needed. Al ...

How to use IO Completion Port to exchange data between two threads
Hello I have heard that I can exchange data between 2 threads using IO Completion Port but MSDN had no example and I could not find a specific explanation about this. Should I create a IO Completion Port in each thread and then Read and Write to a file created by CreateFile using ReadFile, WriteFile? thanks See my MVP Tips site. The specific article is http://www.flounder.com/iocompletion.htm Simple: PostQueuedCompletionStatus to send a notification and GetQueuedCompletionStatus to retrieve it. That's all there is to it. In the case of the main GUI thread, I show how to avoid mes...

Any help using Crystal Report in MFC or anything ....
to create a report Best regard finalyvn There are several MFC sample apps on the CR website. "finalyvn" <trananhtai@hotmail.com> wrote in message news:eu6WwwQmDHA.3024@tk2msftngp13.phx.gbl... > to create a report > Best regard > finalyvn > > There is a printing support in latest version of HtmLayout (http://htmlayout.com). It is pretty easy to generate HTML programmaticly and use HtmLayout for viewing and printing your reports. Professional version of HtmLayout includes also methods for "HTML paginating". Never been easier. Andrew Fedoniouk. ...

Deleting blank records using code
I want to write a code that goes through a table and delete all blank rows. Is there a way to do this? If so, where do I get some information about it. Thanks Look in Access Help for Delete Query. HTH -- -Larry- -- "Ayo" <Ayo@discussions.microsoft.com> wrote in message news:778CBF36-D306-4BC3-9104-6994473129CC@microsoft.com... > I want to write a code that goes through a table and delete all blank rows. > Is there a way to do this? If so, where do I get some information about it. > > Thanks ...

Mail not automatically displayed in Outlook Inbox
Just Migrated to Exchange 2003. New unread messages do not display in the Inbox unless the user selects another Outlook (XP) folder (Contacts, etc) first. Any idea on how to fix this problem? Everything else runs fine. Thank you. "Melissa" <melissa@erntech.com> wrote: >Just Migrated to Exchange 2003. New unread messages do >not display in the Inbox unless the user selects another >Outlook (XP) folder (Contacts, etc) first. Any idea on >how to fix this problem? Everything else runs fine. You're having problems with UDP. The Exchange server sends a...

Outlook Mail Item Duplicate "Display Name" Problem
Dear all, I'm currently writing a Persona Menu smart tag in Outlook 2003. I use dynamic caption and intend to modify the "Additional Actions" sub-menu depending on the contact(in the MAPIFolder) that the tag is referring to. Problem occurs in the mapping of the tag and OL contact. All information I can find from the smart tag action DLL(with ISmartTagAction2 interface) is just the tagged text string from get_VerbCaptionFromID2() but not the entity object that calls the persona menu. So my way to complete the chain is to : 1) search the sender and recipients' "display...

Provides extensive information for insurance consumers
Attempts to improve public understanding of insurance -- what it doe and how it works. The site is subdivided into sections fo "Individuals" (consumer info) "Media" (press info). 'insurance' (http://www.korgnoise.net/insurance/insurance) 'car insurance (http://www.korgnoise.net/insurance/insurance/car-insurance-1.html) 'life insuranse (http://www.korgnoise.net/insurance/insurance/life-insuranse-2.html) 'health insurance (http://www.korgnoise.net/insurance/insurance/health-insurance-3.html -- Iditenax16 --------------------------------------------------...