how do I change to page 2 in making a card
> how do I change to page 2 in making a card
Which version of MS Publisher are you using?
MS Picture It! -
Digital Image MVP
Highlights and FAQs
This is not tech support
I am a volunteer
Solutions that work for
me may not work for you
Proceed at your own risk
View, status bar...
If you are using 2007...
This was posted by a fellow who lost his sort tabs.
To fix the Publisher page s...Pivot table not alphabetizing correctly for one character
In Excell from Microsoft Office 2000 SR-1 Professional, after setting the
pivot table to sort in ascending values, the field is sorted for all values
except for one. This one lists at the top (or bottom if descending values)
of the pivot table no matter what I've tried. The following are some of the
field values: ALC, STC, NTL, DEF, LUC,MOL, JUN,SNO. When sorted, all are
alphabetized except JUN. That value always is at the top. I've checked the
original data, the query, and the excel data. All appear consistent and sort
appropriately, the pivot table will not. If I chang...Make resource mailbox calendars viewable
I previously had calendars setup under Public Folders to reserve conference
rooms, but was told it was more efficient to use resource mailboxes for
things like that. I have created the mailboxes and it is working well but is
there a way to make the calendars viewable to the entire office the way it
was under Public Folders? People would still like to be able to see whats
available before making the meeting request. Thank you.
On Wed, 7 Feb 2007 14:31:17 -0800, KJ <KJ@discussions.microsoft.com>
>I previously had calendars setup under Public Folders to reserve conference ...making global changes
I recently imported my checking account data, over 2000 transactions, from
an Excel worksheet. The data was accurately imported, but it didn't import
the expense category associated with each transaction. Is there a way to
have Money2002 globally change all checks written to Payee A assigned to
I can re-import the data if I knew what to name the column and what order to
place it in Excel. Maybe someone know the answer to that.
Thanks in advance
In microsoft.public.money, Michael Israel wrote:
>I recently imported my checking account data, over 2000 transactions, from
...Chart With One Series Bars and Two Series of Lines
I am trying to create a chart where weekly sales for 04
are represented by bars and sales for 03 and running
averages are represented by lines. There seem to be many
options for two bars with one line, but not the other way
around. Any ideas? I tried customizing, but couldn't find
a way to change bars to lines.
Forget the built in custom charts, make your own. Make your chart with
three line series, then right click on the 04 weekly sales series,
select Chart Type from the pop up menu, and choose a column type for
that series only.
Jon Peltier, Mic...Tranferring email files form one PC to another
I realize that this question has been asked a thousand times before
and I should have paid attention. .
I have copied all the files with the *dbx extension to a memory stick.
How do I get them from there into the Local Folders of the new PC.
Assuming this is OE to OE? Did you include Folders.dbx? If yes:
Backup & Restore:
Backing up and Cloning your OE Identities:
If you did not include Folders.dbx, you have some work cut out for
How to restore individual dbx f...Macro to Clear Cell Contents based on Cell Value in another Sheet
Sorry for the Newbie question but.......
How do I create a macro to clear the contents of cells in one worksheet
based on the value of a cell in another worksheet?
For example: on SHEET 1 the value of cell A1 can be Yes or No. If A1 =
"Yes" then I want to clear the values in cell range A1:C5 of SHEET 2,
if "No" then don't clear the values.
Thanks in advance.
dim rng1 as range
dim rng2 as range
set rng1 = worksheets("sheet1").range("a1")
set rng2 = worksheets("sheet2").range("a1:c5")
...Formulas in a sentence
We have been asked to contact you by our client =c6 , regarding your past due
invoice for =c8.
What would the formula be?
c8 pay c6. Only fair :-)
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
"krissy" <firstname.lastname@example.org> wrote in message
> We have been asked to contact you by our client =c6 , regarding your past due
> invoice for =c8.
> What would the formula be?
="We ...How do you make the Address Book Show Up
In outlook, I've seen (under my normal contact list) CRM Business Contacts.
I've seen this before (as it shows up with the Business Contact Manager). It
doesn't seem to show up anyomore. And, I had a friend on the network install
it and it does the same thing....only 'contacts' show up. How do you get
that to show up on the outlook bar on the left like I've seen before?
Also, I have synchronization errors. How do you fix them? There are no
logs, no errors, no messages, and no place to look!!!
...make Outlook use alternate calendar
I have found a dll file which can be replaced by Arabic Hijri
Calendar dll files in outlook 2003 program folder (program
files\microsoft office\office11) in order to view the calendar in
Persian Solar Calnedar, however to make outlook use it as its main
calendar I have to change the "Regional and lang..." in Control panel
which changes the calendar of the whole windows into Hijri lunar
calendar which is not an ideal situtation :).
So how can I make outlook to use Hijri calendar as its main calendar
while the XP calendar is still Georgian?
...This makes no sense
I have bought 500 bonds at $10 each. Money tells me this cost me $50. In
fact, it cost me $5,000. Is there some way I can enter accurate info (ie.,
the correct number of bonds, and the correct price), and get the correct
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://register.microsoft.com/mswish/suggestion.asp
or email email@example.com especially if it's a UK specific wish.
I do n...Could not open one or more attachments #5
I have a user using Outlook 2000 that can view some of the attachments he
gets in email. The ones he can't view give him the error message, "Could
not open one or more attachments." The only thing I have noticed about
these attachments, is that they appear to not have an extension. Would not
having an extension be the problem? I would think the email would open but
have a generic icon for the attachment.
...How to make PST file default?
I've created another PST file in Outlook 2002. How do I make this one the
default for mail? I have two PST files open.
- Go to Tools > E-mail Accounts > View or change existing e-mail accounts
- Select the PST you just added in the "Deliver New e-mail to the following
location" dropdown (it will most likely appear just below the current
default Personal Folders file) > Finish
- Exit and Restart Outlook
- You can now close the previous default PST (R-click on that pst folder
while in Folder View and select "Close <foldername> Folders")....how do I make make my hyperlinks show the email address they are .
I copy a list of names from one page and put them in a excel spreadsheet.
What happens is just the name show like DUSTIN MCALISTER but when you hold
the mouse over the name the email address shows up in a little yellow box
showing what the hyperlink is. Is there a way to make it show the email
address instead of the hyperlink?? That way I can click on a row of names and
all the emaill addresses will be there so I can copy and paste them into my
Email and mass email my clients? Thanks!
...multiply by no. in cell
I would like to know if its possible that information that I have i
cells B1, C1, should multiply by the no. that I have in cell A1
(A1=5,) I would like to have five times the info. from cells B1 and C
shlomo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1530
View this thread: http://www.excelforum.com/showthread.php?threadid=31947
I don't understand the problem. Can you give a bit more information?
So i can help
> I would like to know if its possible tha...Save as .htm with filename from cell
I have a macro to save a sheet as an htm file. I can specify a name
for the file. Is there a way to use the contents of a cell for the
file name? Thanks for any and all help.
As long as the values in the cell do not contain forbidden characters, you
could simply reference the cell when saving the file using
> I have a macro to save a sheet as an htm file. I can specify a name
> for the file. Is there a way to use the contents o...Obtain a list of all files in one sub-directory with VBA?
Is it possible to obtain a list of all files in one sub-directory with Access
2007 VBA code?
"Brad" <Brad@discussions.microsoft.com> wrote in message
> Is it possible to obtain a list of all files in one sub-directory with
> 2007 VBA code?
Dim fdr As String
fdr = Dir("c:\temp\*.*")
Do While fdr <> ""
fdr = Dir
This will output all the file names contained in c:\temp to the debug
Stua...Can I make a pie chart where the slices are also graphical?
I want a pie chart where each slice, say personnel group, is also divided,
by say type of orders. Is this possible?
For example I would have the 'Pie Eaters' with total 50 orders (their
slice), 45 for pies (a portion of the slice), and 5 for fruit (a smaller
portion of the slice). 'Healthy Eaters' with 40 orders, 28 for fruit, 10
for yoghurt and 2 for pie. The 'Dieters' with 10 orders, all for Health
Drinks. The pie would have 3 slices. The Pie Eaters slice, half the pie,
would have 2 parts. The healthy eaters slice, 40% of the pie, would also
have 3...I need help getting Excel to auto-fill cells when I begin typing .
I use Excel to create quotes for my customers daily, it seems that I spend
more time typing than I should...It would be nice to know how to enter a list
into excel so that when I begin typing a product name that it would reconize
the first few letters and auto fill for me so I could tab to the next column.
I've know about using the fill handle and setting up repeating lists there,
but haven't had any luck with generating "memory" or a history of used terms
for excel to key off of other than keeping all quotes on the same worksheet.
would really appreciate some input ...make existing pivot charts point at the same database
I have an excel spreadsheet containing many pivot charts. They get data from
the same database, but (my fault when building the file) do not point to it
only once to reduce the doc size (Excel normally gives you the option to use
the same database as another pivot chart if equal to another one already
When I try to go back through the pivot table wizard to the area of the
data, I am not given the possibility of using an existing database. Is there
a way I can tell Excel to point only once to the same database for all pivot
charts without rebuilding them from sc...Undeposited funds / multiple payments and one deposit
Hello all. I'm new to Money 2004 and to this forum so
please excuse my ignorance. I'm hoping someone can help
me with a problem. In using Money 2004 for my business my
accountant suggested I set up an account called
Undeposited Funds. This is so when I receive payments
from customers, the payments don't go into my checking
register. (My problem there was that I would have
multiple payments but when I would make my weekly deposit,
the payments would be combined and I couldn't figure out
how to reconcile the multiple payments with the one
deposit - I hope that made...Email report that is filtered to one record
I have a database that has three different forms. To navigate from one form
to the other and keep the same record, I have an [Event Procedure] set up.
Additionally, to print the report for the one recored, I have another [Event
Procedure] that filters the report to the record that is displayed. The
procedure is as follows:
Private Sub printallpages_Click()
If Me.Dirty Then 'Save any edits.
Me.Dirty = False
If Me.NewRecord Then 'Check there is a record to print
MsgBox "Select a record to print"
str...how do I make a 6.25X9.25 greeting card
I am trying to make christmas cards. The paper is 6.25 X 9.25. The
templates that are offered in publisher appears to be for half fold of a 8.25
X 11 inch paper or quarter fold. How do I adjust the templates or must I use
a larger paper.
What version Publisher are you using? The instructions below are for versions
other than 2007.
Setup a custom size in your printer. Publisher will default to this size in page
setup. You can then select booklet, and there you are...
If you must use a template, open a new instance of Publisher, select the
template, copy/paste the objects to your new...Make Excel add
I need a formula where excel would recognize an entry in say column "AO"
(any entry) and add 1 to the number already in column AN. Something like
that, I hope somebody understands what I am trying to say. Thanks
In cell AO1, put this formula and copy and paste it as far down column AO as
Vaya con Dios,
> I need a formula where excel would recognize an entry in say column "AO"
> (any entry) and add 1 to the number already in column AN. Something like
> that, I hope somebody understands w...move cell contents
Is there a way to move a cell contents to another cell with a formula. ex:
if a5="Name" then move g5 to j5? Also, I am using
=INDEX(Sheet1!B3:B12,INT((RAND()*10)+1),1) to pick random names from a list.
I have the formula in different place pick random names from different list.
This does work, but I have different list with some of the same names and
with the random pick I do not want the same name to appear.
Thanks for any and all help.
a formula can only affect the cell it is in, it can't move or change another
cell for this you need some code ...