|
|
emailing protected Excel worksheets by
R Maule
when attaching a password protected Excel worksheet to an
email, the password protection is not transferring. have
attempted using Microsoft Outlook with the...
|
|
1 |
425 |
|
|
Multi worksheet data look up by
Ray
I am looking for a way to copy data from multi worksheets
to another worksheets.
I have 50 worksheets of data and what to copy an area of data
from any 1 of...
|
|
1 |
524 |
|
|
sumproduct variables by
Tony
Hello Group,
How do I include multiple cell reference variables in a
sumproduct function? For example, if I wanted to include
text values I would use...
|
|
7 |
436 |
|
|
Pivot Table Display by
td
I have created a pivot table with the following
parameters:
Page Area = Customers
Row Area = Product
Column Area = Month
Data Area = Sales $
When I select a...
|
|
1 |
275 |
|
|
MouseClick as Counter by
David Webster
Is there a way to add code so that you add one to every cell you click on
within a range?
E.g. any cell between say C3 to H20 when I clik it I want it to...
|
|
1 |
324 |
|
|
Formatting (General to Number) by
Tom R
Does anyone know if there is a way to change the number formatting from
General to Number in one shot? I have an entire column that is in general
formatting,...
|
|
5 |
1,052 |
|
|
testing by
testypants
does this thing work????
|
|
1 |
397 |
|
|
Spherical Coordinates by
Keith Ingstrup
Given: Radius, inclination(in degrees) and azimuth(in
degrees). Can excel calculate P(x,y,z)
|
|
1 |
347 |
|
|
Excel database query by
Jean
I am using Office 97. I recently moved an access
database from one network drive to another. I have an
excel database query to that database that no...
|
September 17th, 2003 09:03 PM
by Dave
|
1 |
387 |
|
|
unhiding Column A - help! by
Phil
I've run into an odd problem. I did a Hide on Column A
and B. Excel won't let me unhide a column unless I
highlight the columns on BOTH sides of it. I have...
|
|
1 |
310 |
|
|
Data Validation by
dinna
can anyone help me !!!! I am trying to create a drop down list in excel
with data from another tab. Is this possible, if so how can I do...
|
|
1 |
288 |
|
|
Autofill formulas b/t various worksheets by
lbenson
Hello-
I have a workbook w/ 25 worksheets.
I need to sum the same cell from each worksheet and put it on a
separate summary worksheet. I tried to use the...
|
September 17th, 2003 09:15 PM
by RagDyer
|
3 |
476 |
|
|
Pooled regression and dummy variables by
Kev Summersgill
I'm a bit of a novice with excel. I have a dataset of
national ststistics which only has a few years so I can't
run a time series regression with any...
|
|
1 |
698 |
|
|
trendline equations are incorrect by
Fred
I charted a set of coordinates. The polynomial equation
fit extremely well (r square = 0.99) Unless I'm doing
something wrong, (and I don't think I am; I had...
|
|
3 |
438 |
|
|
Custom Template Worksheet Location by
brohar
I cannot for the life of me get my custom template
worksheet to show up in the same location as the default
xlt files. My PC is a company machine but my help...
|
September 17th, 2003 09:27 PM
by Radio848
|
3 |
504 |
|
|
Linking by
Dawn
When doing a link to another program, borders are
missing. Any way to fix this.
|
September 17th, 2003 09:33 PM
by Dawn
|
0 |
263 |
|
|
Spreadsheet play file then close by
Brenda
I need to create a workbook that will play a .wav file
then automatically close. Is there anyway to do this
without having "Enable Macros" dialog box pop up...
|
|
2 |
336 |
|
|
Copy subtotals by
Erin Paulin
You just saved me a TON of work!!
Thanks for the very helpful post!
Erin
-----Original Message-----
If this has to be done often, there is an icon which...
|
September 17th, 2003 09:50 PM
by RagDyer
|
1 |
684 |
|
|
Remove Spaces by
Bryant Caldwell
How can I use a function to remove spaces from a string.
Before
Smith , Bob
After
Smith,Bob
Thanks,
|
September 17th, 2003 10:05 PM
by Lynnus
|
3 |
435 |
|
|
Worksheets by
Walter Payne
My worksheet is long. How do I divide it and still have
the information linked to the first page.
|
|
0 |
236 |