Creating a group of cells. Need Help Please.
Havn't used excel in a while and I need to create a group of cell
corresponding to an input of a min and a max.
Here are the details. On one sheet I have a box where you enter th
min and a box where you enter the max. In another sheet I want
column starting at A2 to output (MIN,A2+1000,A3+1000,....MAX) ho
would I do this
Thundersixx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3055
View this thread: http://www.excelforum.com/showthread.php?threadid=50207
Name the...Printing Newsletter in Publisher 2003
I have Publisher 2003 on an XP OS and trying to print a newsletter with 2
pages per tabloid size paper. I was able to do this OK with Publisher 2000.
It seems that the 2003 version does not have a "Book fold" option for the
layout. The Print Preview looks OK and shows page 6 and 1 for the layout.
For layout I choose "Booklet". What I get is page 6 and 1 on 1/2 of the
11x17 paper. Help!
Gary are you printing to a laser printer???
If you are, you are running out of printer memory.
Have a look in the properties of the printer driver, and change the settings
from Vector...NDR Report
We get this NDR error when someone sends to a particular address:
550 Only 1 recipients accepted with null sender address
Again, the emails are sent using Outlook to a listing in our GAL for the
Custom Recipient. I have checked the outgoing messages and they do contain
a sender address.
Have you contacted the recipient's admin folk on this?
> We get this NDR error when someone sends to a particular address:
> 550 Only 1 recipients accepted with null sender address
> Again, the emails are sent using Out...How do I send a welcome message to a new created mailbox automatically?
My exchnage send a message automatically but I need to change the message
where do I change it?
On Tue, 21 Jun 2005 16:35:53 -0700, "Ron" <firstname.lastname@example.org> wrote:
>My exchnage send a message automatically but I need to change the message
>where do I change it?
Exchange doesnt do that unless you have something scripted.
If you are referring to the welcome message in Outlook, its called
welcome.msg , but I dont think its been used since Outlook 2002.
So where would I plug in the script? Also I searched for welcome.ms...Creating a template using Publisher
I need help creating a neighborhood directory template using Publisher and
merging an Excel spreadsheet into it. It keeps printing multiple pages of the
first page after I merge.
What version Publisher?
If you have 2003 use the catalog merge for your directory.
Otherwise you need to setup your page as though it is labels. Determine the size
of the area you need for each entry, select labels in page setup, type the size
you determined in the page setup. Adjust the gaps and margins when you are ready
to print (2000 and bel...excel, worksheet, set print area, position selection on printed pa
Office 07, Excel.
Print area is set, print preview displays selection, always on far left of
I want to choose the position on the page, eg centered or right aligned etc.
To get your printout to center on the page chose Page Layout, click the
Page Setup quick launch button (bottom right corner of the Page Setup group).
Choose the Margins tab, click Horizontal.
There is no command to right align a printout, but you can change the left
margin to force the printout to the left.
If this helps, please click the Yes button
"Eve Al...Can't edit print styles in Outlook 2007
Weekly calendar view to print - Define print Styles - Edit "CANNOT DISPLAY
THE DIALOG BOX"
I'm using trial version - shouldn't be the case????
I'm having the same problem where I cant edit the print syles ... please let me know what ou find out.
I think being able adjust the format and print the calendar is important, as I usually print my calendar.
EggHeadCafe.com - .NET Developer Portal of Choice
This is an Excel newsgroup. I would suggest posting this to an Outlook one
Microsoft MVP - Excel
Southampton...Custom Item Movement Report
Anyone out there have a custom item movement report and item movement
history report that includes extended description that they would be willing
That was a pretty tricky request but I was able to make the change.
Download the reports here:
If you cannot download from there shoort me an email and I will send
over. Check out our RMS add-ons website in exchange..
New West Technologies
Can you do one with "Transferred To"...Z Report shows zeros for an entire shift
How do I correct the problem described above? All receipts are printed
correctly, and all transactions seem to be successful. However, the Z report
that is run at the end of the shift prints all zeros? Any ideas???
I am having the same problem. All the transactions are successfull and I can
see the sale amounts and etc at crstal reports but all the z, zz and x
reports print "$0.00" amount. Does anyone know how to solve this problem?
> How do I correct the problem described above? All receipts are printed
> correctly, and all transactions seem t...how to turn off automatic format in Excel?
Excel automatically change the first character in a cell to be
uppercase. I just want lowercase. How can I turn off this function?
Go to Tools / Autocorrect and uncheck Capitalize first letter of sentence.
"ngoc" <email@example.com> wrote in message
> Excel automatically change the first character in a cell to be
> uppercase. I just want lowercase. How can I turn off this function?
...How refresh imported data automatically?
In Excel, I've imported data into a worksheet. I know I can click Data..
Refresh Data to requery the source, but I want to be able to do it in a more
Is there some sort of macro I can write when opened or something?
Select the cell the data starts in, select Data/Import External Data/Data
Check the box "Refresh on file open" and anything else that needs checking
Other than that, you could record a new Macro that selects your cell,
refreshes data, and assign the macro to a keystroke, or even an icon.
...New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
You could refresh with differen...Creating a worksheet in Spanish
Is there a way to create a worksheet on MS XP Pro running
Office 2003 Pro all in Spanish?
All valid formulas -except the ones from the Analysis Toolpack- will
automatically translate to the language of the Excel it's opened in. So any
spanish speaking Excel will translate formulas to spanish, no matter which
version it was written in.
The rest, text constants and such, has to be typed or pasted. Excel will not
translate this herself.
HTH. Best wishes Harald
"Kent" <Kent@discussions.microsoft.com> skrev i melding
news:ACCCBA3A-53B4...stop automatically changing formula!
i have a countif function
when i copy this and paste it to the next cell, the formula automatically
change to COUNTIF(Locking!J16:J40,"f")
How do I stop it from changing column I to J?!?!?!
MS Excel MVP
"caryn" <firstname.lastname@example.org> wrote in message
> i have a countif function
> when i copy this and paste it to the nex...Rule to automatically mark header to download based on contact list?
Is there a way to do this, or an add-in?
On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> Is there a way to do this, or an add-in?
What version of Outlook are you using?
Ben M. Schorr, MVP
"Ben M. Schorr - MVP" <firstname.lastname@example.org> wrote in message
> On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> > Is there a way to do this, or an add-in?
> What version of Outlook are you using?
>...Utility (pref. script) to catalog .EDB files
I have a client that is using an Enterprise backup tool which, whilst
able to back-up and restore, does not provide in-depth information
like traditional Exchange-aware backup products.
I have been asked to write a script to list the users in a flat .EDB
file (which has been snapped and copied and flushed using SAN
I have taken a look at the ESE API, which can only be accessed using C
+ (I only use VB). Other than EXMERGE, does anyone know of any tools
that allow you to list the basic mailbox details on a EDB file?
...Emails are automatically opening
When I select an email in outlook xp the emails are automatically opening the first highlighted email. Yes, ;) I have checked my settings in folder views - double click is selected, even if I reset it to single then back to double still no go. Also once I close a message, the next one automatically opens - just close not move or deletes.
...Show all months on report
I have a report that shows total shipments by month for specific items by
totaling in the Month Footer. Some items have no shipment on some months so
that month is not listed. Is there a way to have the report show all months
regardless if there were shipments that month or not?
Create a table name CountNumber with field CountNUM having integers from 0
(zero) through you maximum spread.
Build the query below.
SELECT DateAdd("m",[CountNUM],CVDate([Enter start date])) AS [My Dates]
WHERE (((DateAdd("m",[CountNUM],CVDate([Enter start date])))<=CVDa...PPV (Purchase Price Variance) report
This is a multi-part message in MIME format.
Would anyone be having a report available for PPV=20
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type =
&l...Check printing in GP 7.0
I have check payments for vendors, where I'm dealing with
LOCAL CURRENCY & FORIGHN CURRENCY. When I paid by check in
LOCAL CURRENCY then the amount in words prints perfectly
but if i paid by check in FORIGN CURRENCY then the amount
in word prints in numeric which i want to print amount in
words instead of numbers.
Please help me to print checks amount in words for FORIGN
CURRENCY as well.
Your suggestion would be appricated on above issue
...Outlook Draft Email Print Problem
I have emails saved in draft but when i go to print them
it doesnt show who it is being sent to and the fact it
hasnt been sent yet, i have played with the setting but to
no avail. I am using outlook 2003 any help would be
Turn off WordMail before printing the draft (Tools | Options | Mail Format)
or wait to print until after you send it.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
<firstname.lastname@example.org> wrote in message
news:...Services Invoices Get "DROP SHIP" box checked Automatically
This is a multi-part message in MIME format.
Hello Everybody, Here is another story.
we are GP 10 SP3 and we also a Field Service (Depot Module) installed =
for which we use an Invoice ( SVC000000) and our type is Service type =
At the time of posting the Service Charges being generated by the Depot =
Module, the Drop ship box gets checked automatically for which we can't =
charge the customer for shipping charges.
Basically we eve...Printing Detailed Trail Balance
I just installed a new printer HP Deskjet 5940 and when i print Detailed
Trial Balance reports it cutting off the Credit column. How do I fix this?
...Outlook 2002 HTML printing problem
Outlook 2002. I cannot print HTML emails. Plain text
prints without any problems just HTML will not. Office xp
pro is at all latest service packs. Anyone have an idea
what may be wrong?
...Business cards & printing
I have formatted some business cards with Publisher 2003 for a friend and
she wants to be able to print them off from her computer. However she does
not have MS Publisher, MS Word. She will probably purchase one of the Avery
packages from an office supply.
Is there a way I can save the file ready to print the cards with the proper
number per page and convert it to jpg so she could use it?
Thanks for information.
Hi Susan (email@example.com),
in the newsgroups
|| I have formatted some business cards with Publisher 2003 for a
|| friend and she wants to be able to print ...