Pasting data from Excel
I'm not sure if I should be posting this question here or in the Excel
forum but here goes. Is it possible to copy data from multiple cells in
Excel and then paste them into multiple lines of the criteria section of an
Access query? For example, Given cells and values: A1- 1
I would like to be able to copy this data from Excel and paste it into an
Access query like : Criteria: 1
I am using Access 2002 SP3 and Exc...Excel Drop Down Box
I'm trying to edit an excel worksheet that has drop down boxes.
However, the drop down boxes are not typical forms. These drop dow
boxes appear to be normal cells (They contain text). When I click o
the box, a little gray box shows up w/ a down arrow to the right of th
cell. However, if you right click on the cell, there aren't an
property options that are displayed.
I was wondering if anybody had any idea what kind of drop down box thi
is. How can I edit or create one
Message posted from http://www.ExcelForum.com
It sounds like it's under Data|Validation.
chris313 wr...How to use outlook address in Excel
I have an Excel sheet which I use as an invoicing-application. I would like
to retrieve address-data from Outlook where I keep all my contact-data of my
customers. So, I want to select a customer from my Outlook contactlist when I
am writing a new invoice in Excel.
In Word, I have a macro which does this, but unfortunately the
Application.GetAddress does not work in Excel.
Can somebody help me ?
"Henny Slokker" wrote:
> I have an Excel sheet which I use as an invoicing-application. I would like
> to retrieve address-data from Outlook where I...Unable to create email rules! Any suggestions...??
Hi, I would like to create a rule for Outlook 2003 email, but I find no
"rules and alerts" option under the "Tools" menu. It is entirely absent, not
(When I've looked up how to create a rule, it states you click on "rules and
alerts" under "Tools")
Would appreciate suggestions.
Do you have a mail account installed? Are you in the in-box when you look
for this option?
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 wi...how to select multiple text boxes in excel for formatting
I am trying to select multiple text boxes for formatting the font but seem
unable to select all of them other than to click on each one individually.
Is there an easy way to select all of the text boxes at once?
To select multiple objects on the sheet --
Click on one object
Hold the Ctrl key, and click on additional objects
To select all the objects on the sheet --
Choose Edit>Go To, click Special
Select Objects, click OK
Or, to work with specific objects, you can add the 'Select Multiple
Objects' tool to one of your toolbars:
Select the Commands tab...Percentage Column Charts
HI!! I think I am thinking too much about this and it is easier than it
seems, but I cant figure it out! hopefully someone can help.
So I need to create a chart with 2 column...plan vs. actual. But I need each
of these bar columns to be separted by percentages of the categories that
make them up.
EX: I need to make a comparison on how big of a percentage the Labor part of
the Budget was when they planned and how it differs from the actual
Thanks for your help!
Stacked Column Graph
Set up as
code ACT PLAN
a 1 1
b 3 2
c 5 3
d ...excel margin issues on landscape
When I print a spreadsheet I cant get it to print to the full page - it
prints smaller unlike older excel program.
Also when i set the margins for a spreadsheet the left hand margin wont move
over to the edge of page like right hand side?
In Page Setup: If you are using the Scaling option to print to a certain
number of pages wide by pages tall and/or you are using the columns to repeat
at left, try:
- clearing the number of pages tall value (so that it is blank), and/or
- if you are printing to one page wide, remove the columns to repeat at left
"Peter MB" wrote:
>...How to create 20% off coupon?
the idea is that if you have do not want to keep complete information of
customer then create the customer default for coupon as "COUPON customer" and
give 20% discount in customer option. Second if you don't wanted to apply
this then other option is apply the specific pricing to specific customer
i.e. price a,b,c,d and setup the sales prices. Let me know if this help you.
> Any ideas?
...Can I only allow printing to pdf in Excel?
I have created a template in Excel which has been set up so that the layout
is perfect when printing to pdf (which is how the document will mostly be
used) but the layout changes if printing direct to our printer. Is there a
way that I can ONLY allow printing to pdf from this document?
You may consider using some VBA to achieve this.
One way is to use the Workbook_BeforePrint event and specify the pdf printer
in the PrintOut method, eg:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PrintOut copies:=1, ActivePrinter:="CutePDF Writer on CPW2:"
Pl...Excel macro list
In Excel 2003 I used to be able to list all macros in a workbook by pressing
Alt+F8. Now all I get is a series of ribbon help letters... What's changed?
Is there still a way of accessing macros via Alt+F8?
Any suggestions appreciated.
ALT+F8 works for me in E2007. What do you mean by 'I get is a series of
ribbon help letters'
> In Excel 2003 I used to be able to list all macros in a workbook by pressing
> Alt+F8. Now all I get is a series of ribbon help letters... What's changed?
> Is there still a way of...End user wants to create items in Global Address List
I have an end user who wants to be able to create distribution lists and
entries in the global address list. Any idea how I can configure him to do
he would have to have Exchange permissions, and that isn't a particularly
"Douglas McIver" <firstname.lastname@example.org> wrote in message
> I have an end user who wants to be able to create distribution lists and
> entries in the global address list. Any idea how I can configure him to
...XY chart labeller Issue: (Magic quadrant) But with a twist.
I have the same problem as has already been discussed on the forum (see
below@ end of my email), but in my case there is an additional twist.
The orginal issue was solved by using Rob Bovey's XY Chart Labeler to add
labels. The free download is at his web site:
But in my case I have lots of XY points (155 to be precise). The problem is
that 155 visible labels make the chart look very messy. Is there anyway to
make the XY labels invisible until you hover over them with a mouse/pointer?
Any help would be greatl...query will not write to excel
I have set up a query to a Foxpro .dbf file in a database from excel. When I
tell Excel to import the data it it appears to be working but never seems to
return the data. Running the same query via msquery.exe returns the data with
no problem. Can anyone tell me what the problem is ?
...How do i navigate between sheet tabs from my keyboard?
It would help my data entry immensly by not having to use the mouse.
CTRL + PageUp and CTRL + PageDown to cycle through sheet tabs.
Gord Dibben Excel MVP
On Mon, 2 May 2005 17:02:02 -0700, Ryan T <Ryan T@discussions.microsoft.com>
>It would help my data entry immensly by not having to use the mouse.
ctrl-pgup and ctrl-pgdn will cycle through the worksheets.
ctrl-F6 and ctrl-shift-F6 will cycle through the open windows. (As will
ctrl-tab and shift-ctrl-tab.)
Ryan T wrote:
> It would help my data entry immensly by not having to use the mouse.
Da...EXCEL FORMULA #28
I'm trying to fine a formula which would show me how much money I would
save on a mortgage if I were to pay additional principal each month--in
addition to paying the additional principal how long would it take to pay
I'm looking at a 160k mortgage at 7.5 for 30 years. I'll like to pay this
off as soon as possible by paying additional principal each month.
There are tons of free templates at:
Maybe you'll find something you like.
> Good afternoon,
> I'm ...Compare 2 Worksheets Create a 3rd depending on results
I have a unique problem that none of the other posts or shareware seems
I have 2 worksheets (orig.xls and new.xls) that are 15 columns wide (to
the "O"). The data is just numbers but the second column either has the
words: "new" or "cancel" which is important as you will see. I need to
compare the two worksheets and create a third worksheet (update.xls)
depending on the three possible results:
1) If a row is removed in the new.xls file = copy the row from the
orig.xls file and make the 2nd column "Cancel"
2) If a row is added to the new.xls...chart question #4
Can anyone please give me some guideline on how to draw a chart with y-axis
is the count of the item in x-axis? I am using Excel 97. Thanks.
I am not certain I fully understand your question, but I am going to give it
a stab. Excel charts are very flexible, and I think you need to keep in mind
that you need to have the right data in place to draw the chart. I.e. don't
focus on the chart itself, focus on the data in the spreadsheet you are
trying to chart, and once that is in place, your chart will look the way you
> Can...OLE: Excel.Application
in VB.Net, I use Excel to display results :
dim xl as new Excel.Application // creates an Excel process
// snip (putting values into cells)
xl.Visible = true
If the user closes the Excel file and then my program,
the Excel process is killed in memory, which is good.
If the user closes my program first and then the Excel file,
the Excel process remains in memory !
How can I make sure the process will be killed ?
You need to set
(and before that ensure that excel doesn't halt and ask things like "save
changes?" on quitting) somewhere in your p...Creat a time book
I'm building a semi automated time book in Access.
what i want is to be able to give access a two week period prefferably by
specifying the beginning and end dates and have access add an entry to a
table i'm going to call the 'Time Book' for each person in a personnell table
for each day.
the best i have been able to come up with is to pack a Macro with 14
queries, each adds one more day to a specified starting point.
one of the problems i'm running into is that some of the shifts run over
night and Access doesn't calculate the shift end correctly.
I wo...How to order chart in descending order of Freq?
I am using Access 2000-03. The graph is a subset to excel, but very close.
I have a Access Graph Chart with the Row Source set to:
"TRANSFORM Sum([Freq]) AS [SumOfFreq] SELECT [Personnel] FROM
[Rept#704_Joint_Personnel] GROUP BY [Personnel] PIVOT [RP];"
Currently, my graph order the personnel in Ascending order of Personnel. I
want to now order it by Descending Order of Freq.
In the query [Rept#704_Joint_Personnel], I have the following fields:
Can someone please help me here!
I don't know how you'd have to modify your ...startup excel euro symbol
when i digit € symbol inside any application excel 2007 automacic startup and
for me is impossible to use this symbol anywhere, i use windows xp
professional ..have you a response to solve this problem?
...How to create a scrollable dialog box ?
I've created a dialog resource (it uses CDialog as the base class) that is
longer than the height on the screen (this is for WinCE, but the question
still applies to desktop windows).
I want the user to be able to scroll down the dialog filling in data in
editbox's as they go.
How do I get the dialog to be scrollable (i.e. a scroll bar at the right
hand side that works as a CScrollView would).
In eVC++ (and in VC6 also) there is a box to tick of a vertical scrollbar
(in the resource
editor) but the scroll bar seems to be disabled at run time. Are there some
window messages that ...Excel 2003 Print Issue
I have created a spreadsheet to help with a university engineering
assignment and I have added a worksheet that is basically an
automatically generated report of all the calculations.
I have set the Print Area up in such a way so that the results are
printed out in well defined pages (e.g. page 1: title page, page 2:
summary of input variables, page 3: summary of calculation results
etc). The report is arranged vertically in the worksheet, so the pages
are 'stacked' on top of each other.
It prints out fine in Excel 2000 and 2002 but I recently upgraded to
Excel 2003 and now find tha...Export relationship information from Visio to Excel
Is there a way to export information regarding relationships from a visio
diagram to an excel spreadsheet?
In addition, is there a way to tell the excel spreadsheet to eliminate or
change a relationship and for that action to be applied onto the visio
as a general answer I'd have to say "no, not without custom code". You
didn't define what you meant as a relationship.
"Ivan Salas" <IvanSalas@discussions.microsoft.com> wrote in message
> Hello all,
&...Excel Graphing Line References off when chart is a sheet.
I have noticed that when any graph is created in EXCEL and you hover you
mouse over the dataline you receive that corect response. If you convert the
chart to a sheet, the hover of the data line is now not representative of the
the y axis directly below it. The data being graphed is correct now the hover
represents the "series" (x-Axis) correctly but does not represent the "Point"
(y-axis) correctly at all. Tne Y-axis datapoint reference is wrong. Any help?