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...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 <...new mail
test 0 1 2 3
...Preventing date from changing #2
I'm using excel for invoicing purposes. I have it set up so that when I
open the master invoice the date is automatically inserted with the
"Now" command. My problem is that when/if I open this same invoice at a
later date; that original date will change to the current date. I would
like the original date to remain. Is this possible?
Enter the date using CTRL ;
"theslaz" <firstname.lastname@example.org> wrote in message
> I'm using excel for invoicing purposes. I have it set up so that when I
> open the master ...If .NET 4.0 is new.....
If .NET 4.0 is a completely new framework, will anything compiled for 1.0 up
to 3.5 work with only 4.0 installed?
The comments I've seen in other places say you must have the previous
versions installed or 4.0 won't install and/or run.
"Tim Munro" <Excelsior@Liamtoh.moc> wrote in message
> If .NET 4.0 is a completely new framework, will anything compiled for 1.0
> up to 3.5 work with only 4.0 installed?
"Jerry" <ChiefZekeNoSpam@...Can't Create New Public Folders in a General Purpose PF Tree
I'm not able to create 2nd-level public folders underneath a newly created
Public Folder Tree using Exchange System Manager. I'm logged on as an
Exchange Full Administrator. I first create an alternate public store under
Administrative Groups | First Administrative Group | First Storage Group |
Alternate Public Store. Then when I move down to the Folders container
(Administrative Groups | First Administrative Group | Folders ) I can
create a new Public Folder Tree called Alternate Tree in addition to the
tree that is already there called Public Folders. Everything i...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 ...new font
I am trying to add a new font to publisher but can't seem
to do it. help anyone.
...Moving Storage Group to New Server
I had Exchange 2003 running on an Enterprise server but I want to move it over to a SBS 2003 server instead. We only have a few mailboxes on the server and i want to know what the easiest way to move them over to the new server would be. I have made an attempt to do so using Windows backup and then restoring it on the new server but it would not mount the database on the new server because the Organizational name is different on the SBS server. However I was not given an opportunity to set that name during Exchange installation on the SBS server and I can't figure out how to set it afte...Money 2004 crash in mnyob99.dll with new file
I just upgraded to money 2004. Whenever I created a new file (via
File->New File), money crashes and the system (XP) reported the fault
was in mnyob99.dll. This means that I won't be able to create any new
money file at all. I also followed some earlier message by opening the
sample money file, it works, but then it still crashed when I tried to
create a new file.
I searched suport.microsoft.com and did not find anything that would
solve the problem.
Please help. Thanks.
MJ - I have a very similary problem installing money 2003, and the suggested
help provided to me in an earlier mes...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" <email@example.com> wrote in message
news:firstname.lastname@example.org...Your new help tab sucks.
Your new help tab really, really sucks. All I really need is a box where you
type a command, say "header", and the buttons for that command appear.
I don't need yet another way to search help.
I don't need a button telling me how to find the Save button.
I don't need an interactive version of Word 2003's menu.
I just need a way to quickly bring up commands by name.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestio...Converting old ERD to new
I'm trying to edit an old Entity Relationship Diagram. It was generated with
the 'Crow's Feet' template, but that's all I can tell you regarding what
version of Visio it was created with.
I can open the diagram in my new Visio 2002 SR1 version, but I don't see a
'Database' menu. When I open the ERS (US Units) stencil, I still don't get a
'Database' menu. I can drag an 'Entity' symbol onto the drawing, but can't
edit any attributes.
I can create a new ERS (US units) based drawing, and then get a 'Database'
menu, and can cre...MDI
I'm wondering if it's possible to somehow bypass the built in
"document type" selection dialog that opens up when you execute
CWinApp::OnFileNew in a MDI with several different document types?
I'd like to add the "shortcuts" to create a specific documents type
into the main menu instead of just having one "File New" menu item.
Is that possible? :)
Thanks for the help in advance,
>I'm wondering if it's possible to somehow bypass the built in
>"document type" selection dialog that opens up when you execute
>...ACC2007: SubForm slows down form
i have a form which is connected to a query with about 6000 records on sql
server. If i open that form, it is really fast. But If i add an empty subform
on this form, the form opens in 12 sec. What i've seen is, that without the
subform the record counter on the bottom only shows the current record but
with a subform on it, it seems that it loops through all records and the
shows "1 of 6000".
Any ideas why there is a difference? I also tried to make the subform
invisible or disable it, but the behaviour is the same.
...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...No outside mail to new accounts
I have an exch 5.5 , we are moving off of, to an exch 2k3 server. All
mailboxes were moved last sept. working fine. Now when we create a new
account they cannot recieve mail from the outside. Any Ideas?
Check the queues... and tell us what you see. Something in event
Buenos Aires, Argentina
On Fri, 21 Jan 2005 08:27:02 -0800, "Benningtonr"
>I have an exch 5.5 , we are moving off of, to an exch 2k3 server. All
>mailboxes were moved last sept. worki...Print scrollable user form.
I have a user form that uses scroll bars. I added a button at th
bottom of the form to print what is on the user form. The cod
executed is userform.Printform. The only part of the form that print
is the part of the form that is in the user window. How can I get th
whole form to print, including what is out of the user window?
cparsons's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1286
View this thread: http://www.excelforum.com/showthread.php?threadid=39291
...New to Charts
I have a task to put together 5 "ladders" showing sales targets.
Each of the 5 have a different "goal", but I need all the ladders to be the
same height. (So, some "rungs" will be thicker or some ladders will have more
rungs, but the overall height of each ladder must be the same).
These ladders are reflecting sales for this quarter and will "grow" as the
quarter goes on. Each ladder is a different color. Raw data is collected
daily, but I think I'm only going to use the accumulative total each time I
plot the graph.
Bob's go...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/...Adding only new files to a backup folder
I have a folder containing some five thousand files sorted in numerous
subfolders, totaling about 800GB so far and counting. I occasionally
add a new file to an appropriate subfolder.
So far I safegurd by copying the entire folder on a backup drive. Such
a task naturally takes long, long time (two days or longer) even
though only a small fraction of the files population is newly created
I am looking for a way that first compares the backup folder witht the
parent folder to isolate newly added files and then copies them to the
existing backup folder. This way I shou...Calculating hours elapsed when date/ time > 24 hours
I am trying to calcualte the time in hours and minutes between cells. The
simple subtract function works when the dates are the same but I am having
complications crossing the 24 hour mark.
cell 1 cell 2 formula
4/1/2009 09:55 4/2/2009 08:57 =cell 2 - cell 1
cell 1 cell 2 formula
4/1/2009 09:55 4/2/2009 15:46 =cell 2 - cell 1
Can someone please help m...Transaction Dates
Bill Gates just can't make it easier can he?
Ever since my bank upgraded their software I am having the worst time with
e-pay's & x-fers thru money. Can someone help me understand why? When I
submit a payment via Money the program tells me it has to change the date
because it can't be processed on that day. For example; Today I requested
that 3k be transfered from my savings to my checking. In the past the
transfer would go thru and there was no issue. Now I get a message that says
my bank doesn't have enough time to do the transfer and the date must be
modified ...Easiest way of moving CRM 3 data to new server
We setup all of our CRM 3 data on an old server. Now that we are using CRM
for real, we have ordered a nice new shiny box for CRM to run on.
Is there an easy way to move the CRM data across from the current box to the
new one? If not, its not a great problem, but would save a lot of boring jobs
for someone here.
Check the Implementation Guide for the recovery options. You can follow
those basic steps to "restore" the data to the new SQL box. Another option
would be to explore the Redeployment Tool.
MVP - Microsoft CRM
"Oliver Marshall" <O...Joining Existing Computers to New SBS 2008 Domain
I have eight computers I will need to join to a SBS 2008 domain. They are
currently joined to a Win2k server with the same domain name. I am retiring
the Win2k server and replacing with the SBS 2008 server. They have POP3 email
accouints, so that is not an issue.
Do I need to unjoin the existing domain and rejoin to the SBS 2008 domain
even though they have the same domain name? I do not want to perform AD
migration because of existing problems.
This is a multi-part message in MIME format.