|
|
|
|
1 |
559 |
|
|
Printing a selection of Worksheet by
JER
How does one go about printing just the part of a work sheet that has been
selected? When I select and then go to print preview, I see a much larger
section...
|
June 14th, 2004 05:08 PM
by JER
|
4 |
379 |
|
|
Duplicate file openings by
Larry
On a workstation with XP Pro and Office 2003
Files on server running Server 2003 Standard
When a user on a workstation opens an Excel file it opens
two copies...
|
|
2 |
464 |
|
|
|
|
2 |
714 |
|
|
V-lookup of file names? by
jeff
I don't know if this is possible, but I thought it would
be worth asking.
Is there a way to do a vlookup of a file name in order to
open the file and then...
|
|
1 |
594 |
|
|
Error opening or copying Excel File by
Miscell04
I have a disk which I received from someone outside my
office. The disk contains xls and WQ1 files. When
attempting to copy the disk I get the following error...
|
|
1 |
685 |
|
|
|
|
5 |
882 |
|
|
|
|
1 |
707 |
|
|
querying excel spreadsheets like database by
corrie
I'm making a payroll journal, it has a column for the names, and then
the cheque amt, cheque no., and some other stuff.
In a separate sheet I need to pull up...
|
|
1 |
547 |
|
|
|
|
4 |
527 |
|
|
Iterative Calculation help needed by
rkerbrat
I have the following information
A1 - Balance at the beginning of calculation
A2 - Annualized payment
A3 - Interest rate divided by # of payments per year
A4 -...
|
|
3 |
449 |
|
|
ALL CAPS to Proper! by
a little help please
I'm having trouble making a very long list of names and adresses go from ALL CAPS to Proper. Any suggestions would be helpful.
|
|
1 |
459 |
|
|
Macro when a font in a range changes by
whisperinghill
Actually, I just completed a vb code to monitor a dde link and
automatically sends an email. It only send s the email whenever the
dde link passes through a...
|
|
0 |
859 |
|
|
Sum field N times by
Sara Jane
I would like to sum a specific cell N times. Is there a
command to execute this? As I am VBA inept, I am hopeful
it can be done without the use of...
|
|
1 |
345 |
|
|
|
|
2 |
450 |
|
|
Using ranges as lists by
jasonp
Trying to use the IF statement to compare a user's input into a cell to another cell and give the value of a cooresponding cell.
i.e. a1=if(b1=c1,d1,0)
mileage...
|
|
1 |
336 |
|
|
Finding duplicate names by
Matt in AZ
Thanks. That worked great!
--
Matt in AZ
"Max" wrote:
Try this ..
Assuming the data in cols A and B are in row1 down
|
June 14th, 2004 08:18 PM
by Max
|
1 |
1,100 |
|
|
small worksheet names by
paul.young.b \(no spam please\) @bayer.com
I have user that has his monitor resolution set high and
then goes in and adjusts the size of the cells to
accomodate what he is doing. When he does this, the...
|
|
3 |
427 |
|
|
Counting in Excel by
bcollie
I know nearly nothing about Excel syntax, so please be kind.
I have a list of people who are eating at a seminar. So far I have
some blank cells, some N for...
|
|
1 |
368 |
|
|
SUMPRODUCT with YEAR, MONTH functions by
Attila Fust
I am trying to sum data if a date range matches (year and
month only). Here is the example:
Table1
5/15/00 5/16/00 6/17/00 (NAME=DATES1)
5 5 ...
|
|
5 |
578 |