Excel Drop Down Boxes #2
Question; does anybody know how to add additional data to a previous
drop down box? I have created a form that has several drop down boxes
a while ago, and due to some information that has been change I need to
input more info in the drop down boxes but for some odd reason I cant
remember how I executed these actions!! If it helps I am using Excel
CRS's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27444
View this thread: http://www.excelforum.com/showthread.php?threadid=46...PDF Table to Excel Spreadsheet
This has been asked in numerous places all over the web but I have not
found a workable solution. We have a mainframe system that generates
PDF reports for billing. However, few people in our organization
these days speak mainframe. We need Excel to do calculations on the
data. I began working on a method for converting using UEdit Macros
and an Excel macro because the fields are fixed-width. My attempts
have been unsuccessful.
Here is what I want to accomplish:
-Copy a region of text from a PDF
-Paste into Excel
-Break the values out into the appropriate cells.
http://www.google.com/sea...HELP! Need to save in Excel 2.1 format
I have excel 2007, and the datasystem here only accepts excel 2.1 format
How can i convert or save in excel 2.1 format?
I'd really appreciate any input, even link to some external convert program.
Why you don't try to save it as excel 5.0 It should work
when saving as scroll almost to the bottom there you will find excel 5.0
> I have excel 2007, and the datasystem here only accepts excel 2.1 format
> How can i convert or save in excel 2.1 format?
> I'd really appreciate any input,...images in product catalog or knowledge base
anyone attempted to store images in Microsoft CRM?
Client inquiring on capability of CRM to allow images for
...Setting row height for all rows
I got an excel file that has some row height more than 17px - most fo
them (default I think) are 17 pixels.
How do I set the row height for all rows to 17px ?
anjanesh's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27132
View this thread: http://www.excelforum.com/showthread.php?threadid=538377
Highlight all the rows (click on the box at the intersection of the row
and column identifiers) then Format | Row | AutoFit (or you could
select Height ...Excel should provide an easy way to switch a column into a row, n.
A very useful feature for Excel would be the ability to easily switch a
column of data into a row. This would allow a column of entries to be used
as a row of headers, for example. Excel already allows switching a column
into a row in the charting area, but not in the spreadsheet. One can work
around this by exporting the column into Word, changing the delimiter between
fields from a paragraph mark (normally hidden) to a comma, then re-importing
the data into Excel - which will then be as a row. This would also allow
Access to import the former column into a row, which could then be...How do I use excel names with INDIRECT with charts
I want to create a Chart that does not directly reference cell-ranges (i.e.
but excel-names that make the reference sheet-independent.
My aim is to be able to copy one chart to other worksheets, which have their
dataareas at the same places like the source-sheet.
Problem: This works fine in cells but not in charts
Excel name definition:
Any idea about this?
Thanks in advance,
You have to include the sheet name in the final formula that you want XL to
www.tushar-mehta.co...setting up conditional text input
I wish to creat a senario that when certain names from a list are typed
within a range of cells, that they appear in a given color
Not enough information to make much of a guess, but see help on Conditional
Gord Dibben MS Excel MVP
On Wed, 2 Dec 2009 15:44:01 -0800, guy325 <email@example.com>
>I wish to creat a senario that when certain names from a list are typed
>within a range of cells, that they appear in a given color
Sorry, I'm a rookie. I have a roster of hockey players. 22 regulars and
many subs when regs are...Setting up Outlook for multiple users on the same computer.
Hi were using outlook on a pc running xp and two seperate
users. One user can read email with no problem and the
other can't log on to Outlook. Are there any settings
that I may have missed? We always used Outlook Express
and switched so this is kinda new to us and any help is
What happens when the second user tries to open Outlook? Is he opening it
from a shortcut? Where is the shortcut?
MVP - Outlook
*** Replies sent to my e-mail address will probably not be answered --
please reply only to the newsgroup to preserve the message thread. ...Outlook 2007 doesn't appear in Set Program Access and Defaults
I just installed Office 2007 Pro but for some reason Outlook 2007
doesn't appear in my "set program access and defaults". Outlook
Express appears as my only option and Outlook Express appears in the e-
mail slot on my start menu. Any ideas why?
You must uninstall any prior version of Outlook and re-run setup using a =
custom installation and make Outlook available.
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...Excel
i use Excel with office xp. i have a form we have made that requires client
Name, Address, Phone, Fax etc etc etc...
currently i keep all those contacts within my outlook contacts...
is there a way i can type in the client business name in that cell, and have
excel do one of the following:
autofill with available address, phone, fax, PC, City/Town, contact...
give me a choice of available contact...
keep in mind, the Address, Phone, Fax, PC, City, Contact Name are all
different rows and colums...
Export your Contacts from Outlook as a *.CSV f...Excel VB Code Error
I am trying to create a .csv file from an Excel workbook
using a VB module and am wondering if someone can tell me
what's wrong with the below code:
Public Sub CSV2()
Application.DisplayAlerts = False
ActiveSheet.Name = "Temp_10001"
For Each ws In Worksheets
If ws.Name <> "Temp_10001" Then
x = ActiveSheet.UsedRange.Rows.Count
If x > 1 Then ActiveCell.Offset(x, 0).Select
ActiveCell.PasteSpec...Problems saving excel file from outlook
I have an EU that whenever he saves an excel file from
outlook, it will rename the file (by adding the number "2"
at the end of the file "file2.xls") and it also changes
all the embedding links in the document. (The embedding
link of F:\users\file.xls changes to c:\documents and
Are you setting a Hyperlink base for your links? See Menu
> File > Property > Summary tab. Put the original folder
location there and when you move or save the file the
links will not be renamed. Also assigning a letter to the
drive can cause problems (not ...Line Chart #13
The following is my data and I need to chart this. Is it possible to have a
range in one cell?
Thanks for your help in advance
Experience (Years) Large Medium Small
1 $90,000-$100,000 $75,000-90,000 $65,000-78,000
2 $92,000-100,000 $80,000-95,000 $75,000-85,000
3 $105,000-130,000 $90,000-100,000 $85,000-95,000
4 $117,000-150,000 $100,000-115,000 $90,000-110,000
5 $140,000-170,000 $115,000-130,000 $100,000+
6 $140,000-190,000 $135,000+ $100,000+
7 $170,000-250,000 $135,000+ $110,000+
I am running RMS ver 1.3.0203.
I am currently changing credit card processors. I go into RMS
Administrator, connect to change my EDC settings to match my new merchant id
number and et cetera. When I make the changes and click okay they instantly
revert back to the original. Is there a reason this is happening? Do I need
to run a refresh or a repair on this?
log on to your computer under the Administrator account, then start the SO
Administrator program and connect and change your settings.
"llabeoll" <firstname.lastname@example.org> wrote in message
news:3C24...Excel tab as windows
Is there a way while running Excel to be working on one tab and open another tab as a smaller window that is always on top. So I can enter information in both tabs without having to minimize, maximize, or switch back & forth?
you could align the windows so you can see both at the same time. But a
'always on top' option does not exist AFAIK
> Is there a way while running Excel to be working on one tab and open
> another tab as a smaller window that is always on top. So I can
> enter in...Refresh pivot chart when info in a cell changes
I am looking for help with a Macro. What I ultimately want to do is refresh
a pivot chart when the user makes a selection from a list (in a data
validation cell). For example, I am an end user that selects my territory
from a "drop down". The pivot chart will update to the information that is
directly related to my territory. Thanks in advance for your help.
Excel 2007, PivotTable
With Table dependent drop-downs
instead of data validation drop-downs.
With non-event-driven macros.
...can cvs files be opened using excel viewer
i have a user who cannot open cvs files with excel viewer but can ope
with the full version of excel...anyone experienced this problem and i
so, can you pls post the resolution
darriel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2388
View this thread: http://www.excelforum.com/showthread.php?threadid=37522
There is nothing in the description of the Excel Viewer to suggest that it
can read anything other than true XLS files.
http://support.microsoft.com/default.aspx?scid=kb;...how do i search an excel sheet for links to another spreadhseet?
Is there a Find function that allows me to look for links in a sheet?
When I can't find links, I'll use Bill Manville's FindLink program:
> Is there a Find function that allows me to look for links in a sheet?
...data labels in charts
This is a probably one of the simplest questions but I'm just starting to
I have entered a category title "year" in cell A1 and entered from 1995 to
2000 from A2 to A7 that I want to appear on the horizontal axis. I have
entered a title in B1(unemployed) and 5 values B2 to B7 directly below. When
I choose a "column" chart my vertical axis appears correctly but the
horizontal axis does not include the years as labels. The labels that appear
are the numbers 1 to 6 instead of 1995 to 2000. How do I make the chart pick
up the data labels from colu...Excel Reader scroll bar???
I'm using an Excel viewer to read e-mail attachments from
my home office. I don't have Excel installed on my
machine, only the viewer.
Often I do not have the horizontal scroll bar. I have
tried maximizing the window and still no luck.
Any solutions for this?
...data extraction from excel
I need to pull information from one collumn. If the collumn is comprised of
yes's and no's, can excel create a list of just the yes's?
Try something like this:
Assuming your list is in A1:B100, with
D1: Question (the same col heading as A1)
E1: Response (the same col heading as B1)
Select your list (A1:B100)
List Range: (already selected)
Criteria Range: C1:C2
Click the [OK] button to filter the list in place.
To copy the matching records to another area:
Click: Copy to another location
Copy...batch importing of mailing lists to Excel
I've got a mailing list of around 1000 names, stored in both Word and
Entourage like this: First Name Last Name <e-mail address>
Once I’ve eliminated the < >, do I then have to individually copy & paste
(or type) all the info in three Excel columns? Or is there a simpler solution
for batch importing of mailing lists to the Excel spreadsheet?
> I've got a mailing list of around 1000 names, stored in both Word and
> Entourage like this: First Name Last Name <e-mail address>
> Once I’ve eliminated the < >, do I then ...Excel Slooooow. It takes 4 to 6 seconds to perform each input or command
Operating System: Mac OS X 10.6 (Snow Leopard)
I have just installed Excel 2008 on a new installation of Snow Leopard and it does not work properly. It takes ages to register every input or command, like a large Lag. <br><br>EG. each figure or text, input into cells takes 4 seconds from hitting enter to accepting the input. Changing the width of a column takes 6 seconds from letting go of the mouse after dragging to the new width. etc etc. <br><br>I have checked for updates. Any ideas?
> I have just installed Excel 2008 on a n...Importing and updating Products in MS CRM...
We are speaking to one of our clients on MS CRM implementation.
However we are stumped on one issue.
They have more than two thousand products and the price of these
products changes as frequently as once in a month.
Using DMF, we can import the products one off but how about updating
the prices at least once in a month.
Is there any user friendly utility available for MS CRM that can be
used by our client to import Products information on regular basis?
May be that someone will suggest SCRIBE but it is too pricey.
Any help is appreciated.
We had the same situation, and even ...