So a friend asked for help with VLOOKUP. I told him what to write. and it
doesn't work. But I think it should.
We have column A full of values (hundreds of work ids) and a list in column
C of the jobs my buddy has (his 20 or sounique work ids). He wants to use
the second column to quickly lookup up those in teh first that are his.
I said to use in Column B the formula =VLOOKUP(A1,$C$1:$C$21,1) to put data
in beside each job that's his. I had him put a '-' in C21 to fill in all
the non matches.
When he said it didn't work, I made a mockup that worked. So I had him se...Multiple file problem
I have just transferred my old pst file to a new computer.
What Outlook 2003 has done is make multiple Contact and Calendar files of
each. Some have the original data in, but most are empty.
I need to know how to get back to the one file of each.
The OK files are in \\Personal Folders.
The empty ones are in something like \\Personal Folders\Draft\Draft\Draft\
There are probably 100 od the draft ones set up in the system, and they
don't appear to be deleted when I do a manual delete.
Rod <email@example.com> wrote:
> I have just transferred my o...Update to Access Multiple tables via VBA
I'm somewhat familiar with updating from Excel to Access via VBA. How
can I update to multiple tables in Access that have a one to many
relationship using VBA. Table are linked via key.
tbl_One is one Many with tbl_Two via Foreign Key
tbl_One is one Many with tbl_Three via Foreign Key
Set db = OpenDatabase("C:\LinkedTest\LinkTestDB.mdb")
' open the database
Set rs = db.OpenRecordset("tbl_One", dbOpenTable)
..AddNew ' create a new record
' add values to each field in the record
.Fields(&...Alowing for the Absence of Data from Multiple cells?
In my spreadsheet, I have those annoying #/DIV0! errors show up until
enter data in the supplying precedents. I found a great tip but i
only described a solution when there was one cell providing input t
the calculating cell. I have cells that depend on 7 or more predents.
Any help is appreciated
Message posted from http://www.ExcelForum.com
You could try
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Juan >" <<Juan.1...Adding Multiple Variables
I am using the following script to delete shares and want to specify multiple
shares, instead of just one share name. How can I do so?
DomainName = "domain.com"
ServerName = "Server1"
ShareName = "Share1"
Set cont = GetObject("WinNT://"& DomainName &"/"& ServerName
cont.Delete "FileShare", ""& ShareName &""
Also, how can I add to this script so that it deletes the directories
associated witht he shares, once the shares are re...Missing values from a pivot table field
I am creating a pivot table from an access database containing 896426
records. The issue I am running into is that on one of the fields the pivot
table is only pulling in one of two values, but the access table does contain
the second value. When I click on the arrow associated with that field it
does not contain the second value either. Is there somewhere else in the
settings this value could have been lost?
Drag the field off the table
Refresh the table
Drag the field back on.
With pivot tables you need to let us know which XL version you have. pivot
ta...how to divide the number in one cell into multiple cells
I have a value (5000) in one Excel cell. I need to distribute it into equal
values in 10 cells. Can any one please let me know how to do that
Suppose you have 5000 in cell A1 and your target cells are B1:B10.
Select B1:B10. Keeping the selection of 10 cells press = to enter a formula
Instead of enter press Ctrl+Shift+Enter...Now try changing the value in A1
If this post helps click Yes
> I have a value (5000) in one Excel cell. I need to distribute it into equal
> values in 10 cells. Can any one ple...PO Value against actual
Can RMS show what was the original value and quantity of the PO as against
the recieved value and quantity? Sometimes there are some descrepancies
between the actual PO and what was delivered. Does RMS record the difference
and show it as well?
...Subform comparison of 2 tables excluding non zero value
I am creating a subform (Access 2003/NT) in which the user will type in a
Melt# (contained in the tblChemicalResults). I need to create a side by side
comparison of the chemical requirements from the tblChemicalRequirements to
the actual results contained in the tblChemicalResults, but I need it to
exclude any non zero values from both tables. Each table contains all of the
possible 14 different metal elements that could possibly go into making a
particular part. Obviously, not all 14 go into every part, so how do I
display only the elements that have a non zero value while also display...conditional formatting: multiple conditions with min
I am using Excel 2007 and I am having an issue with conditional
formatting. I have 2 columns of data that I'm working with: Column "c"
which contains both names and some empty cells, and column "i" which
contains dates and some empty cells. If there's a name in column c
then there is definitely a corresponding date in the same row in
column i. However, there are sometimes blank cells in column c dates
that have dates in column i and some rows that have blanks in both c
and i. See the following example:
Sue --- 10/1/2010
___ --- 10/1/2010
Joe --- 10/23/2010
...Calculating percentages of number of occurence of a text value
I have a field that is called txtpurpose. The value of this field in any
record could be 4 different values " Re-financing", "Corporate Finance", "Buy-
out", or "Restructuring" For a particular month (a field txtmonth) I want to
count how many records had each of these values and what percentage that
number was of the total number or records for that month. So I want to end up
with a reuslt like this:
Corporate Finance 38%
Can someone start me off in the right direction please?
Many ...Sharing one exchange for multiple (small) company.
I need to share a new Exchange 2003 Standard (not Enterprise) for 3
organisation. Same information store, same mailbox limits, ...
Each one will have its own syntax for smtp adresses (firstname.lastname@example.org ,
email@example.com, firstname.lastname@example.org). I will organise all in OU, at least one
per organisation. How can I affect smtp adresse according to its
location is AD (OU) ?
Other question : how can I have an adresse book per organisation ? One
have not to see people of the two others.
Thanks in advance.
...Copy to specified sheet, values only
I hope someone can help me with this. I am currently using the following
code to copy the entire data from one sheet, and paste it below the previous
data in a different sheet:
Set srcsht = Sheets("Working")
Set dstsht = Sheets("All Trades")
LastrowA = srcsht.Cells(Cells.Rows.Count, "A").End(xlUp).Row
LastrowB = dstsht.Cells(Cells.Rows.Count, "A").End(xlUp).Row + 1
srcsht.Range("A1:A" & LastrowA).EntireRow.Copy dstsht.Cells(LastrowB, 1)
However, I need the macro to only paste the values, not the formulas, data...Merge data from multiple worksheets
I am using excel 2000 and have 4 worksheets in the same workbook. Each
worksheet is formatted with a yearly calendar. This is a vacation
calender for 4 different positions in my department. All 4 worksheets
are exactly the same except for the names of the people on vacation in
the cells. I would like to have a way to combine these 4 worksheets
into one without the lengthy process of creating a 5th sheet with
formulas in each cell inhabitted by names. I would prefer to have a
seperate workbook that was linked in some way. All suggestions are
Not knowing what your detail calen...Null value to "0" / Currency format
I have a crosstab query in which my columns, based on [BidType], give totals
based on the field LineTotalSellPrice. It returns the totals properly with
...however in the instances where nothing exists, it returns Null, or blank.
I'd like to convert this to a currency value of $0.00, so I changed my
...and it returns the proper value, but not in a currency format (even though
the field's format proper...Conditional Formatting: comparing cell values
Using MS 2007, I have a column that has 40 sets of three rows; the rows are
for three seperate years for 40 different schools that are included in the
The cells I am workign with show the performance indicator - a number - for
each of the three years for the school in that set.
I need to compare the three numbers for each set and show which set of three
shows gains, and eventaully determine the highest performer over the three
# SCHOOL YEAR
60 AVE 2008-09
61 AVE 2007-08
53 AVE 2006-07
69 BCE 2008-09
53 BCE 2007-08
56...Multiple recipients at one address
Is there a way to tell the database to print a different header for an
address label if there are multiple members at the same address?
I have queried a mailing but in order to conserve funds the members only
want one sent when they are at a single address. At the same time I have to
keep them as unique entries because we keep track of birthdays, etc.
We would like to keep the names on the labels of the members who live alone.
Any help is appreciated.
There is a generic concatenate function with usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. You could
us...Multiple accounts problem #2
I have multiple accounts configured in MS Outlook 2003. My main accoun
is a 3rd party MAPI account (Kerio Outlook Connector) and then I hav
some IMAP and POP3 accounts as well.
Ever since I installed Service Pack 1 for MS Office 2003, every mail
send, gets sent from my main account, regardless which account I selec
in the "Accounts" pop-up menu. This effectively means that I cannot sen
any e-mail from any account other than the main account. Before
installed sp1 I could send messages from all accounts. I hav
considered the option to reinstall Outlook without the service pack...Checking the Value of a Check Box in a Macro
I have a macro that hides a named range on rows. I also have a check box.
If the check box is checked I want an error message to display and tell the
user to clear the check boxes before teh rows will hide.
' Hide Spec_Plu_22_10_00
'Unprotect Time Sheet
If CheckBox135 = True Then
MsgBox "Uncheck boxes in spec section your trying to close.",
vbInformation, "Alert Message"
200 Range("Plu_22_10_00").Selec...Timesheet cube negative values Project Server 2007
We are using Project Server 2007 SP2. When I generate a report from the
Timesheet cube (in Excel or Data Analysis) to get the working billable and
non-billable hours per period, per task, per resource I get negative values
in the report. So far we found out the reason for the negative values is the
correction by the timesheet manager. However the corrected hours in the
timesheet are different than the hours generated in the report.
Has anyone had any issues with this? As we are struggling with this for a
couple of days now I will very much appreciate any help.
...Working with multiple worksheets
This is probably very simple but i am struggling with this. I have a
workbook where one sheet will be updated on a monthly basis and i want the
sheet preceding it to capture its outputs. A few things i need it to capture
is to check if Col B has a specific value and if yes check the value of the
cell adjacent to it and count this if it is a Yes or a No.
It sounds like VLOOKUP will work for you. Look in the help index for
Microsoft MVP Excel
"Balaji K. Arige" <email@example.com> w...After installing multiple updates, error code 0xC80001F
I have been installing multiple updates (due to computer restore). During
this last set of updates, I noticed that there were a few that said they
weren't installed (failed) successfully. I went back to the installed updates
info, but there were no items that showed "failed". When I tried to go back
to the Windows Update Home page, I received this error code [Error number:
0xC80001FE]. I do not have a 3rd party anti-virus or firewall active right
now. I have done nothing following the installation of updates.
Real integrity is doing the right thing, knowing tha...Calculate to another cell as default value
Given the following:
A B C
1 5 9 __
2 8 10 __
I'd like for the user to enter values in A and B and have Excel display B
minus A in C as a DEFAULT value. That is, for row 1, once the user enters 9
in B, I want to display 4 in C but give the user the option to override the
calculation. A formula in C won't work because the user would delete the
formula if he overrides it.
Why not use an extra column (C) and have this formula in D:
Microsoft MVP - Excel
what even old programs like Cougar has, RMS needs to address. The true value
of inventory based on either a LIFO or FIFO method. Year end inventories for
tax purposes needs to be more acurate than "last Cost" or "Weighted Average".
Average weighted cost is the accepted standard for retail. LIFO-FIFO is
impractical for most retail businesses.
"Marc Cotton" <Marc Cotton@discussions.microsoft.com> wrote in message
> what even old programs like Cougar has, RMS needs to address. The true
I would like to return the value of another cell(C1) if a
cell has a value in it, otherwise I want it to return a
value of 0. Example: IF(A1="any value",C1,0) This formula
would be written in B1. "Any value" would be numbers or
Thanks 4 your help!!!
"GaryW" <firstname.lastname@example.org> wrote in message
> I would like to return the value of another cell(C1) if a
> cell has a value in it, otherwise I...