One worksheet has 600 + lines with a lot of expenses, including SOME of the
local expenses. This is a check register..
Another worksheet has 300 + lines with ONLY local expenses.
Trying to get ALL expenses together, but eliminating the duplicates from new
list. Thinking B2=date. C2=name, E2=amount - - SO B2&C2&E2 on first long
worksheet and then the same on short worksheet... Bring BOTH over to new
tab and then stuck. Any ideas greatly appreciated, or another better way to
You could use excel filter:
Data - Filter - Advanced Filter - Unique records on...cannot print calendar
When I select 'file-print-page set-up' nothing happens. When I select
file-print-preview-page setup, I get an error message ' cannot display dialog
box'. Help - I want to print from selections available. I use Outlook
calendar at work and I know that there are selections available.
Does anyone know a fix for this problem?
Thanks, I appreciate any help.
Similar problem on migrating from OL03 (DELL Dimension D505, W2000 Server) to
OL07 (DELL Latitude E6500, W7). Daily & Tri-Fold views won't (or would not)
Preview or Print in OL07 for my HP1200, but W...All + Everyone #2
Is there a simple way to send a message to everyone in my organization that
has a mailbox?
"Fred Stocker" <email@example.com> wrote:
>Is there a simple way to send a message to everyone in my organization that
>has a mailbox?
What release of Exchange?
You can use a "Query Based Distribution List" with Exchange 2003.
MCSE+I, Exchange MVP
MS Exchange FAQ at http://www.swinc.com/resource/exch_faq.htm
I tried that but it didn't work. Thought maybe there was something I was
missing. I'll try again.
Fr...Which Office X 10.1.5 duplicate fonts can be removed from which folders?
Which of these duplicate fonts can be removed from the
Applications/Microsoft/Office X/Office/Fonts folder AND/OR the
All of the following are duplicated in the two folders. Two of them, Times
New Roman and Verdana, also are in OS 10.3.3/Library/Fonts.
Comic Sans MS
Copperplate Gothic Bold
Copperplate Gothic Light
Edwardian Script ITC
Times New Roman
On Tue, 6 Apr 2004 04:42:59 -0400, Norman R. Nager, Ph.D. wrote
(in article <...Outlook 2002 Read Receipts Tracking issue
We have a tracking problem that I am unable to resolve. We have a user
that needs to keep track of users that read training related email.
She sends out to a server based distribution list of around 90 people
and requests read receipts. When you go into the sent items and look
at the tracking tab, it only shows the group distribution list name and
no other information, not even a time stamp. I believe she even
redirects the read receipts into a separate folder for easier tracking.
It was working where all the users were listed and showed the time
stamp of when it was read, but no more. W...Entourage Print Font Size
I have seen this issue in this group for the past few years, but all
of the resolutions have failed to solve the problem on my machine.
Issue: When printing an email in Entourage, the print font size is
around 20 pt; i'd like to make it smaller. Changing the Preferences /
Fonts / Printed Items does no good; it changes nothing. I have
rebooted after each attempt.
Situation: I have a new MacBook (about 4 weeks old) using OS 10.5.5
and Mac Office 2008. Printing issues occurs with every printer i have
used. (e.g. Dell Color Laser, HP Color Laser, HP Office Jet). It
occurs over the...Duplicate data from field into another field in same form?
Can I duplicate data from one field on a form into another field in the same
On our exhibitor entry form, the Program Contact info (fields for name,
address, phone, fax, email) is entered first. Mail Contact info is often the
same, but not always.
Is it possible to autopopulate the Mail Contact with the data from the
Program Contact, but allow me to enter new data if necessary?
If so, can you tell me exactly how?
On Fri, 23 Mar 2007 09:46:24 -0700, Andi <Andi@discussions.microsoft.com>
>Can I duplicate data from one field on a ...Publisher and tables #2
I am making a booklet. I am putting info in as a table and I need to know if
there is a way to get my table to automatically continue on to the next page.
No, Publisher hasn't this function. Word does...
Mary Sauer MSFT MVP
"Kimmy" <Kimmy@discussions.microsoft.com> wrote in message
>I am making a booklet. I am putting info in as a table and I need to know if
> there is a way to get my table to automatically continue on ...Receiving duplicate emails
I have just recently created my email account in
Microsoft Outlook and now when I receive email I get the
same one 15 times (and that is no stretch!) Is there
something I have done wrong? How do I fix this?!
What version of Outlook do you have? What sort of mail account(s)? Do you
only get a single message many times, or all the messages many times?
This posting is provided "AS IS" with no warranties, and confers no rights
"Carrie" <firstname.lastname@example.org> wrote in message
news:email@example.com...Unmatched Purchase Receipts
We are having issues with GP10 (V10.00.1424) holding purchase receipts that
have not been matched to invoices. Here is a quick narative of what is
We receive the item into GP
GP assigns a receipt number to the item
We receive an invoice from the vendor
We intend to enter and match the invoice, but the receipt is not available
We are not sure what is triggering this event, and we thus, we do not know
how to fix it.
I am sure we are not the first to experience this problem!
Thank you for your time,
What do you mean by 'unavailable'? Is the rece...Exchange Routing #2
I am running EX2K3 with SP2, with 3 bridgehead servers, in Sydney,
Manchester, and Melbourne. My Exchange servers that are located in the UK,
use 3 RGC's with 3 different costings in the following order Manchester
bridgehead (20), Sydney Bridgehead(30), Melbourne Bridgehead (40). For some
reason my Exchange server continues to use my Sydney bridgehead server
through the second RGC, and not my default Manchester RGC which has a lower
cost. However, if I delete the Sydney RGC it works via Manchester, or if I
make Sydney RGC more expensive than Melbourne RGC it will also use...Missing Mail #2
We have just downloaded our email and read 1 message then
returned to outlook to find all mail in our inbox gone
along with our contacts and personal folders.
Is there a virus out there that might have caused this?
Is there anyway we can get the information back?
Natalie <firstname.lastname@example.org> wrote:
> We have just downloaded our email and read 1 message then
> returned to outlook to find all mail in our inbox gone
> along with our contacts and personal folders.
> Is there a virus out there that might have caused this?
> Is there anyway we ca...Printing issues #3
I am trying to print a postcard (designed in publisher) using Avery #5389
postcard stock. I can't get the margins right so that both postcards are
centered and don't overlap.
Are you using a template? Are you saying your printer is not lining up
correctly? Print to plain paper and adjust accordingly. Your roller may not be
feeding quite right.
If you are using a template there will be one card on your screen. Are you
setting up the cards manually? This is the measurements you should be using in
Arrange, layout guides, if you are doing the cards manually.
Left and Right margi...Duplicate, Duplicate, dupli ...
I'm new to the group, so hope I don't disgrace myself.
I have a list of names in the first column, and their respective postal
codes in the second. Unfortunately, many of the names, (and respective
codes), are duplicated... sometimes there are up to four of the same name,
(and code), under each other.
Is there a way to get rid up the duplicates and make a usable list please? I
can do it manually of course, but ..
Data>Filter>Advanced Filter. "unique records only" and "copy to another
For more on this visit Debra Dalgl...Quit creating duplicate desktop icons when doing upgrades/hotfix
Upon any sort of upgrade or hotfix, RMS creates a whole new set of desktop
icons. What a pain! Pls fix. Ask if we want to create new desktop icons,
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/...How do I duplicate numbering on a raffle?
I am creating an event ticket but would like to number the tickets on both
the left and right sides of the ticket.
Create a data base with your numbers. Use mail merge for the tickets. You can
insert a mail merge field on both sides of your ticket.
When you merge have one ticket on your screen. What version Publisher are you
using. Some early versions of Publisher shows all the merge items the same in
print preview. This is a Publisher bug.
Mail, e-mail, and catalog merge
"Candi...How to delete "non-identical" duplicate records in an Access table
How to delete "non-identical" duplicate records in an Access Table? Where
"non-identical" duplicate record means a record in the table that has
slightly different datum in one of the fields, but an identical duplicate
datum in the field that I am concerned with. For example:
SSN MRN CLIENT NAME
001-00-2222 11170419 Smith, Jane
001-00-2222 11170419 Smith, Jane T
001-00-2222 11170419 Smith, Jane Thompson
The data of these two records in the fields SSN and MRN are identical; but
"non-identical" in the CLIENT NAME field (notice...Duplicate ItemLookupcode
Any clues on how I could get duplicate itemlookupcodes?? I found a few of
them recently. No SQL queries have been run to generate them and if I try to
create a duplicate itemLookupCodes I am stopped with a message telling me to
use a unique name. How could they have gotten in the database? Any clues,
boos or comments appreciated.
Thanks for all the help!
This is a multi-part message in MIME format.
As you mentioned, RMS Manager doesn't ...Bug in DRP with monthly payments?? #2
I have an annoying problem with the debt reduction planner that has been
around for at least a few versions. I am currently using v2006.
If I go into the debt reduction planner, then select base my plan on:
what I want to pay each month and enter anything other than the minimum
required payment, I get some crazy results for the payment schedule chart.
For example, it tells me I need at least $2500 for debt payments. If I
put that amount in something larger, say $3000, then for the first month
it applies $20,000 to debt and the next month like $10,000. Where does
it come up with the...Printing #23
I have just discovered that when i try to change the print
orientation form portrait to landscape it is greyed out.
Can anyone tell me how to chnage this please?
The OS is win98 on a stand alone pc using excel 97
Does your Printer support Landscape orientation?
Gord Dibben Excel MVP
On Mon, 8 Nov 2004 10:46:16 -0800, "John"
>I have just discovered that when i try to change the print
>orientation form portrait to landscape it is greyed out.
>Can anyone tell me how to chnage this please?
>The O...Print Worksheet Contents
is there a way to print the contents of a worksheet? Say I change the prices
of 20 items and I want to print new shelf labels. Or I want to notify my
remote stores of those price changes.
After your worksheet has issued (and maybe before) - you can open it, go to
Contents tab> right Click> Copy As Table> OK (on copied to clipboard)> Open
Excel or similar> Paste.
Unfortunately - there is not an import function on the label wizard. You can
however filter the wizard for the Last Updated date.
> is there a way to print the content...envelopes in word 2002 print crosswise
All of a sudden, the envelope option in word 2002 will not work properly.
No matter how I configure the envelope insertion screen, the printing comes
out crosswise on the envleope. I have tried all the combinations and the
problem persists. I uninstalled/reinstalled word, to no avail. This all
started a couple of months ago. My word is part of Works Suite 2006.
There have been no new programs added to my computer (winxp pro; sp3), virus
detections, etc. Only microsoft security updates.
My printer, brother hl-5040 checks out fine with brother tech support.
T...Printing postcards from publisher 2007
I have given up on duplexing my postcards with mail merge. I made two
separate publications and printed the addresses on one side of the cards.
Got that to work.
Now I'm trying to print the four pages to the one sheet 8 1/2 x 11. It now
prints all four copies, minimized into the upper left 1/4 of the paper. How
do I get the program to print my postcards full size?
Look at my answer in your earlier post.
"Judy Gross" <JudyGross@discussions.microsoft.com> wrote in message
news:6A6D1429-44B0-47A8-ABEB-0C84C2F749F4@microsoft....Find duplicates in a column
I have 6000 emails addresses in a col and wish to know if there are any
How can I do this please.
I have Excel 2002.
Assuming your emails are in A1 to A6000, in B1 enter
copy down B1 all the way to B6000
Apply a conditional format of red pattern on cells B1 to B6000 where Cell is
greater than 1 and all duplicates will be shown in red.
> I have 6000 emails addresses in a col and wish to know if there are any
> How can I do this please.
> I have Excel 2002.
Why do the songs in my media player library often duplicate or tripulicate
themselves, so i end up with a library three times the size it should be. I
have on occassions gone through and deleted all the replicated songs, but
over a period of time they seem to "grow again" filling my library again with
unwanted duplicates, taking up more space and memory. Is there anyway i can
stop this happening?????
What version of WMP/Windows?
First, make sure that WMP isn't monitoring the same folder twice.
Duplicate songs can appear when, for example, both C:\Music a...