Compare Last name in Column to Business Name in another column
I have 2 columns:
Column A is "Last Name"
Column B is "Business Name"
I would like to indicate in Column C if the last name is locate
anywhere in the Business Name column. For example:
Column A = "Smith"
Column B = "Smith, Varney, Ross Insurance Inc."
Column A = "Smith"
Column B = "John J. Smith, M.D. LLC"
Either of the above would give a match and need to be indicated in
third column with text like "Matched" or something similar.
I'm sure this is a simple text string comp...Workbook name as variable to another workbook
Can you save a specific workbook name as a variable, to be used in a
different macro? i need the variable to be saved and available to return to
the specific workbook open if i have a lot of books open to complete the task.
Dim myWkbkName As String
myWkbkName = ThisWorkbook.Name
If you execute runmefirst first, then runmesecond, you'll see that myWkbkname is
available in the second.
If you need to put the routines in different modules, declare myWkbkName as
Publ...using the same name reference in multiple worksheets
Dumb question, but I can't seem to get it to work...
2 spreadsheets ...
In spreadsheet 1 (Year 2001), in formulas within that spreadsheet
refer to, say, "Total" as ='Year 2001'!$10:$10.
In spreadsheet 2 (Year 2002), in formulas I refer to "Total" ='Yea
But I can't seem to use the "Insert/Name/Define" function properly s
that 2 ranges in separate worksheets refer to the same 'name' (if the
were the same line, ie. both line 10, I would be fine).
Any ideas, arghhh...
-------------------------------...Dynamic Offsetting, Names, Arrays, Range, Chart Values. NEED HELP
I would like to enter values into a Chart from a Named Array(Range).
The Array should not be an actual Range, but a virtual array based on logic
applied to a Range.
In my case picking values in ColumnB based on values in ColumnA
Ideally I woud like to write something like:
and then make a Chart out of it.
(I actually want to do something more complex: a variable-width bar chart
using an X/Y scatter, w/o using Bullen's method)
My problem is that ONE offset is applied on the whole array, and not
DYNAMICALLY to the different items.
I receive mails without the attachents. instate i get (see below) as
attachment. How do i fix this and see my attachment.
name="Notulen statuten 26-11-02.doc"
filename="Notulen statuten 26-11-02.doc"
etc etc etc ...
What version of Outlook?
Milly Staples [MVP - Outlook]
Post all replies to the group...Access the "automatically suggest a name to enter" data ?
When typing in a name in a new e-mail, Outlook automatically suggests a
name to enter, and I like this.
However, I have many in there that I would like to add to my contacts.
At present I do not want to type in "a" and then sellect one, then add it to
my Outlook contacts etc and then repeat all they way through to "Z"
Other than doing this ONE at a time, is there another way?
You can't even add them one at a time the way you suggest. You can only add
your autocompletion cache to your Contacts using third party software.
http://www.ingressor.com/deskt...reading another cell to place 4 amount
I am trying to add a formula that will figure out a dollar amount.
cell a1 has the number 12 in it
I want cell b1 to say $100 if cell A1 is between 12-14, if not i
should be zero.
thank you in advance,
Message posted from http://www.ExcelForum.com
"manickmj >" <<firstname.lastname@example.org> wrote in message
> I am trying to add a formula that will figure out a dollar amount.
> exampl...Populate read-only form from SQL stored proc
I'm trying to open a recordset from a stored procedure and read the rs to
populate my form but it keeps telling me that the rs is closed.
Set rs = cnnBE.Execute("exec dbo.uspGetBalance 1, '2007-1-1', 1")
Do While Not .EOF
and it does not work.
However this works...
cnnBE.Execute "exec dbo.uspGetBalance 1, '2007-1-1', 1"
Set rs = cnnBE.Execute("SELECT * from tbltmpLastID WHERE UserNo = 1")
...Excel 2003 . . . Can't Delete Corrupted Defined Names
I have an Excel workbook that I created way back when I was
using Win 95. I used it for the years I had Win 98, and
now I'm using it under Win XP Pro. My problem is that long
ago two of the Defined Names apparently became corrupted,
and I want to delete them. When I click the Delete
option, it goes smoothly, but the names remain unscathed.
One name has a definition that refers to a non-existent
workbook, and the other contains a #REF! in it. How can I
make them go away??
try the following add-in to find/delete these links:
http://www.bmsltd.ie/DLCount/DLCount.asp?file=FindLink....Reading DBF files in Excel 2007
I noticed that some people were having issues that Excel 2007 does not
read/write dbf files. I might be wrong - if so - please ignore this.
I have written a simple vbscript to read dbf files. It is not perfect
yet (needs work on typing). I have almost finished one for writing as
Here is the reading script's URL:
...Name could not be resolved
I want to add one more profiles in Outlook but encounter error saying
"The name could not be resolved". Existing profiles on that computer
work fine. I tried to add the profile to another computer and it
worked there also.
Seems the problem is just happening on the first computer. Network
connection works fine, internet access, server access, both work
Did anyone meet this problem? Any solution? Thanks in advance.
...underscores in the server name--affect on BP
I read somewhere that the server that you use for Business Portal 4.0 should
not have underscores in its name. Our internal IT staff set up a server for
me to use today to install MOSS, BP, etc. on it. It just dawned on me,
though, that this test server has two underscores in its name.
Is this really going to be a problem? Is there any sort of remedy? I don't
suppose renaming the server is an option, huh?
It's a bug or a fix depending on how you look at it.
Check out this link and it should answer your question. My gut tells me if
you type in the h...Mixing Local And External mail Accounts on same domain name
Please can any one help.
Our local mail accounts are email@example.com. These are picked up from
our ISP using the POP3 account ourdomain.co.uk, however we have some
external mailboxes at our ISP for external users
How do I get exchange to send to the external mailboxes. Currently, the
system thinks that the external mailboxes1-20 are local and do not exist. It
sends me an error message back.
I have a SMTP Connector with a smart host specified but it only seems to
relay messages with domains the system knows are not local.
Thanks for any resonses in advance,...Create a lookup in Contacts for Account Name
I have three fields in my contacts form that relates to Account Names,
but not the parent account name. Is there a way for me to create
lookups on the Contact form and map them to my three custom
attributes? I am not opposed to creating a new custom entity if
In you case, you are looking to create 3 additional relationships to
Account, which would then add the needed lookups. Unfortunately, in v3,
there is not supported way to create multple relationships between entities.
MVP - Microsoft CRM
<firstname.lastname@example.org> wrote in message
n...Changing outlook reading panel fonts
One of my clients has a worker with very poort vision, he actually qualifies
as legal blind, but retains enough vision to be able to use a computer, with
a TV sized monitor on his desk.
He find it much easier to read serif fonts, and so would like to change the
font in the right hand reading pane in outlook 2004, and the reading pane
when a message is double clicked to open the e-mail in it's own window.
I can see no place in the menus to do this, can it be done using VBA ?
news.tpg.com.au <email@example.com> wrote:
> One of my clients has ...Getting the Database name from a _ConnectionPtr
I need to get the full database name from a _ConnectionPtr (in ADO)
is this possible?
I'm using VC++ 7.0 and MDAC 2.7
Crossposted to: microsoft.public.vc.mfc,microsoft.public.vc.database
Replies will go to: microsoft.public.vc.database
...Read/Write binary file data to/from string
I have not much experiance in reading/writing binary of files.
I would like to read the binary data of a file into a string.
It would nice to have it as string because I need to store it.
After this I would like to create a new file from this binary string data.
Is this possible ??
Thanks and best regards
"Frank Uray" <FrankUray@discussions.microsoft.com> wrote in message
> I would like to read the binary data of a file into a string.
> It would nice to have it as string beca...Need to change the resource in S. Chinese
Our application support in different languages, Chinese is one of
them. I was adding few Chinese strings, I received in Word document,
to exiting Chinese resource string table. In resource editor I can
clearly see the strings in Chinese but when load chinese resource DLL
everything looks in question mark (?). I've changed the language to
Chinese in Control Panel. If I do the modification on other machine
then it works fine.
I'd highly appreciate any help here.
You must tell us more about your context.
Is your app Unicode enabled?
Which version of V...Named range in workseet code
I am using XL2003
This is a follow-on from a previous post.
I have the following (meaningless) Worksheet Window macro:
Private Sub Worksheet_Activate()
If the named range (CompNames) is on the sheet being activated, the code
If the named range is on a sheet other than the one being activated, I get
the following error:
Runtime error '1004'
Application-defined or object-defined error
If the code is put into a normal macro in a module, the error does not occur.
With Range("Comp...change column names to letters
Normally column headers have names using letters and row
header has names using numerals. In my excel numerals are
used to define both columns & rows headers.
Normally you have A1 cell, and I have R1C1.
How can I change to normal headers, so that Columns header
would consist of letters, and rows header consist of
Thank you very much.
Tools>Options>General, uncheck R1C1 Reference style
Microsoft MVP - Excel
"Raimundas Dundulis" <firstname.lastname@example.org> wrote in message
news:01e601c3a7b9$657d6190$a301280a@phx....How do I read saved email from Outlook Express
I saved my emails and address book with Outlook Express before getting a new
computer with Outlook 2003. Outlook 2003 will not read those files. How can
I recover the information?
Clint <Clint@discussions.microsoft.com> wrote:
> I saved my emails and address book with Outlook Express before
> getting a new computer with Outlook 2003. Outlook 2003 will not read
> those files. How can I recover the information?
You have to configure those messages into Outlook Express on the new
computer (see http://www.insideoe.com/ for the method) and them export them
to Outlook from ...Creating folder names from column data in excel
I have a list of names in excel, approx 500 long. I need to create a folder
for each one. How do i do it automatically?
You would use the MkDir statement to do that... it requires you specify the
full path as its argument. This is the description provided in the help
"Creates a new directory or folder.
Syntax: MkDir path
The required path argument is a string expression that
identifies the directory or folder to be created. The path
may include the drive. If no drive is specified, MkDir
creates the new directory or folder on the curren...font size of row and column names
How do I change the font size of the 'A, B, C.....' column headers and
the '1,2,3...' row names? and set my changes to be the standard?
Message posted from http://www.ExcelForum.com/
This font is based on the Normal style, so select Style from the Format menu
and then change the font for style name "Normal".
"The Grinch >" <<The.Grinch.email@example.com> wrote in message
> Hi All,
> How do I change the fo...macro to create charts in worksheets with arbitrary names
I'm trying to write a macro to create and modify charts in
spreadsheets with many worksheets. The problem I cannot
solve is that the macro uses the current worksheet name
(here Channel_1) in the code, as in the following short
' Keyboard Shortcut: Ctrl+a
ActiveChart.ChartType = xlXYScatterLinesNoMarkers
which prevents it from ru...Name Box Information
Is it possible for me to input the worksheet names that I have into the Name
Box next to the formula bar, such that it creats a pull down menu that will
allow me to move between the worksheets instead of scrolling around the
There is already a menu.
If you right-click on the arrows to the left of the sheet tabs, you will see
the menu of sheet names.
(remove nothere from the email address if mailing direct)
"ohpspe" <firstname.lastname@example.org> wrote in message
> Is it possible for me to inp...