A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Scheduling the regular printing of a daily (excel) report by Dave Teerlink
I have a daily report that is generated in Excel with macros, data entry etc. I'd like to automate the printing of it only so that the same file (usually...
June 14th, 2004 05:03 PM
by Lady Layla Go to last post
1 545
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 Go to last post
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...
June 14th, 2004 05:32 PM
by Ron de Bruin Go to last post
2 464
Getting "Export to Excel" to display in a context menu. by Andy B
Hi Maybe it is the version of IE that is the cause? -- Andy. "John Vaccaro" wrote in...
June 14th, 2004 05:48 PM
by John Vaccaro Go to last post
2 704
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...
June 14th, 2004 05:49 PM
by Ron de Bruin Go to last post
1 583
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...
June 14th, 2004 06:08 PM
by Frank Kabel Go to last post
1 671
corrupted excel 2000 file which is password protected by Ezra
we are looking for a utility which will allow us to recover a excel 2000 file multiple sheets and passworded. The file was originally stored on a zip disk and...
June 14th, 2004 06:47 PM
by Jan Karel Pieterse Go to last post
5 847
Excel Data List - why does it delete the data below the list? by ryanlillywhite
I have a large database in an Excel spreadsheet with subtotal formulas below. When I used the Data - List function to sort through the database, a few things...
June 14th, 2004 06:56 PM
by ryanlillywhite Go to last post
1 694
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...
June 14th, 2004 07:09 PM
by Frank Kabel Go to last post
1 542
Ranges in protected worksheet will not reset by Waikele Lin
I have a worksheet setup allow users to edit certain range areas when the sheet is protected, however, after those ranges deleted users still can edit even...
June 14th, 2004 07:13 PM
by Waikele Lin Go to last post
4 520
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 -...
June 14th, 2004 07:18 PM
by rkerbrat Go to last post
3 444
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.
June 14th, 2004 07:20 PM
by Frank Kabel Go to last post
1 454
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...
June 14th, 2004 07:21 PM
by whisperinghill Go to last post
0 842
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...
June 14th, 2004 07:30 PM
by Frank Kabel Go to last post
1 340
inserting $ at every cell mentioned in a formula by VILLABILLA
Hi! I have several long formula's in different cells and I would like to add a $ sign to every cell mentioned in those formula's. My question is how can I do...
June 14th, 2004 07:43 PM
by David McRitchie Go to last post
2 449
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...
June 14th, 2004 07:56 PM
by Frank Kabel Go to last post
1 331
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 Go to last post
1 1,002
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...
June 14th, 2004 08:23 PM
by Gord Dibben Go to last post
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...
June 14th, 2004 08:32 PM
by Frank Kabel Go to last post
1 363
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 ...
June 14th, 2004 09:35 PM
by Attila Fust Go to last post
5 572
Post New Thread


Display Options
Showing threads 101 to 120 of 139764
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.