Newbie question #2
I need to find an easier way to do this:
= A1*B1+A2*B2+A3*B3+A4*B4+A5*B5+A6*B6 and so on
Can someone please help me.
Thanks in advance,
Expand the range (ie change A6 and B6) as necessary.
"Emilio" <firstname.lastname@example.org> wrote in message
> Hi all,
> I need to find an easier way to do this:
> = A1*B1+A2*B2+A3*B3+A4*B4+A5*B5+A6*B6 and so on
> Can someone please help me.
> Thanks in advance,
> Emili...Compare entries in 2 worksheets and list what does not match
Good Day All;
I have 2 Excell works sheets with approx 14000 rows each. What I would like
to do is compare both lists and get a 3rd list that shows what entries do not
Is there a simple way to do ythis in Excel
Assuming A1 should equal A1 in the other sheet...
=IF(Sheet1!A1=Sheet2!A1,"",Sheet!A1&" does not match "&Sheet2!A1)
Auto-Filter for non-blanks.
*Remember to click "yes" if this post helped you!*
"The Chomp" wrote:
> Good Day All;
> I have 2 ...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...How to share same email a/c on 2 pc
I have linked 2 pc via Windows Small Office network.
How to let these 2 pc share the same email a/c in Microsoft Outlook.
Plse provide solution in detailed steps as I am a novice.
outlook version 2003
"Christine" <email@example.com> wrote in message
> I have linked 2 pc via Windows Small Office network.
> How to let these 2 pc share the same email a/c in Microsoft Outlook.
> Plse provide solution in detailed steps as I am a novice.
> Operating sys...Scribe Migrate
I am planning to do a reinstall on our CRM server and have purchased Scribe
(didn't come in till JUST now), and was planning to do this over the
weekend. I have a test environment and want to try it here before I do this
on our production. However this isn't as simple as I thought.
I know, I know, read the manual, etc, etc etc. But its near critical that I
get this production reinstalled, and I'd rather not work straight through a
weekend just to learn this thing.
Anways, can anyone give me the basic overview of this? Does this take hours
just to create the migration setup? For s...testing (OT) 2
This is a multi-part message in MIME format.
I put this post on using the google group version, now using the =
Microsoft newsgroup server. I'm trying to pin down what works and what =
doesn't and why this specific sign in ID doesn't work on google groups =
OR on the news server I use in Outlook Express. But another ID I have =
I'm posting this using the Microsoft newsgroup server, which is =
something else, and should work....JPG Files #2
Just installed Outlook 2003. Can no longer view jpg
files...either those sent to me or ones I try and attach???
Have cleaned out my temp internet
Make sure you have a default program set for opening jpg-files. Rightclick
the file from within Windows Explorer nd choose Open With... and make sure
you select to always open that file with the selected program
You probably had set Microsoft Photo Handler as thedefault program which has
been replaced by Picture Manager.
Tips of the month:
-Cre...Cannot close opportunities #2
I upgraded from CRM 3.0 to 4.0
We encountered issues with SQRSS - I had to uninstall and reinstall SQRSS.
I am now encoutering issues when closing a new opportunity it error out
throwing an Exception of type "System.web.HttpUnhandledException'
[NullReferenceException: Object reference not set to an instance of an
at Microsoft.crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
at System.web.UI.Page.ProcessRequestMain(Boolean includesStagesBefore
A...Outlook 2002 Address Book #2
New entries do not appear in address book contents list.
Thought it might be a space problem, but have deleted all
extraneous data (i.e. deleted items. However, when I try
to re-enter the contact, Outlook asks if I wish to
replace the earlier entry for the same contact. Any ideas?
Explain more accurately what you mean. Where are entries not appearing that
you expect them to? Are you selecting the correct Contacts Folder from the
"Show names from..." dropdown?
"Lulu" <firstname.lastname@example.org> wrote in message
news:88020...Why does 62 KB translate into 4.2 MB in Publisher?
When I added a 62 KB jpeg to my page, the overall file size jumped from ~275
KB to 4.2 MB. What gives?
Let me guess - Publisher 2000?
MVP Microsoft [Publisher]
"Publisher induced baldness" <Publisher induced
email@example.com> wrote in message
> When I added a 62 KB jpeg to my page, the overall file size jumped from
> KB to 4.2 MB. What gives?
Publisher 2000 doesn't support compression.
PUB2000: File Size Increases Unexpectedly When You Insert Picture
...Green triangles #2
thanks for such a speedy response, teh placement of 1 in cell an
edit,paste special, multiply works, but why?
the value function doesn't work, as the green triangle seems to rende
the contents of the cell as neither number or text. strange.
once again thanks :
Stevethedoc's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=27800
Happy to help.
Thanks for the feedback.
As to why one works and not the ot...After 12.2.4 update, cannot open some Word docs with Open passwords
Operating System: Mac OS X 10.5 (Leopard)
After installing the 12.2.4 Office update, I am unable to open some Word files that I had password-protected with an Open File password. How can I open? Thanks
Basically, "you can't".
Sorry, the other passwords are crackable, but "Password to Open" is
effectively the encryption key. The entire file is encrypted, and unless
you have the correct password, you can't get it open.
However, are you sure you are not attempting to open files that were
password-=protected on the PC? ...Why is Excel changing the last 2 digits of a 17 digit num to 00.
When I enter a 17 digit number in a cell in Excel, the last 2 digits turn to
00 when I leave the cell. Format - Cell does not have a setting to stop this
'feature'. How do I make Excel recongize the large number?
On Thu, 28 Jul 2005 19:09:01 -0700, "Allie" <Allie@discussions.microsoft.com>
>When I enter a 17 digit number in a cell in Excel, the last 2 digits turn to
>00 when I leave the cell. Format - Cell does not have a setting to stop this
Excel Specifications and Limits:
Feature Maximu...Purchase Order 2.0.0127
Am I the only one having issues with the upgrade?
1) I create a purchase order
2) I click on add item
3) I type in the supplier ILC, and nothing comes up (ONLY on some items)!
4) I click on all items, and find the item, and add it!
5) When I click on OK the item is added to the purchase order, along with
the supplier ILC!
When I click on all items, even though the item may be in the database, I
can't find it to add to the PO, unless I close out the PO and re-open it???
This started happening only since I upgraded the the 2.0.0127!
Yes...Integrating Great Plains 8.0 and CRM 1.2 and Windows Small Busines
Integrating Great Plains 8.0 and CRM 1.2
I run a Windows Small Business Server 2003 Premium box along with a Windows
Server 2003 Standard box used for my Great Plains 8.0 and SQL 2000. I’m
considering introducing CRM 1.2 Professional into the mix. From a hardware
stand point I know I’m fine all around. I’ve been researching how I should
configure CRM and am a bit confused. The info I’ve found in KB887153 states
“When you install Microsoft Business Solutions CRM Integrations for Great
Plains 7.0, 7.5, or 8.0, Microsoft BizTalk Server is also installed. However,
BizTalk Server 2000 and B...SK 40175 Tuff-1 1/2-Inch Drive 15-Inch Reversible Ratchet
Best deal: http://thediscounfinder.info/index.php?id=B0009U5RRM
Item #: SKT40175. Features & Benefits:Tuff 1(r) Ratchets 72 tooth head design delivers a short 5" stroke for use in tight areas.17 teeth engage when torque is applied to provide a strong grip without slippage.Thumb falls naturally into position, giving instant control with one hand.Easy to reverse, 4 point cap.SuperKrome plating for long tool life and maximum corrosion resistance.Description: 15" Reversible Tuff Customers also search for:...Problem with vba code to export query result in excel
I have a access report that exports to excel with click of a button after
choosing parameters. This works well. However I have to modify couple of
fields to utilize formula in the export module. I am not sure how to do this.
I am writing the above code which seems to cause problem. I appreciate any
help to resolve this issue. Thanks.
If lngColumn = 12 Then
xlc.Offset(0, lngColumn).Value = =([UnitPrice]*[OriginalShippedQty])/1000
It seems the fields UnitPrice and OrigianalShippedQty are not being
>I have a acces...RMS 2.0 matrix dimensions are annoying, but help is available
For reasons I don't understand, MS saw fit in RMS 2.0 to use dimensions data
for matrix components that is far less accessible to users than Sub
Descriptions are. For instance, I can't edit assign a dimension value to an
existing item I have added to a matrix. I can't see a reason for using
Dimensions with limitations like this as using Sub Descs. to describe matrix
"dimensions" worked fine previously. Does anyone know why MS did this? It's
Digital Retail Solutions (DRS) has a product called Power Ops (Build
2.2.0003). It's help file mentions (se...Keyboard Shortcut #2
Is there a keyboard short cut or quick way to switch between tabs or
worksheets in an Excel workbook?
Ctrl + PageUp / PageDown
Ctrl + Tab / Shift + Ctrl + Tab (backward)
"Steve Cohen" <firstname.lastname@example.org> �b�l��
> Is there a keyboard short cut or quick way to switch between tabs or
> worksheets in an Excel workbook?
Here are two links that provide info on more keyboard shortcuts.
http://www.cpearson.com/excel/...Copy/paste range of rows between 2 dates...
Hi! I have a sheet called data which act as a database. The column A has
the dates. In order to create customized chart in a userform, for
different range of data(i.e from column D, G and M...), I'd like to
select a range of rows that are between 2 dates and create the charts
accordingly. Or copy to range to another sheet and then create the
charts. I am not so advanced in VBA and any help would be greatly
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
...Can you link 2 worksheets together?
Say i have one worksheet and on my second one I want to reference cells from
the first one? is there a formula for that>?
To create a simple link:
Select a cell in the second worksheet
Type an equal sign
Select the first sheet
Click on the cell that you want to link
Press the Enter key.
> Say i have one worksheet and on my second one I want to reference cells from
> the first one? is there a formula for that>?
Excel FAQ, Tips & Book List
...Exclude outbound Internet mail from journaling #2
I have an Exchange 5.5 installation which requires message journaling of
internal email only. External (Internet) email is captured and archived by a
gateway SMTP server, whilst internal mail is journaled to the same SMTP
server for archiving.
The documentation regarding journaling on Exchange 5.5 details how to route
local messages through the MTA, and how to route Internet Mail Service
messages through the private information store, but it seems even when this
second routing configuration is not applied, outbound internet mail is still
I need a way to ONLY journal ...zip code help! #2
thanks for the help !!!!!!!!
cbender3's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1556
View this thread: http://www.excelforum.com/showthread.php?threadid=27126
...Cannot publish or export in Deployment Manager
When I click on "Publish Customization" or "Export Customization" I get an
This application has requested the Runtime to terminate it in an unusual
way. Please contact the application's support team for more information.
Has anyone experienced a similar problem? What can be causing this, it was
Thanks in advance,
...Export or convert .qrp files to HTML
Hi all, great forum -
Does anyone know how to export or convert any given .qrp report into an HTML
or other web format? Could it be possible to open a .qrp in it's native
format? I've seen a company online (Sabletooth) that converts Report Builder
(.qrp) files into Crystal, but I think they are only offering consulting
Thanks in advance for your help.
At the top of the report it gives you several options(print, save, etc.) the
fourth or fifth from the left(not quite sure which one by memory)is the one
to export. It gives you several options. One of which is to expo...