I am quite a beginner with excel and don't have a lot experience with
the terminology, but I hope that you will understand my problem and can
help me. :)
What I have is a table like this:
January 1st, 2001 | 200 �
January 22nd, 2001 | 180 �
January 24th, 2001 | 230 �
What I want now is a chart, which displays the money in my imaginary
puse for each day from January the 1st to January the 24th.
So to speak, there are 200� in my purse on January the 2nd and 180 � on
January the 23rd.
Is there any elegant way to accomplimish this? I don't want to fill out
the standings for eve...Viewing Worksheets withing One Workbook
My PC Excel (2002) allows me to have many worksheets within one workbook. I
can see the tabs at the bottom of the workbook to access each sheet. Does it
work the same in the Mac 2004 Excel? The MAC person I am sending my PC
workbook to says he can only see one worksheet when there should be four. He
doesn't see any tabs at the bottom showing the different sheet names. What
can I have him look for to find these sheets? Thanks once again :)
No Tabs can be seen?
In Excel for Windows you would go to Tools>Options>View> and checkmark "Sheet
Tabs" or hit CTRL + P...Multiple GROUP BY in a SELECT
I am trying to do something simple but failing. I am trying to get
aggregate data with different conditions in a SQL query.
That is, with a table date,fooA,fooB, I want to output rows containing
year, average fooA (where fooB=1) average fooA (where fooB=2) average
fooA (where fooB=3) group by year(date)
The tests I need on fooB are rather more complex but this is essentially
what I am after, but can't break it down into a single query. UNION
merges rows from different queries and I want to merge columns!
"Xmas" <email@example.com> wrote in message
n...Multiple Queries to Multiple Reports
I have a database that tracks cadets that will commission into the military
and they are broken into their year groups.
My problem is that to generate a report for each year group I need a
seperate query for each year group so I have multiple reports and multiple
queries in my database.
I'm trying to figure out a way to eliminate all those quieres down to one
query and report so when I click the button to bring up the report a box will
open up asking me to type in the year of commission and then the report will
only show those cadets commissioning in that year.
Any hel...linking a column in one spreadsheet to another spreadsheet
Hi, I'm trying to link all cells in a column in one spreadsheet to an
identical column in a separate (but identical) spreadsheet. I can do it
for one cell (type = in destination file and click in corresponding cell
in source file), but I cannot make it fill down to capture the rest of the
cells in the column. Thanks, Nikki
Look at the cell reference in your link......if it's like $A$1, change it to
A1 and then it will copy down......
Vaya con Dios,
"N Richard" <NicRicMail@yahoo.com> wrote in message
news:firstname.lastname@example.org...Create Multiple Bugdets within a Fiscal Year
We have a client looking to create multiple budgets under one year, is this
possible with Microsoft Dynamics GP 9.0?
On Wed, 10 May 2006 12:31:02 -0700, Lisa
>We have a client looking to create multiple budgets under one year, is this
>possible with Microsoft Dynamics GP 9.0?
You can have an unlimited number of budgets for the same fiscal year.
"Lisa" <Lisa@discussions.microsoft.com> wrote in message
> We have a client lookin...How to import multiple distributions with Integration Manager
I'm new to GP and IM so bear with me, please. I'm trying to import a CSV file
with detailed credit card expenses. I want to import this as one journal
entry (for the total amount against one account) and each line item from the
file should be a separate distribution of that journal to the associated
account from the file.
I just don't see a way to do this: if I use a General Journal I get one
journal for every line in the file and I can only specify one account. If I
use Fixed Allocation or Variable Allocation, there is no place to specify the
amount. Its sort of like a spl...Entering 2 incomes, one self-employed
My wife's income is from an employer, who withholds taxes. I am
self-employed, so my freelance income has no taxes withheld.
What's the right way to enter the income(s) in Money? Should my wife's be
entered as Paycheck-->Net Pay?
I plan to use Money to estimate quarterly withholding taxes for myself, but
do not want my wife's income included in that calculation. Do I need to
specifically label income as either hers or mine? Or will Money know that
"Net Pay" has already had taxes taken out?
Thanks for any help.
Use the paycheck wizard for your wife. Con...VLookup
I am trying to create a vlookup formula that will lookup one value and
return many results. I have a spreadsheet that contains Sales Reps and all
the accounts each Sales Rep has. Worksheet 1, for example, will have column
A with all the different reps - REP1, REP2, REP3, etc., none sorted in any
particular order, column B will have the name of their account - Joe's
Diner, Cat Motel, Inc, Bob's Carwash, etc., and Column C will have the
monthly sales volume for that account - $23,232, $15,875, $4,222, etc.
In Worksheet 2, I have a particular Rep that I want to lookup all the
accounts fo...Add % to a graph
Can you add a % sign to your graph information? I have three rows, 2008,
2007 & % inc/Dec. I can not get the % sign to show on the graph.
Where are you wanting this? If as a series legend or an axis title, you can
include any text you like.
"Marie" <Marie@discussions.microsoft.com> wrote in message
> Can you add a % sign to your graph information? I have three rows, 2008,
> 2007 & % inc/Dec. I can not get the % sign to show on the graph.
The easiest way is to format the ori...ExceL Options: Add a chart for Box-plot type and Range function
I am a Process Engineer in a semiconductor manufacturing facility. I have 2
1. I use extensivelly a range calculation which is simply the maximum value
minus the minimum of a population. It would be very useful to have a function
(called range) to have it done at once instead of having to type max()-min().
2. For populations comparisons we use box plots. It would be nice to have a
chart type for box plots.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this sugge...Multiple namespaces
Is it possible to write the following with the use of XML? How?
Can someone help me out.
Thanks in Advance
> Is it possible to write the following with the use of XML? How?
That is a start tag of an element with local name RDF, prefix rdf bound
to the namespace URI http://www.w3.org/1999/...Multiple email aliases but emails sent to always show same display
Have an AD account that has multiple SMTP email addresses. However, any
emails sent to one of them always show being sent to the users display name
so theres no easy way to tell exactly what email address it was sent to.
Does anyone know what we can do?
Only thing I can thing of is creating separate AD accounts for this emails
but that is a way too long winded.
Monkey <Monkey@discussions.microsoft.com> typed:
> Have an AD account that has multiple SMTP email addresses. However,
> any emails sent to one of the...Multiple Update values in one query
Can I use multiple values in one update query to update one field based on a
value in the field. I have a field that can have 5 possible codes (0,1,2,3,8)
and I would like to run one update query (I know I can write 5 different, but
hope can do in one) to change these values to their actual device
equivalants, for easier to read. If value = 0 then Pollcat II, value 1
Pollcat III, value 2 Netlink, value 3 CC3, value 8 FTP. Is there a way to
do a Case type statement in an update query?
Thanks in advance
On Jul 6, 1:26 pm, Kenny A. <Ken...@discussions.microsoft.com> w...Delete contact from multiple distribution lists
I manage multiple distribution lists, and often have to remove a
contact from myriad distro lists. Is there any way to pull this off
without having to delete the contact from each list individually? I'm
using Exchange 2003.
Not that I know of - by the way, Exchange questions can be asked in =
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Stockmoose16 asked:
| I manage...Using Excel one time only...
I have been asked by my boss to put together a form that creates
timetable and I can't figure out for the life of me how to make i
It's just two sheets. If it were figures I think I could cope, but
seem to have encountered a mental block - any help would be mos
Left hand column contains the names of all the managers, top row hold
the days of the week. The rows for each day are for the input o
particular shifts (9 in total).
What she wants is a timetable here; days across the top again, but th
shifts in the left column, so the managers'...Setting up multiple accounts
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
Hi guys, <br><br>Just switched over to the mac world and am now setting up my email. <br><br>I have 2 separate email address all hosted on the same mail server - mail.tpg.com.au <br><br>I added my default email address which works fine in Entourage but I continue to get the following error message with my second email account: <br><br>Mail could not be received at this time. <br><br>The server for "Cheekyage's" r...Multiple (two) back-end MDB's.
How does one go about structuring the concatenation
of back-end DB's? That is, for example, a single
application that has one back-end that is common at
each of multiple locations and a ("site") second back-end
that is peculiar to each of those locations.
The common mdb would desirably be read only while
the "site" mdb would be updateable.
Given that there's a straight forward answer to this
question, my next question would be how to create
the common mdb based on a query of a "master"
DB. (The "master" location being the point of
...Forward generic email to multiple accounts?
We have several "generic" email accounts; "email@example.com", "firstname.lastname@example.org",
We need to make sure several different individuals receive any email sent to
The forwarding feature in the user account properties only permits one
address as a forwarded recipient.
Permitting users to "also check these mailboxes" in Outlook seems to direct
the email to whomever checks the generic mailbox first.
How do we get mail the generic mail to several people simutaneously??
create a mailing list and forward to that list
"S...Two accounts asign to one mailbox (owa)
How to asign two accounts to one mailbox, and can read
mail by owa. When i use permision "Send As & Receive As"
for users, it works but only in Outlook.
There is no way to use OWA to open two mailboxes like you do in Outlook
using the Folder List but you can access a mailbox that you have permissions
by connecting to it directly. I am actually working on testing this tonight.
I will let you know exactly how to do this once I get it figured out myself.
"Irek" <email@example.com> wrote in message
news:1a84801c44f0b$00eaf810$a601280...How do I add .htm to every link in a worksheet? Multiple hyperlinks+targets
I have about 500 hyperlinks in my worksheets. An example of 1 of th
links = "..dvd/1994/940602"
As you can see, i forgot to use the file extension i wanted to link t
(*.htm) Is there a way to edit 500 links by automatically adding .ht
to each one with out me going the manual route. i
Also how do i change the "_parent" to "main" so all the links open i
the main window, and not just a new page.
When i have the page saved as html, i can go in find and replace i
wordpad which easily changes the links (searched on "target =...how to add numbers from different areas in chart and importing forms from word
can someone tell me how to add numbers from different places in a chart
i.e. lets say 10 numbers are in different places and I need the tota
of these ten- is there a way of obtaining this by selecting the
without putting in all the numbers separately somewhere to arrive at
Can a table be imported from word into excel. i.e a multi row tabl
with 2 o r 3columns and it visually will look like its in normal vie
word but in excel. can someone tell me
carole's Profile: http://www.excelforum.com/member.php?...**Multiple offices multiple deposits**
We have a number of offices that prepare their own deposits and take this
cash to the bank. We are in the process of rolling GP out to these offices
through Terminal Server and wonder how other multi office companies deal
When having multiple people creating multiple receipts and deposits within
GP, how do you handle it so that each receipt/check is easily recognizable
by the person who is inputting the deposit?
Thanks in advance for your advise!
You can have each person doing Cash Receipts or Bank Transactions code
the Receipt number/Transaction numb...Multiple database files created
I have an Access 2007 database that resides on our company's server. The
database tracks incoming and outgoing shipments and is used by several
employees throughout the day. I've noticed that in the folder where the
database resides several additional database files are created throughout the
day with names like database.mdb, database1.mdb, database2.mdb, etc. Can
anyone tell me why this is happening?
The database was created with Access 2007 using the 2003 mdb file format, as
most of the end users have Office 2003 applications.
1. Turn off...Adding a line to the line/column chart?
Is there anyway I can add a second line to the line/column chart?
Basically I have 3 sets of data that I want to plot vs. time on the
same graph. 1 using the column format, the other 2 being lines
connected by data points.
Create the chart using all the data, right click on the one you want to
change to a line and select chart type from the dialogue box and choose the
type you want. There are a few restrictions on the mix you can have though.
MOS Master Instructor
Please reply & rate any replies you get
Ice Hockey rules (especially the Wightlink Raiders)