|
|
Order form by
Jamie
I'm creating an order form and I want to automatically
copy information from a database that is on another sheet
in the workbok.
After I enter the Item number...
|
|
1 |
589 |
|
|
|
September 16th, 2003 11:12 PM
by s-o-s
|
3 |
588 |
|
|
"Sumif"or "if" ...followup question by
Peter
Thanx, Paul, that worked! But I have another question. If
I get a "NO" and enter that in the RSVP column, can I get
the "balance due" to blank...
|
September 16th, 2003 11:24 PM
by James S
|
1 |
332 |
|
|
ROUND function or custom format by
Lucy
i'm trying to round to the nearest 100th eg 1436 to 1400,
or 1475 to 1500. i would like to use the custom since if
we use ROUND, we don't have the numbers yet...
|
|
1 |
429 |
|
|
Solving for Coefficients of a polynomial by
Dan Mertens
Is there a function in Excel that can return the
coefficients of a polynomial from a set of X values and a
set of Y values? I know you can get a trendline...
|
|
1 |
341 |
|
|
|
September 17th, 2003 12:46 AM
by Daniel.M
|
2 |
640 |
|
|
Macro by
Shane
How do I save a macro to a floppy disk so that I may copy
the macro to another computer?
|
|
1 |
294 |
|
|
Pivot Table Using Multiple sources by
td
I am trying to build a pivot table using more than 1
file/worksheet. The files have the same column
headings. I can not combine the 2 files as Excel...
|
|
1 |
698 |
|
|
Dates parameters/logic by
BILL
Not sure how to ask this and I am very much a beginner in
EXCEL.
I am trying to find a way to track periodic reviews that
are required every time an individual...
|
September 17th, 2003 02:13 AM
by BILL
|
0 |
308 |
|
|
vlookup by
ken Barber
I have two Workbooks. They both have the common
reference numbers for various products. Workbook A lists
the weights of products in rows adjacent to the...
|
September 17th, 2003 02:33 AM
by CLR
|
1 |
289 |
|
|
LOOKUP Formula by
SFrick
I'm having some trouble with a lookup formula.
In row 6 J through Z I have numbers from 1 through 17
In row 8 J through Z I have random numbers for...
|
|
3 |
397 |
|
|
finding Specific day in a named range by
DK
I am OK with some Adv Beg excel techniques. But I am not sure how to get the
next step done.
I do a monthly schedule in grid format in excel, names down the...
|
|
1 |
391 |
|
|
Compare 2 columns in a worksheet. by
Neeraja
Hi,
I need to compare 2 columns in a worksheet and see if the
values are similar.
Eg:
A : B
X-001 X-001
X-024 X-024
x-090 ...
|
|
2 |
585 |
|
|
|
|
7 |
334 |
|
|
Creating Formula (Date) by
TJ
Does anyone know of a way to create a formula for adding
time (i.e. years-months-days) onto a date? I'm a training
manager looking for a formula to calculate...
|
|
2 |
704 |
|
|
|
|
3 |
639 |
|
|
E-Mail Hyperlinks in Excel by
Ray
If an e-mail address is entered in a cell, Excel
automatically creates a hyperlink. How can this automatic
hyperlink creation feature be disabled?
(After...
|
|
4 |
324 |
|
|
Excel 2000 255 character limit by
Shannon
I have data that I need to import into Excel, then export
to .prn (because .prn is the only text format that seems
to be able to save formatting) and when I do...
|
|
1 |
572 |
|
|
pivot chart formatting? by
hugh jass
Hello All,
I am having fun getting pivot tables to show me simplified views of my data.
Pretty happy with everything, except for minor details on formatting...
|
|
1 |
631 |
|
|
watermark by
Brenda
I know I have seen this before so please excuse me for
requesting it again. But how is a watermark inserted into
an excel worksheet...
Thank You in Advance for...
|
|
3 |
347 |