Need help mutiple worksheets to create a report worksheetI hope someone can help me
I have just started with a reasonably large homeless organisation
where they
collect large amounts of statistical data using excell. There are 25
induvidual services hence 25 induvidual data sets. Each set
essentially
contains the
1. a referral worksheet - name date etc (Monthly Tally of referals)
2. an induvidual stats sheet a variety of data (for each referal that
becomes a client)
3. an occupancy stats sheet (Like a tally sheet 1 counts for each
day
+ a Bfwd and Cfwd column)
4. a monthly summary report (combines data from all)
Whilst a Database comes to mind ...
Creating a Chart with a Secondary X-Axis, with a twist maybe?Hi,
Is there a way with Excel (both 2003 and 2007) to have a graph with two
x-axis, where the first is a primary axis and the second is a repeated axis
associated with the primary axis? For example, let's say on the Y-Axis I have
output Power. The primary x-axis I have temperature, let's say 0, 32, 100,
150. So I am plotting temperature vs. output power. However, I want a
secondary x-axis that contains part serial numbers, let's say AA, BB, CC, DD.
What I want to do is, for every temperature, plot a line with power output
values from each serial number. So I will have 4 li...
creating a flyer in publisher 2003If I create a flyer in Publisher 2003, how can I save it so that only the
actual flyer gets saved and what is the best way to save it so that I can
email it to others who may not have Publisher?
Thank You
James
Send it as a PDF. There are free converters around, this is one:
http://www.primopdf.com/
--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx
"james" <james@discussions.microsoft.com> wrote in message
news:6D75CF2C-3CE2-4E56-8205-2760A9524D10@micr...
ActiveX component can't create object #2I am getting this error when trying to commect rms 2.0 to the quick books dta
file can someone please help me thanks
--
Thanks
Ian
...
Failed to create Microsoft CRM Databases 02-18-04when i install Microsoft CRM 1.0
i faced to this error messages "Failed to create Microsoft CRM Databases
unknown error 80040e14"
please help me
my system is
windows 2000 sp4
sql 2000 sp3a
mdac 2.8
also my acccoun is in domain administrator group
thx
Hi,
You will find below 3 TKs that may help you to sort this issue out :
http://www.greatplains.com/techknowledge/techknowledge.asp?id=29393&target=PS
http://www.greatplains.com/techknowledge/techknowledge.asp?id=30300&target=PS
http://www.greatplains.com/techknowledge/techknowledge.asp?id=31908&target=PS
-...
Marginal Abatement Cost
I want to create a marginal abatement cost (MAC) column chart in Excel 2003.
The data I am using is sorted for cost ($/tonne/year). Then I have a
marginal abatement (tonnes of CO2-e) and cumulative marginal abatement (also
tonnes of CO2-e).
On the x axis I will have cost.
The y axis shall be marginal abatement, the width of the columns shall
represent the marginal abatement, and their location on the axis will be
determined by the cumulative marginal abatement. Since the data is sorted for
cost, the chart shall show increasing cost with an increasing cumulative
marginal abatement.
...
Create filtered dataset from XML file?I need to create a Dataset and datatable from an XML file. The only
way I know how to make a Dataset and Datatable, is by using an Access
database as my datastore: You know, the usual thing in all the books;
an OleDbDataAdapter, with a SQL string and connection.
How can I do this using an XML file instead of an Access table? I know
I can convert an XML file straight into a Dataset. But the dataset
always contains ALL the info from the XML file. I want the dataset to
be filtered by using some sort of query.
A couple years ago I hurt my brain figuring out Xpath. Boy, i'm just
not mea...
Access Databases created from TemplatesI have tried setting up databases from the downloadable templates from the
Microsoft website, however unlike Acess 2003 I cannot edit any of them (even
minor details).
The online help merely tells us to click on the "datasheet" tab - unless you
start a file from scratch, there is no tab! Is there any way to edit a
template with Access 2007?
Shane,
I downloaded a template and had no trouble editing it (I simply switched to
Design View of a form, a query and a table) so which one are you downloading
that you can't edit?
--
Gina Whipp
2010 Microsoft MVP (A...
EXCEL 2007 CREATING A MACROSCAN'T FIND THE MACRO SELECTION ON THE EXCEL 2007 TOOL MENU
-----------------------------------------------------------------------------
Less Spam Better enjoyable experience
Visit : news://spacesst.com
Try this
http://office.microsoft.com/en-us/excel/HA101730521033.aspx
Please use proper case when you ask a question.
--
Steve
"FIEGEHENK" <FIEGEHENK@discussions.microsoft.com> wrote in message
news:E4D183D6-3518-4D29-8133-2E0D07F4D057@microsoft.com...
> CAN'T FIND THE MACRO SELECTION ON THE EXCEL 2007 TOOL MENU
-----------------------------------------------...
Dumb question... how to create a Enterprise Formula Custom FieldGuys, I'm writing because I've tried and search but can't get it ...
From PWA I created a Project Custom Field "MyField" of type Text with the
formula
"Hello World", I tried with " and '. When I open a project the field returns
#ERROR. I published to see if magic happens, but nothing.
I did the same with type number and formula 10, same result.
So In the end, I can't get any formula to work. What am I doing wrong ... I
googled with no success.
Perhaps try opening the project and hitting the F9 button to refresh calculations?
Does ...
Exch2003: unable to create new mailboxes after replacing corrupt info storeI had a corrupt information store on Exchange 2003 so I
added a new temporary server (Exch2003) and moved all of
my mailboxes to the new server. After I did that, I
saved the copy of the original info store to another
location and created a new info store with the same
name. Then I moved all of the mailboxes back to
the "new" info store. Everything runs great - backups,
log files, email flow except for - - creating a new
user/mailbox. The user part creates fine and it looks
like a mailbox is created, but looking under the mailbox
folder doesn't show a mailbox for th...
how do i format a textbox on a userform created in excelI created a userform to accept information from the user.
My problem is ,eg i would like the TxtAmount.value to display the amount in
Currency when i enter the number. The same for the percentage control.
I am new to this.
Bert,
Text boxes accept text only, so you need to convert the value to the
formatted text that you want.
Something like:
UserForm1.TextBox1.Text = Format(Range("A1").Value, "$#,##0.00")
Same idea for percentages"
UserForm1.TextBox1.Text = Format(Range("A1").Value, "0.00%")
HTH,
Bernie
MS Excel MVP
"Bert" <...
Creating Machine shop part schedule using Excel
Hello, my name is Alex Barker and I am working for a company in Ontar
Canada called Knoch Manufacturing.
I am experienced with Excel, but not quite capable enough to complet
the project given.
We are a machine shop that has 14 different CNC machines.
We keep track of Queued, Pending , and Distant jobs for each machine
Queued- ready to run
Pending- one more operation then ready to run
Distant- 2 or more operations becure ready to run
This information also comes along with a due date and hours remainin
on operation
What we are looking for is a program that schedules this informatio
i...
Creating a carbon copy of CRM 4.0 for development purposesHi,
is there any easy or supported way to create a complete, 100% carbon
copy of an On Premise CRM 4.0 Professional deployment in order to
develop on?
The export tools only seem to deal with data and customisations, and
not cover all settings.
Any ideas?
Cheers
Richard
Richard;
Set up a similar environment to your production environment (ie, if you have
two servers in PROD, set up two servers in DEV) and then install the CRM
into this environment (note that you may be violating your license agreement
by doing this, but I am not here to judge). once CRM is up and running in
DEV, rest...
how to creat other inboxi have 3 different email account and i want each to receive in difference any
can help please
You can create other 'fake' inboxes for each and use rules to move inbound
messages therein. Methods and features depend on the version of Outlook,
which you haven't posted....
Akbar uk wrote:
> i have 3 different email account and i want each to receive in
> difference any can help please
...
How can I create a user defined function in excel?If I have a equation eg: =(A1+B1*if(t10=TRUE;1;-1)), how can I define it to
a Myfunction (A1;B1;T10)?
Use Alt+F11 to open VB Editor
Use command Insert | Module
Copy this to the newly open module sheet
Function Myfunction(x, y, z)
If z Then
multi = 1
Else
multi = -1
End If
Myfunction = x + y * multi
End Function
Return to Excel and type in any cell =Myfunction(A1,B1, T10)
But why not use
Function Myfunction(x, y, z)
If z Then
Myfunction = x + y
Else
Myfunction = x - y
End If
End Function
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove ca...
Error created when try to Print Preview or PrintWhen try to print or print preview system is generating an error:
"Print titles must be contiguous and complete rows or columns."
Used excel for years ever seen this error before.
Using Excel 2007 on Vista, we just upgraded to SP2 for both systems.
After testing a few times, I notice that system is generating a Name Range
with no referencing cell range, the name range is called Print_Titles.
If I delete the name range it removes the error message and able to use
print preview and able to print.
Notice it is occurring more ofter when client is copying a worksheet to ...
create pivot table from external csv fileI am dumping huge data to csv file, Now what I want to do is, create pivot
table/chart from csv file without importing data into it. Reason behind
doing this is, end user view updated report without messing with thier
limited excel knowledge.
Hi,
So what's your question?
If you're asking if it can be done, the answer is Yes.
If you're asking how to do it, the question is - what version of Excel are
you using?
For Example in 2003 you would choose Data, Pivot Table and Pivot Chart
Report, and choose External data source, Next, Get Data, choose New Data
Source and cl...
Create List or DictionaryHello,
I need to create a List or a Dictionary with only to items:
Id = 1, Key = "Subscribe"
Id = 2, Key = "Unsubscribe"
Is it possible to create such a list or dictionary with only one code
line?
Thank You,
Miguel
Dictionary<string, int> toto = new Dictionary<int, string> { {
"Subscribe" , 1}, { "Unsubscribe", 2 } };
Vanderghast, Access MVP
"shapper" <mdmoura@gmail.com> wrote in message
news:a31b4a74-f280-490b-a608-a5a2dfc357cb@r34g2000yqj.googlegroups.com...
> Hello,
>
> I ...
creating a customized ruleHello,
I am trying to create a customized rule that once a mail
msg reaches its expirey date it is automatically moved to
the deleted items. subsequently need a rule to
automatically empty trash. If this is indeed possible
could you let me know. Also could you tell me if it has to
be server or client based. thanks in adv!
...
Can I create a golf handicap calculatorHas any one already created one and can I get a copy of it
Doug, I've never seen, or heard, of an existing template for golf
handicapping. You might try your local amateur golf association. In
Northern California that would be the NCGA. If you find one, please post
back. I'd very much like to see it.
--
Sincerely, Michael Colvin
"Doug B" wrote:
> Has any one already created one and can I get a copy of it
...
Creating a budget in Money 2003I created a budget in Money, but can't seem to figure out
how to record my daily expenses (ie. meals, parking, gas,
etc.). I entered my monthly expenditures in my budget but
now I have no idea how to enter how much i really spent
each day. Can someone help me?
Are you talking about cash spending from your pocket? If so, here's the
relevant FAQ:
---
Q): How do other users account for ATM withdrawals?
A): Many users setup a dedicated cash account, I call mine "Pocket Change".
Transfer the money to the cash account, enter cash transactions in the cash
account, and balanc...
No CRM Buttons when creating New Outlook emailUsing Outlook 2003 with the CRM client installed, there is no track in CRM
button when you create a new email. I tried going to Outlook email go to
View > Toolbars > Microsoft CRM. That is checked.
I also tried re-enabling the CRM add-in. There were no disabled items in
Outlook > Help > About Microsoft Office Outlook.
In Outlook I went to to Tools > Options > Other tab. Clicked on Advanced
Options button, then on the COM Add-Ins button. There is a check
mark next to Microsoft CRM Outlook Addin.
I tried unchecking the Microsoft CRM toolbar and then reinstalling Ou...
HELP! Seeking Instructions to Create Report of POS (NOT RMS) Discounts Applied #2We need to run monthly reports to determine how many of our different
Discounts are claimed/used and the proceeds not tendered. We have offered a
number of discounts to customers and employees as incentives and cannot find
a method to track how each discount is applied.
The built-in Discounted Sales report in POS 2.0 lists only the resulting
Sale Price; we seek to have the report sorted by PresetDiscount type but the
Advanced Report Filter dialog does not list Discount in the Field dropdown
box and we can't locate the table in which transactions that have the Preset
Discount are appl...
Create new Exchange Mailbox without creating a new AD-UserI'm running Win2003SBS SP1 with Exchange2003 SP2.
I would like to create funtional exchange-mailboxes (info@..., service@...)
without creating a new AD-User as owner of these mailboxes. Owner should be
an already existing AD-User.
Is this possible and how could this be done.
Thanks.
Andreas
Andreas Lauer IT Service wrote:
> I'm running Win2003SBS SP1 with Exchange2003 SP2.
> I would like to create funtional exchange-mailboxes (info@..., service@...)
> without creating a new AD-User as owner of these mailboxes. Owner should be
> an already existing AD-User.
> Is thi...