i need to check a row for data and if that data is their i need to the
check the next row and if the data isnt their then i need to put th
data in that range
i know how to add the data using VBA but i dont know how to check tha
row for the data and if it does exist i need to goto the next row
Hope this helps,
Message posted from http://www.ExcelForum.com
for each c in selection
if c="mydata" then c="mydata"
"boris2004 >" <<firstname.lastname@example.org> wrote in me...Do we need to install active sync?
We have Exchange 2003 Sp2 frontend and backedn servers. I enabled the
mobile function in the global seetings. BTW, do we still need to install
active sync in the server ot workstaions?
Sally <Sally@discussions.microsoft.com> typed:
> Hi all,
> We have Exchange 2003 Sp2 frontend and backedn servers. I enabled the
> mobile function in the global seetings. BTW, do we still need to
> install active sync in the server ot workstaions?
You don't install ActiveSync deskt...HELP: Handling WM_SHOWWINDOW when window opened SW_SHOWMAXIMIZED
I've verified that the WM_SHOWWINDOW handler OnShowWindow() is not
called when ShowWindow is called with SW_SHOWMAXIMIZED. I created a
dummy MFC app (doc/view and no doc/view) and reproduced the behavior.
So, here is what I have (simplified)...
MFC app with no doc/view support.
// Not called when m_nCmdShow == SW_SHOWMAXIMIZED!!
This seems to be the designed behavior. Does anyone know why? What
message can I handle in this case to know when the...IF statement help #2
What im trying to do is,
Calculate a Cell x say 0.5. If the result is a negative number, sho
0. If it is a positive number, work it out and show the answer. Jus
tried, and cant seem to get it right for some reason. I dont want t
have to use another cell for no reaon, as I need to present th
This is what I tried, IF((E22*0.5)>0), (E22*0.5),
RudeYute's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3295
View this thread: http://www.excelforum.com/showthr...Lookup a range of numbers
I have a table as follows:
(Dist) 64k 128k 256k
5 1000 1200 1500
10 1600 1700 1800
15 2000 2100 2200
I'd like to have a formula whereby if I key in a Distance of 4 and a speed
of 256k, the active cell will show "1500".
I tried to use sumproduct but seems like sumproduct can only be used if the
Dist is exactly "5", "10", etc. The only alternative I can think of is to
list out ALL the integers for Distance. But, is there an easier way?
...Need to backup Contacts
I am running Outlook 2000 behind Windows ME. I want to
make a backup of Contacts but cannot find the location of
the file. When I search on *.pab, it returns "not
found". I have over 850 entries in Contacts, so I know
the file exists somewhere. Any suggestions on where to
find or how to back-up? Thanks.
Export your contacts folder to a .pst file. The .pab is old and obsolete and
has not been used for a number of releases.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all ...help attaching files
Using XP Pro and Outlook 2003.
For some odd reason, I am unable to attach files when sending emails.
Click on the 'paperclip', window opens to the My Doc folder. then when I
click on a sub folder to open, nothing happens... finally, a Microsoft Word
window opens that it is unable to open....
It is almost as if it is trying to launch Word to open the folder...
FWIW, from the Microsoft side a new Knowledge Base Article (KBA) was
released on Apr 15th.
It lists two known conflicts so far....Help, urgent, connection to access database
I met a problem about access database connection.
I have a program reading data from access database through ODBC.
When the access database located on local server, and created ODBC
linked to local database,the program runs without problem, but if it is a
network shared database, and created ODBC linked to the shared database, the
program prompts error: "workgroup file is missing".
Yes, I used workgroup file in current database and set correct security.
So what's the problem? is problem of the ODBC drive?
you should not be using ODBC
Access stop...Number to text conversion ......HELP
I need help in converting formula calculation ( Number or Currency ) into
EQ. Result = 2,500.00 converting to .....two thousand five hundred..
Check http://www.mvps.org/access/modules/mdl0001.htm at "The Access Web"
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Eko Hery" <email@example.com> wrote in message
> Dear Friend..
> I need help in converting formula calculation ( Number or Currency ) into
> EQ. Result = 2,500.00 con...AOL to Outlook 2003, transfer contacts and favorites, help?
Moving from 7 years of AOL service to a new ISP and using Outlook 2003 now.
How do I avoid having to copy/paste hundreds of contacts one at a time from
my AOL address book to Outlook.
Also have lots of 'favorites' on AOL I would like to keep...
"Jakfrost" <Jakfrost@discussions.microsoft.com> wrote in message
> Moving from 7 years of AOL service to a new ISP and using Outlook 2003
> How do I avoid having to copy/paste hundreds of contacts one at a time
> my AOL addres...Frequency function
I was wondering if anyone could be of assistance with the frequency function
in excel. I am trying to reduce data so that i can find out the number of
times a particular results occurs. Every time i use the frequency function it
either repeats the previous cell or returns the culumative frequency, can
anyone help please?
Countif or Sumproduct are less complicated!
You need to provide some details.
"Pritesh" <Pritesh@discussions.microsoft.com> wrote in message
>I was wondering if anyone could be of ...referring cell in macro function
If a create a macro intended to be used as a function in a worksheet
is there a property of the referring cell?
I want to know what cell the formula is in.
Dim callCell As String
callCell = Application.Caller.Address
Returns the cell address of the cell where the UDF is used.
"zxcv" <firstname.lastname@example.org> wrote in message
> If a create a macro intended to be used as a function in a worksheet
> is there a property of the referring cell?
> I want to know what cell the form...Argent Help
Can Any One Tell Me How Can I Get The Number Of Visible Sections In A Report
To Use As The Upper Bound Of A Loop Of Sections Because With A Worng Number
Of Sections An Error Occured
So If There Is Any Way (Using API,...) Any Way Please Tell Me
Thanks And Happy New Year For All
"Developer" <email@example.com> wrote
> Hello All
> Can Any One Tell Me How Can I Get The Number Of Visible Sections In A
> To Use As The Upper Bound Of A Loop Of Sections Because With A Worng
> Number Of Sections An Error Occured
> S...lookup array
Sheet 1 below:
A13 is a lookup from Sheet 2. I want the cell B13 to take this value and
lookup the column 1 and enter the value into B:13.
=LOOKUP(A13,A2:B11) but get this #N/A? What am I doing wrong?
PRESS SIZE Rate $
Order ascending the Press size column
and try again
regards from Brazil
"HFC-SC&q...Investors Needed!!! #5
Fork It Over!
a Ground Floor
Unique Dimension & Concept
Children's Entertainment Market...
For More information
...Another CPropertySheet help...
I am using the Wizard mode and I can remove the buttons, but I also want to
remove the 3D line control that appears above the buttons. What is the
...Excel and "AutoRun.inf" -- help
I want to burn an Excel workbook to a CD. When the CD is
inserted into a computer, I would like it to
automatically start up Excel and OPEN my workbook.
I've tried some "helper" applications for getting the
autorun.inf file to open Excel [and my workbook] when the
CD is inserted into the comptuter. It's not working!
Can anyone help?
I think you might have more success in a site that deals wit
Message posted from http://www.ExcelForum.com
...HOW TO EXTRACT (or lookup) DATA FROM A PIVOT TABLE
This is a multi-part message in MIME format.
Sheet 1 contains the raw data. Sales and cost of sales for customers.=20
Sheet 2 contains the pivot table that summarizes the data in sheet 1.=20
In Sheet 3(a further summary of the Pivot Table), I would like to put in =
the customer name and extract the related sales and cost of sales =
numbers from the pivot table. How can I extract the desired information?
------=_NextPart_000_000...help with combo box
I have two columns in an excel sheet named as "Area" and "Territory". I want
to make two combo boxes, one for area and other for territory such that if I
choose a particular area, the entries in the territory combo box should
so, if i choose "2" in area combo box, the territory combo box should show
"cc" and "dd".
please h...Need to expand past column IV
Were using Excel 2003 and ran into the end of colums at IV. Besides
upgrading to Office 2007 is there way to extend or add-in more columns.
No, but using all 256 columns is often a sign that you should use database data style entry -
instead of having a column for each of the ?days(?) enter the column property as a field, with each
entry in a separate row. Beyond that, it is hard to be more specific since your question is vague.
MS Excel MVP
"Vinecom" <firstname.lastname@example.org> wrote in message
news:8CBC158A-0AE4-46D6-9EB3-4CCDA375CCA9@mi...Help! Excel keeps freezing
I'm having a little problem with an Excel workbook that I created for
conference registrations. The workbook consists of 2 sheets. The 1st sheet
has Session Codes, Names, Dates, Times, Costs and Enrollment. The 2nd sheet
has Registrant's information which I group, filter and copy & paste to a Word
doc so each attendee has a Class Schedule. I rechecked functions, syntax
etc. and everything seems okay. I group the info and filter the sheet so
only one attendee's name, date, day, times and class name are shown. That
works okay and I copy and paste it to a Word doc temp...Help 10-23-07
I have a database. 2 columns. I have one work sheet that needs to findest
the highest dollar amount during a period of time.
Company a 5
company b 10
company b 12
company c 4
company a 1
company a 15
company b 12
company c 3
So the worksheet would first need to look for all the ones that have company
A and then look for the highest number. So in this case it would have
happened on 10/3/2007 (15). I would think this would involve a vlookup, but
can't figure how to write it. Could someone lend some insight. Anything
...help! Error: The XML element is already in the current scope...
"The XML element 'EnableTheming' from namespace 'http://tempuri.org/'
already present in the current scope"
I created a Web Service: I imported System.Data.SqlClient so I could
access SQL server tables programmatically. The web service builds and
deploys with no problems. When I try to add the corresponding Web
Reference to the Web Site project I get the error listed below.
I am able to create other Web Services on the same server and I am able
to add Web Referneces to them. I have narrowed it down to the "Imports
System.Data.SqlClient" statement, I thi...CPropertySheet Help button fails to launch chm file.
I have a application built around a CPropertySheet derived class. The help
button is looking for 'app.hlp' file (this is the default MFC stuff, I've not
added anything other than moving the button). How do I get it to look for a
'app.chm' file instead?
I've tried the following using a test help file.
Iin the CWinApp derived constructor:
and this in InitInstance():
//First free the string allocated by MFC at CWinApp startup.
//The string is allocated before InitInstance is called.
//Change the name of the .HLP file...Need to filter more than one date
I have an Excel sheet that has numerous rows and columns that I want to
filter by 3 dates.
I can use AutoFilter and filter one date but the others won't show up. I
don't want to show the entire worksheet.
this can be achived using advanced filtering - check out
http://www.contextures.com/xladvfilter01.html for details
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"HT" <email@example.com> wrote in message