What do we do with our Money 2002 Data?
We have used Money 2002 since it came installed on the Dell computer
we purchased years back. We cannot find any backup disk that Dell
might have supplied for installing again.
Now, my wife ordered Money 2010, not knowing until later that her 2002
files would not be able to be imported into the new Money 2010. She is
also saying that the new 2010 program will no longer be called Money,
but will bear the Quicken name. Is this correct?
Question: If the above is true, is there any method to import these
2002 files into "Money/Quicken 2010"?
We certainly are not going ...How do you create a line of best fit from data in excel?
The best way I am aware of is...
If your data is in chart from, then right click any data
point and select <Add Trendline...>
Then select type <Linear> and then click the <Options>
tab and checkmark <Disply Equation On Chart>. this will
give the formula for the line as best fit in the form of
the standardised y = bx + c.
In effect this is a linear regression and gives you the
line of best fit bith in visual form (i.e. the line it
puts on the chart) and algebraic form (i.e. the equation).
Does this help? I will check back if you need any further
assist...Data not displayed in some Public Folder items
Hello, I have a problem with some items in a Public Folder. These items are
posted using a form from the Organisation Forms. A while ago we had a problem
where the form stopped working (sorry I don't know the details as I was not
directly involved) and a new form was created and set up to be used in the
The problem is that the data contained in posts to the folder prior to the
new form being published do not contain any data. The posts are still there
and can be opened, but no data is shown other than the sender's name and the
name of the public folder.
I am guessing t...SUMIF where the IF is a variable date from data in a column HOW?
Aby SUPER USERS out there?
I got a large no of data that are sorted by date, I want to make a formula
that can count the occurencies of the numbers 1, 2 3 etc. in column C and
show the result in column D, E F etc.
The result in D comes from a formula:
I need to find out how to show the result of 1, 2 and 3 etc. in Column E, F,
G etc. for each date ie. 20090608 = 4 ones. and 2 twos etc. and then again
for th next date etc.
I have tried with =IF(F2=1,SUM(IF($D$2:$D$50=D2,F$2:F$50,0)),0) but it sums
all ones ...copy data in a cell from worksheet A to worksheet B
I have a financial woksheet per month. Basically I want a certain value from
Worksheet A to be automatically if possible transfered to new worksheet fro
next month say. So the Finance contiues from this total.
Is there any who knows how to do this please???
...Graphing daily data
I am trying to graph daily data for a month in Excel 2007 that groups like
days (Saturdays, Sundays, etc) in the same series, while still showing
individual values and dates. Any ideas on how to accomplish this?
Use your worksheet to pull the relevant data together into a series. Do the
data manipulation in your worksheet, then the chart plots the series which
you have generated in the worksheet.
"Fozzie" <Fozzie@discussions.microsoft.com> wrote in message
>I am trying to graph daily data f...Extracting data and returing to colums.
I am about half way there, but I need some more help.
These are web inquires that parsed out in the same colum and repeat th
same way all down the page.
I want to be able to use the fields as guidelines to pull the dat
adjacent to it and sent to the new colum. In a way it is transposin
all the data, but I need to pull all the first names of these peopl
and have them align in the first colum. Same for Last name, business
So if the information that I have come across like this in th
spreadsheet, I just want the customer infomation to move to th
appropriate colums like the third example...Pivot Table Data field
I am importing the data from Ms Access, and creating Pivot table.
Row, Data and Columns have drop down manus where you can select and
In Row and Columns when if i unselect any values in drop down menu and
go back values are still there. However, With Data when i unselect any
values it vanish i am unable to retrive it back. Please any one let me
know if i unselect any values from the Data dropdown menu they still
-------------------------------------------...how do I convert Mozilla thunderbird data to outlook 2010?
Converted from an old Outlook to Mozilla Thunderbird years ago. Like new
Outlook and would like to switch back. Can't seem to see a conversion utility
I suspect you export from thunderbird to a format Outlook can import, eg csv
(assuming pop mail)
"Mishka" <Mishka@discussions.microsoft.com> wrote in message
> Converted from an old Outlook to Mozilla Thunderbird years ago. Like new
> Outlook and would like to switch back. Can't seem to see a conversion
>...Complicated conditional formatting if numbers match across a data set..How?
Ok. Here is the setup I have. I have columns of data setup across the
-1.5 -110 -1.5 -110 -2 -110
1.5 110 1.5 -105 2 -110
The -1.5 and -110 are in two seperate columns but together are under
the Heading A., the second set of two numbers is under Heading B, etc.
So each set of two columns should be considered a set together. My
I need some kind of query that will go across each data set and compare
the numbers and highlight them in some way if they meet certain
conditions. Take Heading A as a benchmark (Heading A makes up Columns
A/B for example). I need Column A to c...Sort serial numbers that contain a letter, by number
Our organization numbers a certain set of items in the following
where 3B is constant, 08 is the year the item was entered (i.e,.
changing from year to year), and #### is a number up to four digits.
#### is written with the appropriate digits without leading zeroes,
Question: Is there a way to format and Sort these numbers so that the
#### numeric portion is sorted numerically? Using the above four
entries as an example: The only Sort choices are "A to Z", "Z to A"
and "Custom list" (the ch...Consolidating Data #2
I am consolidating data (sum)(create link) from several
workbooks. Although I identified all of the target cells,
Excel doesn't capture link information for target cells
that are blank. Is there anyway to configure Excel to
create links where the target cells are blank?
...Graphical co-ordinates format data label (with brackets) for chart
Using Excel 2007, I have made a chart using a data series with the x-values
in one column and the y-values in another. I wish to show the data label for
these points, but want to include the brackets to replicate the mathematical
way of expressing the co-ordinate i.e. that the data label would read (-8, 6)
instead of -8, 6. I've tried creating a custom data label using format codes,
but I'm getting nowhere fast. Can anyone help please?
Also, I have a second series on the same graph that I do NOT want to display
this information (I'm making a teaching resource). It d...Calc field causing data loss in report....
Wasn't sure whether to post this in "Queries" or "Reports" so I opted for
"General Q". Apologies if wrong.
I'm having a problem with a report. Well it is more like 2 queries and a
The issue is that when I put a calculated field in the "Report Footer" I
loose half the data.
Here is an outline of what I am doing (these aren't the actual fieldnames, I
have used fieldnames here that I hope are self explanatory for format & data
The data fields in the report are as follows:
VehicleRegistrationNumber, ...Missing Data Options
I am trying to use Tools - Options - Chart. I want to use the "not
Plotted" option. When I click on it my chart does not change. This
happens after I've selected the chart and then trying to make these
What am I doing wrong?
I want to create a chart that ignores missing data, and gives me a
trend line based on the data I have.
I've had my nose in my Excel "bible" but can't find the answer.
I greatly appreciate any tips.
jimsmith888's Profile: http...Need advice moving data in mailboxes to another server
Due to corporate restructuring, we are setting up a new domain. In the
process, we are upgrading our servers, etc. as well.
Our task is to move user data i.e. saved mails, calendar items, etc. FROM a
server running Exchange 2000 Standard in Domain A TO a server running
Exchange 2003 Standard in Domain B.
What is the best way to do this?
Use exchange migration wizard or exmerge:
"Sam" <Sam@discussions.microsoft.com> wrote in message
&g...sumproduct with additions to data
I am using Sumproduct to count the number of parts delivered late to
schedule, but we have a 5 day grace period that I can't figure out how to
accommodate. What I need to do is add 5 days to the due date (X:X) then
determine if the receipt of the part (Y:Y) was later than that date.
what I have is:
DATA! is the tab where the data is pulled into from their various legacy
AE:AE is the vendor code (I am collecting the data by vendor)
X:X is the scheduled due date
Y:Y is the actual receipt date
...Evalutation Software Error on Old data
When I attempt to open the manager connected to an old database (i.e.
a copy from a backup months or years ago.), I get an error saying the
evaluation copy of the software has expired, and the program shuts down.
Using version 1.3.1011
Yep, The DB is older than 45 days and therefore will not let you access it.
If you create a new DB you can use it.
"Greg Shepherd" <email@example.com> wrote in message
> When I attempt to open the manager connected to an old database (i.e.
Not sure if this is the right place to post this but here is my problem. I
have a multi user database, all info is inputted by forms, all a sales
persons records are sorted by a query and displayed on their screen with a
form. recently i started getting random entries that do not appear in a
sales person form. when i log in as admin i see the lead assigned to the
salesperson and everything looks ok but they cannot see it on their screen
replaced the front end files for the user no luck tried an older vwersion of
the front end no luck. it only happens sporadicly and cant figure out why
any...::: Sort macro with empty lines at the end. ::: Macro de tri avec lignes vide en bas.
Hello, I would like to create a marcro that sorts data and keep the
blank lines at the end (please see the attached file for details
http://cjoint.com/?hevVdaabOb)? THANK YOU Jacques
Bonjour, Quelqu'un peux-il m'aider =E0 cr=E9er une macro de tri avec les
lignes vides en bas (voire fichier ci-joint pour les d=E9tails
http://cjoint.com/?hevVdaabOb) ? MERCI Jacques
You can't sort formulas, you will have to change them to constants then sort
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mail...Access Data Pages
Can Any One Know Where Can I Find a Helpfull Example To Learn About
Programming Access Pages, If Possible I Need A Sample Project
...Data Validation Input Message Format
Good Evening All
With Data Validation, and having an 'Input Message',
is it possible to format this message, and resize the message pane?
Help awaly greatfully received.
The font size in the list can't be changed.
You can make the font appear larger if you increase the zoom setting
(manually, or through code).
See Debra's site for more information about Data-Validation
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
"mpb1" <firstname.lastname@example.org> wrote in message news:..."Last Updated" data disappearing
When I update my portfolio, the "Last Updated:" field is completed with the
date and time. If I then go to another page such as "Bills" and then return
to the Portfolio page, the data has disappeared. I am using the trial
version of Money 2006. Money 2003 maintained the "last updated" data until
the next update. Is there a way to correct this behavior?
In microsoft.public.money, FredQ wrote:
>When I update my portfolio, the "Last Updated:" field is completed with the
>date and time. If I then go to another page such as "Bills"...Avoiding returning a 0 when no data in cell
I have worked out the formula I need to use (with help from someone
from this group).
However how do I stop it returning a 0 when no data is present in the
You may want to suppress the #n/a error, too:
> I have worked out the formula I need to use (with help from someone
> from this group).
> However how do I stop it returnin...Secondary Sort by month
I have a worksheet that I need to sort by department name and then
month, which appears as January, February, etc. However the option to
sort by month in proper chronological order doesn't seem to be
available unless the month is the primary sort key. How can I use month
name as the secondary sort key. Thanks,
Add a helper column to get the month number and sort on that
(replace somewhere in email address with gmail if mailing direct)
"Tanya" <email@example.com> wrote in message