how to use Excel 2007 Sensitivity Analysis
could any help provide a sample excel worksheet with sensitivity analysis
demo, including use of scenario manager to generate scenario summary.
...Macro to ask for a item# and then show all details for that item
i have details for parts in excel. Like to have a macro that will ask the
user for a item number and shaw all details for that item
Item# purchase sold date region
a0012 1200 400 12/12/09 Ont
b1115 500 200 12/01/09 Ont
a0012 300 50 12/05/09 Aberta
a0012 400 25 12/08/09 Ont
Thanks for any help
Might consider using an autofilter instead of a macro - Data, Filter, Auto
Filter. Then open the ...Lists in excel
Is there a way to have a list that will eliminate a value once it is already
used in a group of cells?
Have a look here:
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Kameca" <Kameca@discussions.microsoft.com> wrote in message
> Is there a way to have a list that will eliminate a value once it is
> used in a group of cells?
Gary''s Stud...I need to C&P a section of Excel to Word but I need to get it to fit on a standard 8.5x11!
Is there a way to make this happen? The sections that I need to C&P are all
the columns are 14 wide and the rows are 40, 41,44 and 65. How do I get
these to fit on the page?
> Is there a way to make this happen? The sections that I need to C&P are all
> the columns are 14 wide and the rows are 40, 41,44 and 65. How do I get
> these to fit on the page?
Smaller font, cut margins to the minimum, print landscape
Print Preview > shrink to fit, are all options just depends
on how wide the fields are. It just may be to big to fit
...xlodbc.xla - Excel ODBC Add-In
I am trying to run SQL queries directly from a worksheet in Excel. I have
found an add-in for Excel 2002 that is no longer supported in 2003 or 2007
which is just what I want (xlodbc.xla).
1. Why was this discontinued?
2. Is there a built-in way to do this in newer versions [running queries
from a cell, NOT going to Data > Import > etc...]?
3 Any other thoughts, help, advice?
If you are looking to run a parameter query there are much better ways, You
may find this helpful.
About 3/4 wa...Microsoft Word
I'm trying to get a list of all the files a Microsoft Word document is
hyperlinked to. Is there a way to have Word generate or show a list of all
the files a Word document is hyperlinked to?
On Tue, 4 May 2010 14:50:01 -0700, ikovy
>I'm trying to get a list of all the files a Microsoft Word document is
>hyperlinked to. Is there a way to have Word generate or show a list of all
>the files a Word document is hyperlinked to?
Use this macro (see http://www.gmayor.com/installing_macro.htm if...Excel 2003 question about help menu
I use Excel 2003 OFF-LINE. I find myself extremely limited and
frustrated with the "menu approach" that it uses as well as the set
number of items it will display as the result of a keyword search.
The main problem for me ATM is that I know that the functions are
categorized into say eight categories, e.g., text, but I don't always
remember all of them. In the past, a search in Help would return a
list of those categories from which I could quickly and easily navigate
around to doublecheck my understanding. Search results in Excel 2003
are erratic, and trying to find the list...GP 8.0 drop-shipments and costs
Is it true that Great Plains 8.0 has some issues with drop-shipments and
costs in SOP?
I am not aware of anything different between GP 8.0 and 9.0 with respect to
drop-shipments and costs in SOP. Are you seeing something specific that is
not working as expected in GP 8.0?
Dynamics GP MVP
Flexible Solutions - home of GP Reports
"childofthe1980s" <email@example.com> wrote in
I have a regular task that I do on a pivottable that looks like this (but
No Code Total
1 DN 841.92
2 RDB 0.00
3 PRP42 3,435.76
Grand Total 672,328.19
I paste this info into a database which requires the number to be repeated
on each line.
At the moment I use a macro to copy the data down to the next entry as shown
below starting in the cell that has No in:
Selection.f...Excel 2007 chart line types
When using Excel 2003, I was able to copy charts, and then paste them into CorelDraw as metafiles, ungroup these, and use the lines from the charts in my graphics. Since upgrading to Excel 2007, I am still able to do this, but the lines now appear to have a more complex format (the compund type is mentioned in the line properties dialog), made up of border and line types. On exporting to CoreDraw, these lines appear much less uniform than previously, changing thickness along the length of the line. Is there a workaround to allow me to plot chats with non-compund type lines as was po...Can't get bar code font to work in EXCEL 2003
I have a simple formula that converts a part number to a 3 of 9 bar code font
in Excel 2003. Works great on my computer but a co-worker, who also has
Excel 2003, can't get this to work. On her PC it show the 3 of 9 font in
the drop down box but in the cell it is not converting it to a bar code
Most likely the font is not installed properly...
She needs to reinstall the font. It can be done through Control Panel ->
Fonts if you have the font available.
> I have a simple formula that conve...Line Graph in Excel
I have created a line graph in Excel (with my input data on a separate
worksheet). I have 3 columns: Planned, Actual, and New. I am tracking
'requirements' and I only want 2 lines on the graph. I have plotted the
Planned and Actual, however I want the 'New' to be added to the 'Planned' in
the graph. Maybe my example below will help?
Planned Actual New
A 10 8 0
B 15 12 2
C 20 17 0
D 25 23 ...repeating a data pattern in excel
Im using excel to run a class register for a playgroup. Each pupil is booked
in for a number of days per week. To show their forecast for the year, I'm
manually entering the days they're going to be present each week - is there a
way to do this automatically?
For example, Ben is booked in for Mondays, Wednesday and Fridays - how can I
copy this weekly pattern throughout the year without manually tabbing across
and ticking the relevant days?
Hi, Kel. To do this manually, but easily, type the first 3 "sets". Select
them all and copy down using the fill handle. You coul...Conditional line/arrow
Is it possible to have a line or arrow drawn between two cells if the amount
entered in one cell exceeds a control value in another cell?
I compared A1 with D10. I put a line from the drawing toolbar between these two
With that line selected, I typed a new name for it in the name box.
I called it: LineA1_D10
(just to distinguish it)
Then I rightclicked on that worksheet tab and selected view code. I pasted this
into the code window:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Ta...Outlook 2000 Can't find contacts for Distribution list
In Outlook 2000 on Windows 98SE
I have added contacts and want to create a distribution list
I go File->New->Distribution list
Then click Select Members.
In the drop down list box next to the text "Show names from the:" there is
nothing!! I expect to be able to set it to the Contacts folder but when I
open the list box nothing is there.
Any ideas? Thanks
Is the Contacts Folder enabled as an email address book in its properties?
"MS" <firstname.lastname@example.org> wrote in message
> ...excel vba
i would like to bring up the file save as dialog box and defalut to a
file type of xls..
here's what i'm using...
'i have a path and file name in Newfile
NewFile = Application.GetSaveAsFilename(myfilename, "*.xls")
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
newFile = Application.GetSaveAsFilename(Initialfilename:=myfilename, _
fileFilter:="Excel Files (*.xls), *.xls")
mjschukas wro...Cannot close Excel #2
I cannot close ANY Excel document with the upper-right X
Button. When clicking the X either nothing happens or the
X greys out.
When I click on "file" "exit", the "save as" window pops
I tried uninstalling and reinstalling Office - same
...Moving word documents into excel
I'm having trouble moving a word document into excel. The problem that i'm having is when i move the document to excel, some of it is not showing up on the spreedsheet. Almost all the information is all moved to the left side of the page. I'm i doing something wrong or do i have to make the adjustments my self. Please help.
How are you moving the Word document into Excel?
You can choose Insert>Object, and on the 'Create from File' tab, select
a Word document.
This would display the first page in the Word document.
> I'm having trouble moving ...working with excel
i am using check boxs for yes and no questions,how do i
simplify the size and centering them on a row and column?
There are two different checkboxes--one from the controltoolbox toolbar and one
from the forms toolbar.
This code will fill the topleft cell with the checkbox:
Dim OLEObj As OLEObject
Dim myCBX As CheckBox
For Each OLEObj In ActiveSheet.OLEObjects
If TypeOf OLEObj.Object Is MSForms.CheckBox Then
.Top = .TopLeftCell.Top
.Height = .TopLeftCell.Height
.Wi...add-ins for excel 2001
Does anyone know if how to get the data-analysis add-in for excel-
2001? Do I have to upgrade to 2004 (which I had a difficult time
> Does anyone know if how to get the data-analysis add-in for excel-
> 2001? Do I have to upgrade to 2004 (which I had a difficult time
The data analysis toolpak is included in the Office 2001 install disc.
You can do a custom install and install just the toolpak, I think.
Co-author of Office 2008 for Mac All-in-One For Dummies
http://tinyurl.com/Office-2008-for-...Weird problem with Publisher's listing of available printers #2
None of the installed printers will show up in Publisher on this lady's
computer. They are installed in Windows and show up fine in other Office
Programs (Word, Excel, Powerpoint, etc.). However, when you go to print
a document in Publisher, the only printers listed are the "Microsoft
Office Document Image Writer" and the "Lanfax Printer". None of the
physical printers are listed!
I tried uninstalling and reinstalling all the printers. I also tried
upgrading from Publisher XP to Publisher 2003, but the problem has
persisted. I have googled this and searched Micr...excel 2000 #31
How do I assign a hyperlink to a tab? I wish to save my workbook as a web
page with a worksheet tab called home that will return me to my home page
simply by clicking the tab.
I don't believe this is possible.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"rich" <email@example.com> wrote in message
> How do I assign a hyperlink to a tab? I wish to save my
> workbook as a web
> page with a worksheet tab called home that will return m...Using a List Box
Using Access 2002 VBA
I'm trying to post events in my program as they occur, using a list
Public Function StatusOut(LogItem$, ByVal bLogFile As Boolean) As Boolean
Forms!frmTest.ev_log.AddItem LogItem$, 0
Forms!frmTest.ev_log.Selected(0) = True
If bLogFile Then
If bLogging Then
PrintString$ = LogItem$ & Chr(13) & Chr(10)
If bLogFileChgBusy = False Then
Put #hLogFile, , PrintString$
If Err Then
LogItem$ = Format(Now, "...Links in Excel #3
I am using Excel and OSX.
I can link from one workbook to another. But if I change the location
of a link (for example, adding a row), I find that the object link is
still looking for the old location.
That is, if the subject of the link is in cell B5, and I add a row to
the workbook so to that the subject of the link is now in cell B6, I
find that the object of the link is still look for whatever is in B5.
Message posted from http://www.ExcelForum.com/
This does occur whenever you change the file that is linked to, without
having the file liking to it opened as...Excel worksheet embedded in Word 2002
I am working with a word 2002 document which has an embedded Exce
worksheet. The excel files perform calculations depending on what th
user fills in or selects (with radio buttons), and then completes wha
looks like a Word document.
I have 2 problems: First, I am trying to use parts of the sam
worksheet in two places in this 4-page document. Page 4 has one sectio
of the worksheet with a section that the user fills in with a numbe
ranking, 1-5, and then Cell L39 sums those rankings. The total in L3
then shows up in another area of the same worksheet, and also on page
of the Word document. Whe...