Combo Box- Character Look Up
Excel VBA Look Up
I have written a macro to look up data from several other worksheets.
Now I want to use that summary and create specific reports (by VP, b
fiscal year, by company). I want to use a combo box where if I selec
"Jim Johnson" from the drop down list, all items requested by Ji
Johnson will appear on the report sheet.
Any help! I tried writing the index match formula by it only return
values for the first character found.
Message posted from http://www.ExcelForum.com
Could you send soma sample data to me with info.
You can see some of my handiwork...How do I add up a column of figures? on excell spreadsheet
I am doing my accounts in an excell spreadshee and want to add the coloumn of
figures where my income is. How do I do it. Normally I would go to formula
and just say add, but it does not work the smae on my home computer. Thank
Dorothy, use sum, something like =SUM(A1:A100)
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Dorothy" <Dorothy@discussions.microsoft.com> wrote in message
news:2BA003FD-0A58-48B...Extracting a character from a string of characters
I would like to extract the 6th character (the 5) from the following example
of a string of characters e.g.B123456789.
Have a look in HELP index for MID
"Sue" <Sue@discussions.microsoft.com> wrote in message
> I would like to extract the 6th character (the 5) from the following
> of a string of characters e.g.B123456789.
If its always the 6th character use MID
i.e. if B123456789 was in cell A1
______________________...Open Excel 2002 to specific size?
Is there a way to fashion a shortcut that opens an Excel 2002 spreadsheet
so that it just shows a certain set of cells, say A1 to G17?
The user could then maximize the program, if he wanted, but all the
relevant information would be contained in that array, so there would be
You probably should use a macro once the workbook is open to resize Excel.
Excel will restore itself to the position it was in when last closed and
there is no command line parameter to override that.
...How to invoke PowerShell ISE from C# code on a specific script
I invoke PowerShell scripts from C# code. That is working fine. What I
want to be able to do is to invoke the script running in the ISE
debugger (or some other PowerShell debugger would do) so that I can
debug the script. It's not easy for me to debug the script without
invoking it from C# because the script depends on certain variables
being set up by the C# code - and also depends on calling back through
those variables to functionality implemented in the C# code to do its
I thought it might be possible when creating the runspace in the C#
code like this:
Runspac...Moving a line of data when information is entered in a specific cell.
I am trying to create a spreadsheet to keep track of problems that we
encounter at our volunteer organization.
It is pretty simple.
I am having one problem. One of my fields is "completion information."
What I need is when completion information is entered into the field, I
want that line of information to move to an "archived sheet".
In effect, so that I have a sheet with only active problems and when
the completion information is entered it moves to the archived sheet.
Anyone have any suggestions?
I have a spreadsheet that links to another and does seriosly rely on this
link but it doesn't function unless the linked spreadsheet is open. Normally
this doesn't happen. I don't really ant to open as it will then block
outother users as it is shard. Please can anyone help.
Not clear on the issue... if book 2 is open the updates appear in book 1,
clear enough. But if book 2 isn't _open_ nothing in it is being changed, so
there is no need for book 1 to update.
Can you provide a more detailed description of the problem & version?
"M...Query Help 02-02-10
I have a database which I created for schoool registration. I am wanting to
make it more simple so parents only go to one location for registration. For
example a parent has a child in the Elem School, Middle School and High
School, so they go to the High SChool they can register all 3 children in one
stop. I have the database set up with switchboards that redirect you to a
form which can hold up to 3 children. The purpose of this was to eleiminate
multiple entries so how can I fix the data base to automatically separate the
schools but still contain all the contact informati...Include comments on another spreadsheet
I have a spreadsheet that has lastname in column B. The lastname can be
repeated several times in column B. In column C are comments that I want to
I want to capture the comments on Sheet2. I have another worksheet (Sheet2)
that I want to capture all of the comments if lastname = Jones. So in other
words, if lastname = Jones and there are five comments in column C, then in
Sheet2, cells B2, B3, B4, B5, I want to put the comments.
Thanks in advance for any help I can get with this.
Here's a little more information of what I am trying to do.
If Sheet1!B2:B10...Delete query 11-07-07
Hi, can i make a "delete query", and when i start this query window appear
and type there "start date" then in another window "end date". And all the
records from this period to be deleted?? For example i want to delete all
rows which includes dates from 01.11.2007 till 04.11.2007.
Hope you understand my question:))
"Forza MIlan" <ForzaMIlan@discussions.microsoft.com> wrote in message
> Hi, can i make a "delete query", and when i start this query window appear
> and ty...Moving Parameter Queries
I have created a Parameter Query that imports transactions from an Access Database on my 'C' drive to "work out the bugs".
It works just fine, however when I move it (as well as the related dqy file and the database) to a shared network drive so that others can access it, it sends back an ODBC driver error message. I am at a loss as to how to remedy this situation without recreating the query (very time consuming) at the new location
Has anyone run into this before
Any efforts will be much appreciated
Sounds like a confused link - am assuming your query pulls
from a...adding specific "Lead Source" contact or account to Lead form?
The Lead form has a "Lead Source." When the lead source is "External
Referral" we'd like to track the actual Contact (or Account) so we can
them a thank you or special offer.
How can we create a "Lookup" attribute (relationship?) from the Lead to
Contact and put it on the Lead form for the user to select a lead
contact from the search Contacts form?
Would using the Referral field help?
Larry Lentz [CRM MVP]
MCSE+I, MCSE W2K, MCDBA, MCSA Messaging
Lentz Computer Services
Microsoft Small Business Specialist
San Antonio, Texas
Larry@LentzCo...Is there a way to query the Outlook database?
I want to extract some data from a few hundred emails I have, but each one
is huge and rather than spending the half-hour it'll take opening them
manually, searching for the tag string and then copy-pasting the value
immediately after it into Excel, is there a way to query the email database
directly using regular expressions or something similar?
Just as an explanation: I have a few hundred emails with errors in them, and
I want to extract the actual error code, but it's in different places pages
down in each email. It always says "ErrCode: [" and then the 20-digit code.
...Excel function query
Somehow i need a formula or something similar which will do the following.
Basically, i have a column (A) of cells with different dates in them (e.g.
11/10/07). I then have another column (B) with some blank cells and some
cells with numerical values in them. What i want to do is make only the blank
cells in column B turn blue if 60 days over the date in Column A passes. For
example, cell A1 contains the following date: 11/07/07 and Cell B1 is blank.
Therefore cell B1 should be blue because 60 days have passed since 11/07/07.
Hopefully someone can help, and that makes se...Reference field in Distribution Query
I am using GP10.0.
While using Distribution Query, i have selected "Refrence" (8) as one of
column. I expecting "Distribution Refrence" from General Ledger Entry should
be populated. But i am not getting it. (It is showing Blank values in Excel.
I am sure we are having Distribution Refrence in GL entries)
Can you pls. let me know, Is my understanding correct?
And also in Distribution Query how we can bring Distribution Refrence from
Distributioin reference field is available in GL10001
(GL_TRX_LINE...Finding a function call in queries
Does anyone know of a way to find if a function is being called from a query?
Another words, I have a function that might be called from 1 or more queries
in my DB and I am looking for a quick way to see which queries it is called
With over 200 queries in my DB, it will take me some time to check them
manually, and I have 2 functions to check.
Is there a utility or something that will do this for me?
On Thu, 6 May 2010 15:57:01 -0700, cherman <firstname.lastname@example.org>
>Does anyone know of a way to find if a function is being calle...Query by Form: Output to Listbox?
I have been asked to look at a database at work that has a query by form
where the user can select a table to query. There are three columns of boxes
on the form. The first column are drop-down combo boxes that allow the user
to select the fields depending upon the table selected above. The next column
of five are for the comparison operators (<,>, etc) and the third column of
five boxes are text boxes where the criteria values are typed. There is one
connector box that has two values: OR or AND.
The form works and displays the query in a table view. This is the code
behind the but...capture specific emails
Environment - Exchange 2K3 SP1 with Symantec Mail Security for Exchange
We have an ex-employee emailing people in the company.
I want to capture all emails sent from that specific address while not
blocking the email to the original recipient.
I thought about using the Message Tracking Center, but that is extremely
manual and then to dig up the emails.
On Wed, 25 Jan 2006 08:33:16 -0500, "Tom K"
>Environment - Exchange 2K3 SP1 with Symantec Mail Security for Exchange
>We have an ex-employee emailing p...Excel 2007 spreadsheet
I can't get the fill handle to show on my spreadsheet. I've gone to excel
options under advance there is a checkmark on Enable fill handle and cell
drag-and-drop, but it still will not work. I have even uninstalled and
reinstalled excel still no luck any suggestions.
...Finding repeated data in a excel spreadsheet
I have a problem with an excel spreadsheet that i need help with...
I am studying a road network and it is represented by points (nodes) and the
space inbetween these is the road.
My problem is that obviously a road goes from say point A to point B but
also back the way from point B to point A. The data i have contains both data
from point A to point B but also from point B to point A. This data is
identical and to i'd like to delete the repeated data from B to A. The
problem is that point A may go to up to 5 other locations, ie to B,C,D,E or -
as roads do at a junction. Therefore ...sql aggregate query
ID - Autonumber Field
Patientid - This can have a number of records with the same number
dDate is the date of the record and can be duplicated.
I need to create a new table with the max of date for each unique
So far not a problem.
SELECT TblCurrentEncounter.Patientid, Max(TblCurrentEncounter.dDate)
GROUP BY TblCurrentEncounter.Patientid;
But the kicker is that i need the id of the row containing the max of
As soon as i try to add ID to the query I get error about not being
part of the aggregate function.
Any ideas w...query returns with more columns than included
We've noticed on a couple of our queries that when we run the query we get
all the columns in the table. However, in design view we see that we have not
selected all columns. Anyone know why this happens???
Open the query in design view, click on menu VIEW - SQL View. Look at the
SELECT statement and see if there is something like this --
If so, then delete the TableName.asterisk or asterisk.
Build a little - Test a little
> We've notic...User Account Control : How to allow a specific app?
is it possible - and if yes how - to "always allow" a speciffic
application to be started with out the user account control window
In general I think it is ok to have this window popping up, but on some
frequently used application it is kind of bothering to always see this
>is it possible - and if yes how - to "always allow" a speciffic
>application to be started with out the user account control window popping
>In general I think it is ok...Blank characters when editing message to forward
When editing the main text body on an e-mail being
forwarded, Outlook 2002 inserts a blank characterin front
of each alteration. This then has to be removed manually
by the recipient.
How can I stop this happening.
...How protect with password the access of a spreadsheet ?
Hi. I want to know how i can protect the access of non-authorized user to
view the content of one spreadsheet of all workbook.
The reason is my company has a sales report that it can be viewed for all
user but there are 1 spreadsheet that contain confidential information (in
the same workbook) that we wan't that be watched for all user of the report.
Excel's worksheet protection is not made for this kind of security. It is
easily broken. If you don't want the information getting out, don't put it in
excel. (Or don't share that file!)