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...When printing to large scale plotter, is there a max # of lines/pa
I am having problems with printing to my large plotter. Project seems to
have issue when printing 325 lines or more. The plot gets long horizontal
lines of different lengths running through my data. When I insert a page
break at, for example, line 323, the plot looks fine, but I am getting two
pages instead of just one. Has anyone else had this problem? I don't think
this is a plotter problem.
Almost always, problems related to printing are related to the system or
the printer driver. That is because Project is using the system to
print. The first thing to check is that...Preventing negative total time
In my form I have ID#, Date, Timein and Timeout, total time.
I am using the medium time format. I want to prevent the total time from
being a negative time. Example is: time in 8:00 am and time out time 3:00 pm
total time should be 7 hrs, however if a person enters 8:00 am for time in
and 3:00 am for time out I will receive a negative number. I want to alert
the person who is entering the time that you cannot enter this time as it is
before the time in.
Sorry for the confusion.
From your description, you have separate fields for date and time (and
separate timein and time...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...750 KB file saves 10 times longer than a 900 KB file
We use a spreadsheet in our office that has numerous macros. This spreadsheet is approximately 750 kb. I created another file with no macros that is about 900 kb. The 900 kb file saves enormously faster that the 750 kb file with macros
I spend a lot of time waiting for these files to save all day long. I have tried moving the macros to another sheet to see if that would help - but it only helped minutely. I have no add-ins checked (I saw that suggestion on another post). Any suggestions are hugely appreciated. Thank you.
I've never noticed a difference in time based on if a workbook cont...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 ...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...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?
...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?
I have an HP Designjet 500 plotter 24" carriage.
I'm trying to print a 22" x 5' long banner on one page. My preview is
correct. I've changed the custom document size to 22"x 5'.
I cannot get this banner to print at all.
Any help would be appreciated.
This article is for 2002, but it may help in your situation.
PUB2002: Large Banners and Posters Printed in Separate Sections
Mary Sauer MSFT MVP
"...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...How do I count the number of times a particular charcter ("." say)
How do I count the number of times a particular charcter ("." say) appears in
For example, ABC.220.127.116.11 should retun 4.
Is there a formula?
(remove nothere from the email address if mailing direct)
"RH" <RH@discussions.microsoft.com> wrote in message
> How do I count the number of times a particular charcter ("." say) appears
> a cell.
> For example, ABC.18.104.22.168 should retun 4.
> Is there ...pasting excel data in a powerpoint slide
I am attempting to paste an excel data table in a powerpoint slide but once
pasted, the data is cut off. If I double click and enter the excel data
table and resize the window from Powerpoint, the same data shown simply
stretches to the new size. I have tried numerous ways of pasting from the
excel sheet and it still acts the same. I tried a new workbook and was able
to resize correctly. But to recreate all of the data and formulas in a
different workbook would be difficult. Is there a setting or something in
excel that is not allowing me to resize this particular workbook?
Thanks...Simple coding in Excel
I have created a series of forms which go from one to another via a macro,
which is simply:
(created by record macro).
There are two issues:
1. This same code does not work when assigned to auto_macro for the first
2. After moving to subsequent forms, the previous forms are visible (but
not accessible) in the background. This just looks untidy and I would like a
command to close them.
Have you tried?
Sheets("Sheet Name").Visible = True
Sheets("Sheet N...excel time formulas
I have a column which shows a format of hours, mins and seconds an
would like to find a formula which can convert it into minutes only
Message posted from http://www.ExcelForum.com
Format the cells as [mm]
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"aly1cat >" <<email@example.com> wrote in message
> I have a column which shows a format of hours, mins and seconds and
> would like to find a f...excel 2007 home key
how do i get the home key to work. excel 2003 did it in tools/transition
When you say get the home key to "work", do you mean have it return the
active cell to A1?
Click on the Office Button (top-left of screen)
Click on the "Excel Options" button (at the bottom of the menu)
Select the "Advanced" Tab on the left
Scoll down to the bottom of the page
Look for the section "Lotus Compatibility"
Check the "Transition Navigation Keys" checkbox
> how do i get the home key to work. excel 2003 did it...Startup Template
I have a template (.xltm file) containing a macro that is assigned to a
button on the QAT for that template. The macro is in ThisWorkbook.
When I just open the template, or double-click it from Windows, the button
displays and the macros runs correctly.
I want the button available all the time so I saved the template in the
Excel start folder - C:\Users\xxxx\AppData\Roaming\Microsoft\Excel\XLSTART.
When I launch Excel the button does not display, which I take it to mean the
template has not loaded. Same result if I put the template in C:\Program
Files\Microsoft Office\Offi...Excel 2007 chart color change based on the label.
I have 12 charts 1 for each person and the data changes every week and
some of the values have 0 so are filtered out. On the chart I want
0-15 to be blue, 16-30 to be light purple, 31-60 to be a cream color,
61-90 to be light blue, and 90+ to be dark purple. With the code
below I can change the color if I take the if statement out but I
would like to change the color based on the label. I have tried
several things like .text, .name, and .label. I just can't fine the
For i = 1 To A...Typing the date into Excel
Hi, and thanks in advance.
I've recently updated from Excel 2003 to Excel 2007. I'm having a problem
with entering dates:
(1) I enter a date, say: 5/17/2009 or 5-17-2009
(2) The cell displays 0.000146 or -2021.
(3) I format the cells as "date".
(4) The cell displays as 1900/01/00 or ##### (indefinite)
(5) The formula bar displays =5/17/2009 or =5-17-2009
(6) It doesn't matter if I format the cells as dates in advance or after
entering the date.
I'm guessing that there is a setup option somewhere that is wrong, but I
can't find it. The documentation, and my ...