Need Formula To Find Blank and NonBlank Cells
I have a worksheet with 6 columns (by Month)
Sep Aug Jul Jun May Apr
I have to review starting for example with May, I need to find any cell in
May range that is null <> where Jun and Apr both are not null <>
So if May is null and Jun and Apr are not null than I would count that as 1.
If May is null and either Jun or Apr are null then I would not count them.
"hilltop55" <firstname.lastname@example.org> wrote in message
news:08D989CB-D1B4-49F...Need Syntax for "AND" to Evaluate 2 Cells
I need to evaluate 2 cells while inside an "Private Sub
Worksheet_SelectionChange(ByVal Target As Range)". I thought AND would work
but I cannot get it to work; I receive a syntax error on the AND(Range...
Can someone please provide me the proper syntax to evaluate the 2 cells?
Here's my code...
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveSheet.Name = "Sheet1" Then
And(Range("I3") <> "", Range("K4") = "") Then
Range("K4") = Range("K3")
End...Need to import EDI file
Hello. I have an EDI TS-130 file (academic transcript) that I would like to
import into Access 2003. Is this possible to do for free? If so, how?
...You wont believe this! SERVER DOWN
I was helping the operations/it director to get RPC over HTTP going on their
exchange server for a company I use to be the sys admin for. The ops/it
director was doing the add/remove programs portion to add rpc over http
there, somehow in the process of doing this he managed to uninstall IIS -or-
just NNTP and SMTP (I can't figure out which and he claims he did neither).
Long story short, I've reinstalled NNTP and SMTP, reconfigured SMTP to the
best recollection I have of the previous config and the server still refuses
to send/receive email, even internally. All services are s...need custom cut and paste functions
I once wrote here about a problem I had cutting and pasting where columns
would turn to "REF!" after a cut and paste. I would work around it by
copying, pasting and then manually deleting instead. I thought turning
everything in the sheet to absolute references would solve the problem but
it didn't so now I am thinking of a different solution.
Could someone tell me what I need to do to write my own cut and paste
functions which would basically copy the selection and then on a paste it
would paste and then delete the original selection from where it was copied
from...not able to setup my email with outlook
Hello All, I believe I need some “professional strength” help and advice with these questions. I've been fortunate to have received some of the greatest help at these MS forums, and so I'm back with some questions regarding my upcoming switch from OUTLOOK EXPRESS to OUTLOOK 2007, finally. My questions revolve around myself being very familiar with OE, and now trying to figure out the best & cleanest way to convert to, and configure Outlook 2007 given my particular needs. I understand some of the differences between OE and Outlook, however I've not yet installed Outlook 20 This ...Mailbox needs reducing
We have this mailbox that has been left for months and with no limits, it's
Ho can I trim in down, I don't really want to go into the mailbox and do it,
can Exchange do it?
Gonzo <email@example.com> typed:
> We have this mailbox that has been left for months and with no
> limits, it's now 11GB!!
> Ho can I trim in down, I don't really want to go into the mailbox and
> do it, can Exchange do it?
Presuming you're not on 5x or earlier, you can use mailbox management
policies to get rid of items ol...RPC over HTTP to Exch2k3
When I go to setup Outlook 2003 to do RPC over HTTP to an Exchange 2003
server (running on Windows 2003 Server), I get to the part where I am
supposed to check "Connect to my Exchange mailbox using HTTP" under the
"Connections" tab, but no such option exists!
I've scoured the web but can't find any resources that tell me why I am
missing this option.
If someone could help me determine why this option isn't displayed, it'd be
Thanks in advance,
I will assume that you are running Windows XP (SP1), but did apply
http://su...I need help restoring Public Folders
I've been having issues getting Public Folder replication going between 2
Exchange 2003 servers.
Prior to doing any work I performed a Backup using Veritas Backup Exec and
this completed and verified correctly.
I screwed things up and managed to delete some of the public folders on my
original server. I'm not 100% sure what I did but it is a mess and the only
backup I have is the Exchange backup I created before doing any work.
The public folders contain a number of Contact Lists and a very important
I have restored the public folders but when the restore c...Linking Basic Beancounting spreadsheets?
I am new to Excel (and this forum) & want to make my own General Ledger,
Monthy Synopsis, Trial Balances, Financial Statements etc. for a new
I am reading _Basic_Beancounting_ by T. James Cook and wish to use
Excel efficiently. (Just learned how to group tabs to make multiple
identical forms. Works great and saves a pile of time!)
Now I want to take the debit & credit totals from each account column
in the monthly synopsis sheet and link them (automatically post) them
to the appropriate column in their individual running totals of each
General Ledger Account.
The problem...Need help on a formula 05-20-10
I need a formula to calculate the following information please: I will have
someone enter a time (ex 6:31) in cell C3. If the time matches one of the
times in cells B17-B22 I need it to display 4.6, if it matched one of the
times in cells B23-28 I need it to display 4.7, if it matches one of the
times in cells B29-34 I need it to display 4.8 and so on. Does anyone have a
simple formula I can do for this please?
Can't do the "and so on" part, bu...Need to retrieve a deleted Excel File
On Saturday I hide an excel sheet and then protected the
workbook. When I got into work today to open the file it
was non-existent. What do I have to do to retrieve the
file? Does it make a difference if the file extension
ended with .csv?
Thanks in advance!
Search in Windows to make sure it's still on your compute
go to the folder the file is in and look to make sure it's still ther
If you didn't do this, you might need to to text, which includes *.cs
Excel is not set to open this type of file by defaul
Did you (try to) open the file with Excel.
If so : did ...need some XL URL's please
I would appreciate some good site links for XL how to's and working examples
aimed at Novice - Intermediate.
Go to the heading:
Excel Lessons & Tutorials (#tutorials)
It's just after halfway down.
Norman Harker MVP (Excel)
It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
...Upgrade GP 9.0 SP2 to GP 10.0 Advice
We are planning our upgrade of GP9.0 SP2 to GP10.0. We are running SQL 2000
and would like to also upgrade to SQL 2005.
I am using the following url (and read some threads on this forum):
(page: Updating to Microsoft Dynamics GP 10.0)
The chart Microsoft provides says I can go from 9.00.0281 (which is SP2) to
10.0 or any patch install.
What does "any patch install" mean?
Does this mean I can't go directly to 10.0 Feature Pack 1?
Would i...ebay - ereseller stook my money
a terrible thing happenned to me on ebay.
i am a disabled woman in and eresellers took my money and never sent my washer.
his email address is firstname.lastname@example.org.
anything that you can do to help would be nice. ebay is doing nothing.
i can give a reward
This group is for discussing the Microsoft Money computer program.
Does it really sound like an eBay buyer complaint forum?
Do a google search on ebay and you will find a couple of groups, one
of which may reply to your problem.
That ebay seller has been selling on ebay for over 5 years.
On 1 Jun 2004 13:50:08 -0700, (An...Need Help With GP Item Pricing
GP ITEM PRICING
I need to use “Bucket Pricing” for items in GP. For example below is the
pricing schedule that I need to use.
First 20 …………….$ 1.75
Next 280 ……………… 1.36
Next 700 ……………… 1.23
Next 2,000 ……………… 1.09
Over 3,000 ……………… .82
So if I had a Qty. of 350 it would be as follows
20 * 1.75 = 35
280 * 1.36 = 380.80
50 * 1.23 = 61.50
Total : $477.30
In GP I can only set it up to do a “Quantity Range” in the Item Price List
Maintenance window. Problem is if I set it up that way and enter a quantity
of 350 it will default to the $1.23 ...I need to round up to the nearest 50.
I am trying to calculate the number of raw material bags I need in a batch.
If I use the mround function is will round down. Is there a way to only
"karenm" <email@example.com> wrote in message
> I am trying to calculate the number of raw material bags I need in a
> If I use the mround function is will round down. Is there a way to only
> round up?
First of all, I believe MROUND rounds...Missing mail after VPN Outlook setup
Last week we setup VPN to be able to read mail from home (no OWA).
After installing Outlook at home and connecting to the exchange server, and
syncronizing the data I got all mail/contacts etc on my home computers
BUT, when I got to work the day after, my Outlook on the work computer was
empty, no mails or nothing.
Looking in the Exchange server at the mailaccount I can se that it contains
over 1000 emails so they seem to still exist on the server.
What could this be? Is there som configuration needed?
Did you configure the home computer to deliver mail to a personal folde...Need Training in office for CRM in Toronto, Onatrio
We just purchased the CRM. Can anyone refer a Microsoft partner/consultant
that does CRM training.
They need to be in Toronto, Ontario, Canada.
On Dec 18, 4:36 pm, Jasmine <Jasm...@discussions.microsoft.com> wrote:
> We just purchased the CRM. Can anyone refer a Microsoft partner/consultant
> that does CRM training.
> They need to be in Toronto, Ontario, Canada.
> Thank you
I am part of the largest Microsoft CRM partner in the world. We have
offices across North America and are very tightly integrated to the
Microsoft CRM Produc...Add Item to GP Menu
Does anyone have instructions on how to add items to the GP menu? I believe
it can be done with Dexterity, but I have no idea what file to modify or how
to use Dexterity.
> Does anyone have instructions on how to add items to the GP menu? I believe
> it can be done with Dexterity, but I have no idea what file to modify or how
> to use Dexterity.
Please look at the Integration Guide PDF manual installed with Dexterity.
Part 5 explains the navigation model and how to work with command forms,
commands and menus.
CAN OUTLOOK BE USED WITHOUT AN INTERNET CONNECTION?
IF SO, HOW
"MARTY" <firstname.lastname@example.org> wrote in message
> CAN OUTLOOK BE USED WITHOUT AN INTERNET CONNECTION?
> IF SO, HOW
Yes, just don't set up any email accounts.
...I Need a Formula for setting up what to charge for equipment rent.
i need a formula to set hourly charges for renting out construction equipment
such as Backhoes, Bulldozers etc.
You need to determine what the formula to calculate these charges are, in
English, and then maybe we can help with the SS formula.
"chippian" <email@example.com> wrote in message
> i need a formula to set hourly charges for renting out construction
> such as Backhoes, Bulldozers etc.
Be...Formula Help Needed #2
I would greatly appreciate any help anyone can offer on this.
Ok let me first give a little background info. I have a spreadsheet of my
raw data (spreadsheet a) it has 4 categories, account#, client name, balance
amount and a code (1-7). The code tells me what internal business category
each account falls under.
I have another spreadsheet (spreadsheet b) that takes the raw data of a. and
puts it into a neat easy to read report.
What I need is a formula that will look through the entirety of spreadsheet
a and first, determine let’s say how many code 1’s there are ( I know this
can be a...Need Money????
Need Money, visit http://dinero4ever.blogspot.com
...Desperate! Need Contact in Day-Timer transfered to Outlook 2003
Please, there must be a way! I've been reading and trying
everything! Everytime I come to some impassible stumbling block. I
know a little, but am far from techy. If someone out there has/had
Day-Timer Organizer v. 3.95 and successfully transfered the contact
data into their Outlook 2003 Contacts or even better their BCM
Contacts, please tell me how! Please?!
what formats does daytimer support for exporting?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.s...