Help with a formula..
I am trying to create a formula that will take information from a cell on one
sheet and combine it with text on another sheet. I know how to get the two
together. My problem is that I want the part that is brought in to be bolded
type. Here is what I have in the formula. ="we are pleased to submit our
quotation for "&(cell reference)&" according to the following
specifications." What I want to do is have the cell reference part be bold
type. Is there a way to do that? It doesnt work if I bold the cell.. already
tried it.. Any suggestions?
You'...Money: Err Msg: Path Has Not Been Properly Set Up
Microsoft Money. The path is not properly set up in the registry or has been
moved after running Money's Setup. Please re-install Money. Otherwise, Money
may not be able to run properly.
re-instal wont help
deleting registry entry dasn.t help.
windowx xp sp2 Ms Money 97 (v.5.0)
Are you using an administrator account to run the software?
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://registe...Money 2005 #50
Trying to restore my date from old xp computer to new vista computer. Loaded
program ok, set the path to new location, am logged on with admin rights,
when i try o restore says cannot open file. Have not had this on other
computers? Need ideas? Thx
how did you transfer your *.mny file? If you used a CD or DVD your file
becomes read only. You have to manually go into to Windows Explorer and
change it back to read/write.
"meg85" <firstname.lastname@example.org> wrote in message
> Trying to re...Help needed urgently
Im trying to check that one row of data satifies a criteria, then if it does
it counts an entry in another column adjescent to it.
Column A - Column B
Blay - Y
Blay - N
Blay - Y
Chop - N
Chop - N
High - Y
What i would be asking (of a much bigger table) is If Column A = Blaydon and
then column B (same row) = Y, then count. In this example I would want 2
returned as the answer.
Is this possible?
Try one of these...
Use cells to hold the criteria:
D2 = Blaydon
E2 = Y
If you're using Excel 2007 or later:
=COUNTIFS(A2:A7,...Money Central Portfolio #2
My print function has gotten corupted. When I print it flips to WORD / format
and prints in a format that is 4x normal.
...Problems Converting Data from Quicken 2001 Deluxe to MS Money
I have a relatively new Compaq Desktop (2.5 GHz Celeron with 512 MB RAM).
I have a Viewsonic Pocket PC and I wanted to use it to track my financial
data so I purchased Money 2003 Standard.
I tried several times to convert my Qucken Data (it's a big file--I've
been using Quicken since 1995). My Quicken program is Quicken 2001
Anyway, the MS Money program started to convert and after a few minutes
"Your Quicken file could not be converted. Money could not convert your
Quicken file. You might have run out of disk space or system memory. Try
closing othe...Offline Database Sync #3
Is there anyway to manually sync the offline database with the online
database on the server?
We have a register that travels to several weekend shows. We use the
offline database when it travels and would like to reconnect it when it
returns to the store.
Since we process credit cards with a secure wireless connection, we want to
run a Z report each day and settle the EDC Batch for credit card
transactions. In order to accomplish that we do the following.
We sync the offline database before the show. Then modify the SO Admin to
point the primary database to the offline databas...help with dynamic tables
This is a bit complicated to explain but I'll try my best. In columns A, B,
C I have different drop down lists. Column A has Store1, Store2, Store3,
etc. Column B has Dept1, Dept2, Dep3, etc. Column C has ProductA, ProductB,
ProductC. As of right now, these lists are not dependent on each other, I
can choose anything from any list regardless of the previous category. Also,
the length of these lists is undefined, meaning I will constantly be adding
to them in sequential rows below. And then columns D and beyond have data
such as Sales, Profits, # of items, etc.
What I...Need code snippet to read offline PST file
I have a PST file in my local hard disk and have requirement to read
PST file and parse through all folders and then each message item in
all folders and then segregate them to different folders based on
Please kindly send the code for the above requirement.
Thanks & Regards
You're going to have to write your own code. Do you know anything about
Outlook programming at all? You can start out by looking at information and
code samples at www.outlookcode.com.
[MVP - Outlook]
http://www.slo...Accessing my information offline
I have updated my Outlook to 2002 on my notebook computer
and when it is connected on the Lan at my office(new
ethernet connection) I can see my calendar, addressbook, e-
mails etc. However, when I disconnect and bring my
notebook home, and try to access calendar, etc, it says I
must sychronize while I am still connected to the Lan.
My previous version of outlook didn't have this problem. I
synched it on the Lan and it worked. This one won't.
How do you have your folders marked for Offline use under
Milly Staples [MVP - Outlo...Help! Problem Referencing Excel 2003 in VB.NET
I am using Visual Studio 2008 Express Edition to develop some VB.NET
code that manipulates Excel files. I am developing on a Vista/Excel
2007 machine, but I need the code to work on an XP/2003 machine as
I initially set a reference to the Microsoft Excel 12.0 Object Library
and imported the Microsoft.Office.Interop.Excel namespace. This works
great on the VIsta/Excel 2007 machine, but it does not work on 2003,
which needs the 11.0 library. I get an error that says "Unhandled
Exception . . . Could not file or assembly
'Microsoft.Office.Interop.Excel, Version 12.0.0....Need Help with drop down list with conditions...
I need help.
I'm having a very difficult time creating a sequence of list which change based on the item selected on the main list, lets call it the index:
The Index list, the first list, would define vendors. In this case Hotel Companies (e.g Hilton, Marriott, Sheraton).
The following list, the 2nd list, would define properties, but the properties would vary based on which hotel company is selected (e.g. If Hilton, then "The Plaza, the Waldorf Astoria. If Marriott, then Marriott Marquis, Marriott Convention Center etc etc...) on list #1.
And Last but not least, the 3rd list would...Macro Help #18
Well I think this is a macro. I have searched my excel book and i can not
seem to figure out what to do.
I want to write something that if this statement is true, then the font
color changes. But here is the potential problem. THe location of the text
will change. So i need it to search for this text and then change the color.
Does that make sense? Is this possible? If this can be done it will really
help me. Thanks in advance.
This is exactly what i am trying to do.
You type in a persons name into cell a1. you also type a name into cell a2.
These names will transfer over ...Newbie needs help with new Exchange 2003 installation
I am TOTALLY new to Exchange. We just installed Exchange Server 2003
on a Windows 2003 domain.
I have one (test) account set up and it appears to work OK but I keep
getting an error message that says "Task "Microsoft Exchange Server"
reported error (0x8004010F): 'The operation failed. An object could
not be found.'
I know, I know...How could I possibly not understand THIS message?
I appear to be getting mail but I' can't be sure. How can I check to
see what's causing this (and more important...what object it's looking
Thanks for any help!
I tried to work on Word today for first time on newish Mac and
realized none of my Office applications work.
When I double click on Word I can see something happening as I get the
circle of colours twirling, but half an hour later it still hadn't
opened. I just have to do this as quickly as possible as I have a
deadline for what I have to do Monday at 12.
I've tried reinstalling the software, but that didn't do anything for
me. Mind you I know absolutely nothing about installing anything on
Mac computers so I could be doing it all wrong.
Do any of you have any idea what c...Macro help with saving a spreadsheet with date and time in it
Can someone help me with some code that would save a file name as
Alan, how about something like this
ActiveWorkbook.SaveAs Filename:="Schedule " & Format(Now,
"mm-dd-yyyy-hh-mm") & ".xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
We went live with 4 decimals on our functional currency and we now want to
reduce them to 2 decimals. All of our transactions so far are in 4 decimals.
Can anyone guide me into doing this? thank you
Use the Change Decimal Places window to change the number of decimal places
used for keeping quantity or currency amounts for items. You might need to
complete this procedure if an item was set up improperly, or if you’re
changing the units of measurement for an item.
NOTE: If an item is on an unposted transaction, you can’t change its decimal
place settings. Ensure you have a complete ba...Your thoughts on Money 2005?
After reading through the posts today, here are some of my thoughts on Money
2005 and how to resolve some of the issues.
#1 MS should offer a 15 year anniversary edition of MS Money 98 that works
#2 Undo all the extras. Give us a Basic Edition product that allows us to
balance the checkbook, manually download our QIF/OFX files, do a budget and
add a calendar to remind us of bills...that's it. Remove the bloat that
really makes MS 2005 slower and buggy.
#3 Allow a feature that will let us revert back to a former version. Sure,
you tell us to backup our previous data, bu...Please help a exchange newbie.. Message filtering
I have a contact set up on Exchange 2003 that forwards to a cell phone
for alerts generated in our environment. This contact is setup to get
notice of several events, all events have separate email address as the
"sender" one of the events gets allot of notices. I would like to
have this contact not receive mail from the one email address that
generated allot of events. I have set up the properties under the
exchange general > messaging restrictions, and have authenticated users
only and from everyone except the email account I don't want to
receive alerts from, BUT when anyon...Attach a SQL 2005 Express Database to SQL Server 2005
I am trying to attach a database from SQL Express 2005 to SQL Server 2005 and
I am getting the error:
Attach database failed for Server 'xxxxxx'.
An exception occurred while executing a Transact-SQL Statement or batch.
Could not find row in sysindexes for database ID 6, object ID 1. Run DBCC
CHECKTABLE on sysindexes.
Could not open database 'xxxxxx.mdf'. Create DATABASE is aborted. (Microsoft
SQL Server, Error: 602)
I am not sure how to Run DBCC CHECKTABLE.
My project is halted until I get this resolved. Any help is appreciated.
Am Thu, 15 Apr 2010 ...Help me do this
I need some help. I want to use Windows Live mail without signing in or
having a hotmail or live account. I use gmail and it works fine. I have
exported all my contacts from my live.com email and imported all of my
contacts so that is not the problem. I want to import my calendar from my
live account. I can't find anyway to do this. If I stop signing in of course
my calendar is gone. How can I export my live.com email calendar into
windows live desktop client so I don't have to sign in anymore? Thx
"T-Man" <email@example.com> wrote in message...Help?
Ok this is for all the formulae gurus out there.
I have a list in a particular column, lets say column A
This is a list of dates
I have another cell which uses data validation to reference this list. Say
In cell B1 the only acceptable entries are that which are in column A
Can anyone supply me with a formula for my data validation which will only
allow 8 entries.
These 8 entries....appearing in the list in B1 will be 8 weeks in advance of
the current date.
I am currently using the following formula
=OFFSET(O2,MATCH(YEAR(NOW()),YEAR(O2:O200),0)-1,,SUMPRODUCT(--(YEAR(O2:O200)=YE...Need help installing Office 2007
I'm trying to install Office 2007 on my Vista PC. A short way through the
installation I get this message: " Cannot Find Proofing.en-us”....
I've searched around:
but I can't get anything to work.
Any help or suggestions would be very much appreciated.
What version of Office 2007. Did you have a Trial version already installed on your
PC and did you remove it
I need to create a data input screen on excel where multiple users
at the same time will use them & input data.
This data then needs to be stored as a database as well, where i can
use it to understand trends
and the question is ...?
<firstname.lastname@example.org> wrote in message
>I need to create a data input screen on excel where multiple users
> at the same time will use them & input data.
> This data then needs to be stored as a database as well, where i can
> use it to understand trends
>...Money 2004 #96
Is there a way to create a new blank "Report" from scratch? My Money 2004
seems to want to create a new "report" by recalling an old report and
customizing it? Thanks anyone!--
In microsoft.public.money, MartyJ wrote:
>Is there a way to create a new blank "Report" from scratch? My Money 2004
>seems to want to create a new "report" by recalling an old report and
>customizing it? Thanks anyone!--
I would first select a report from the Reports list and Reset the
report. Then Customize. Save that as a Favorite if you like.