two checking accounts data downloads to just one of the accts
I have two checking accounts with our bank and when I
download transactions into Microsoft Money for either
account, all the transactions go to only one of the
accounts set up in Money. I was prompted for the first
download to our "main" account. Then when I went to
download for the other account, I wasn't prompted where to
download to... and all the transactions went into the
first account. Did that make sense?
My bank required we switch to Money from Quicken, so I am
new to this. Tried to search in users guide and online
for help. Help would be much appreciated - ...convert PDF to other vector file format?
Is there any free conversion tool to convert a PDF file into a vector-based
file format that can be imported and displayed in publisher? Is there any
reason a tool like that has not or cannot be made? I wanted to ask why
publisher cannot import PDF format directly but that may be asking too much.
The images and text can be extracted from pdf files with another program.
Would that do it?
"peter" <email@example.com> wrote in message
> Is there any free conversion tool to convert a PDF file into a
v...Migrating Mailboxes from one domain to another domain
I am having a hard time trying to figure out how to do something and was
wondering if anyone could point me in the right direction.
I need to migrate user mailboxes from one server to another, easy enough
well here is where my issues are.
server one is in say abc.local domain
server two is in say xyz.local domain
there are the same users in both domains, with the same naming convention.
so to clear that up if i have a user called ttest in domain abc, user ttest
is also in xyz.
the old administration had seperated these domains due to function and
security, but now they want to...Saving Formatting in Pivot Tables
When I changed formatting in a pivot table, it returns to
the default format when I make a change or close the
file. Generally, in formats like font size, column
width, etc. Is there a way to save/retain format changes
in pivot tables?
right click in the table and go to the bottom to
select "table options". It's there.
>When I changed formatting in a pivot table, it returns
>the default format when I make a change or close the
>file. Generally, in formats like font size, column
>width, etc. Is there a way to...Editing Item Information in a grid format
Does anyone know of clean way, have an add in, or link to Excel or Access,
that allows a person to edit item data file in a spreadsheet, or grid style
You can kind of do it with Access, but you continually get a "The data was
added to the database but the data won't be displayed in the form because it
doesn't satisfy the criteria in the underlying record source", when you
update the line, and then the line disappears.
I wouldn't recommend changing data outside of RMS, but if you're really
http://www.sqlmanager.net/en/products...Calculation / Format Error
I'm using this formula in cell AE69
When the logic is true I want the cell value to be zero, but show as blank.
When this cell is summed up with others, a #VALUE! is returned. I am
assuming excel is seeing this cell as text and thus returning an error.
I have tried adjusting the formula to:
I have selected the accounting formating for AE69 with the "£" symbol.
However, instead of getting the £ symbol to the left and a dash representing
z...M2005 -- one word.... UGGGHHH!!!
I just got the demo... was using M04 small biz. Very disappointed.
1) Runs like a SLOTH in need of a NAP, on my 3.4GHz P4 / 1GB ram.
2) MSN crap littered in every nook and cranny possible.
3) Apparently uses IE engine to "render" all pages so everything has a
clunky "web-browsery" feel to it.
4) No "Find" function?? How do I just "Find" a transaction across all
5) Money Express has gone by the wayside... apparently they want you to use
MSN Alerts. Well, I don't have MSN Messenger installed on my machine
because I...Ten calendar harm one of the products
Ten calendar harm one of the products
...copy sheet with range names
I'm making 2 copies of an existing worksheet within a workbook. The original sheet has lots of range names. Now, when I make my
copies, the range names are screwed up and are referring to the new sheet instead of the original one. What's up with that? I don't
see any options related to range names. Deleting and resetting the names would take forever, as would "re-defining". I shouldn't
have to do that. Any ideas?
I think if you look at your range names, you'll find that xl localized the
copies. When it copied the worksheet, it had to do something ...Date formatting in Excel #2
How do I format a cell to return Oct 04 when I type 10-4 in Excel...When I
type 10-4, Excel returns Oct 05.
When no year is typed, excel would assume it is the
current year. You would ahve to type the full date
(including 2004) for it to display as Oct 2004. Use
Format - cells - date and then select the particular
format you want from the options there.
>How do I format a cell to return Oct 04 when I type 10-4
in Excel...When I
>type 10-4, Excel returns Oct 05.
...How do I lock the Column without Protecting the Sheet
I want to Lock a Column without protecting the sheet.
the user can enter anything in other columns but he/she should not alter
in particular column that i locked
Protecting the sheet is - by far - the easiest way, otherwise you must useVBA
to capture and deny changes to that column. I think you'd have to be pretty
elaborate, too, to trap all potential changes.
> I want to Lock a Column without protecting the sheet.
> the user can enter anything in other columns but he/she should not alter
> in particular column that i loc...Sheet protection prompts
Ive been building a speadsheet for data collection and have
incorporated event macros that format columns, filter and
protect/unprotect the worksheet.
One of the users is receiving a confirmation prompt each time the macro
protects/unprotects the sheet. I however am not being prompted on my
pc and have been unable to replicate this. Has anyone come across this
before and could you please advise how it can be overcome.
Would appreciate any assistance you can provide.
Not sure why this would happen to one user, unless they have a different
version possibly. Could ...Changing info from one worksheet to the next
Hi all. I have linked my 55 sheets to one which is great.
What i need to know now if possible.
Each sheet has the same question over 11 columns
Each row is dated and a numeric number from 1 - 10 in each row
Now on the master sheet where everything is linked, is there a way that
If i changed the date on the master sheet it would reflect the answers from
the row with that date?
At present the answers showing is for 01/03/10, but i would like to look at
the totals for 08/03/10 and show the answers from each sheet for that date.
I could have a sheet for each week, but im hoping there i...Change sheet number in formula
Is there a way to do the following. I have a sheet with a formula that
reference to another sheet. I need to pull a number from the same cell
in every sheet.
I want to do a summary of some sheets using the formula...
Instead of hard coding the sheet number in the above formula, is there a
way to reference a sheet number from another cell.??
Cell A1 = Sheet1"
Cell A2 = "Sheet2"
Then have another cell that pulls from A1
Very difficult to explain.... hope that made some sense...
** Post...display cell value in msgbox formatted as %
I have been trying to come up with a way to display a cell value in a
msgbox so that it formats properly as a percent.
I have tried:
Productivity = Format(Range("A1").Value, "###,# %")
This always gives me a leading 0 (e.g 015%) and I want it to display
So I tried this:
Productivity = Format(CStr(Range("A1").Value) * 100, "#,###.0") & "%"
and it works ok but...
I want to use the value of productivity in computations - which I can't
formatted as a string ... Am I missing something - or is it as simple...RMS should allow you to choose more than one item at a time
RMS should allow you to choose more than one item at a time, this would be
helpful in creating PO's. Mutiple item selection is a standard in every
software; you really dropped the ball with this one.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.micr...Viewing 2 worksheets in the same workbook
Is there a way of viewing data on two separate worksheets in the same
workbook in a similar way to splitting a single worksheet?
Choose Window> New Window
Choose Window> Arrange
Select Tile (or one of the other options), and check the box
'Windows of active workbook'
In each of the windows, select a different worksheet to view.
> Is there a way of viewing data on two separate worksheets in the same
> workbook in a similar way to splitting a single worksheet?
Excel FAQ, Tips & Book List
http://www.contextures....IIS reset for one user only
I have one user who can't link appointments from Outlook and also at the
same time the user can't create appointments from CRM Web client as well. It
will hang outlook and IExplorer. If I check task manager is starts Offlb.exe,
meaning outlook is hung. If I reset IIS on crm server, the user is ok, he can
create appointments and link them, the web client is ok as well.
When this is happening none of the other users who create appointments and
linked them to CRM are affected. After a day or so goes by, the same user
have same issues. The only thing that fixes it is the II...Copy/Paste to Match Destination Formatting -- BY DEFAULT
Operating System: Mac OS X 10.6 (Snow Leopard)
As a long time PC Word user, I have been accustomed to the large amount of preference customization that is available. One CRUCIAL (for me) customization option in PC Word is the ability to set the default action when pasting from one program (the web or Acrobat) to Word. <br><br>By default, both Word 2008 (mac) and Word 2007 (PC) keep the source formatting when pasting between programs. To me that makes no sense, because 9 out of 10 times you don't want your word document to have many differ...Row Height variations from computer to computer on same workbook
I've been sent a workbook by a colleague and on his workbook, a specific row
has a height of 13.8 (23 pixels) and on my machine it is 16.5 (22 pixels).
Has anyone seen this before and what do we need to do to ensure that it's
consistent from machine to machine?
Thanks in advance,
Display Control Panel -> Settings -> Advanced -> General -> DPI setting to
Normal (96 DPI)
"Barb Reinhardt" wrote:
> I've been sent a workbook by a colleague and on his workbook, a specific row
>...golf league spread sheet
I am trying to set up a spread sheet for my golf league.
Here's an example:
Member ___ Today's Score __ Net __ Current Handicap
John Smith _____75 ________ 70___________5
Bill Smith _____76_________71___________5
Tom Smith _____ 77_________72___________5
John Parks _____72_________66___________8
Bill Parks _____78 ________69 __________ 9
Tom Parks _____80 ________ 73__________ 7
...... and so on for 180 golfers
Now I figured out how to list lowest net scores for todays round int
an "A" Flight "B" Flight and a "...Tracing and tracking email on one mailbox
1. I want to use a current copy of the Exchange 2003 database and scrub it
for all emails regarding one mailbox. Is there a tool that will assist me in
2. How do I tell Exchange 2003 to notify me of any emails transmitted to
and from a particular address? And yes, this in conjunction with #1. I want
to track one user's mail without using delegate or adding myself to their
Active Directory profile and having to create another profile in Outlook.
1. Have a read through this:
http://wm.quest.com/reg/marketing/landing/ediscoveryexchange/. This product
is ideally suited for ...the function FORMAT()
We used to have this function in the previous MS Excel and MS Acess whereby
to format a date in a formula like ="today
is:"&FORMAT(today(),"ddd/mmmm/yyyy"). apparently this function disappeared??
You can have
in a worksheet, or
(remove nothere from the email address if mailing direct)
"Jonas" <Jonas@discussions.microsoft.com> wrote in message
> We used to have this function in the pr...Export Data to MS Word Table and Format
I've gathered code from other posts and have come up with output to a
Word document that is acceptable (thanks to everyone for sharing).
I would like know if it is possible to format the table in MS Word.
1) Left justifying the 1st column, and centering the data in columns 2
2) Is there a better way of handling the column widths to
automatically size to the widest data in the column.
3) Any good resources to help export data to MS Word.
Here's what I have so far...
Dim oWord As Word.Application
Dim oDoc As Word.Documen...How can I e-mail only one page of an excell spreadsheet? #2
I need to e-mail a one-page spreadsheet, but what gets sent is thousands of
blank pages after the data page. I need to make changes on a Front Page
edited web site.
See this site
>I need to e-mail a one-page spreadsheet, but what gets
sent is thousands of
>blank pages after the data page. I need to make changes
on a Front Page
>edited web site.