Importing fund price histories
I am using Money 2004 Standard, and I would like to keep track of some
mutual funds that I bought a few years ago. Is it possible to import
histories of these funds? I have the daily unit prices for these funds
for the last 10 years as CSV files. Is there a way to import this data
...drop down list #14
Is it possible to have a cell that has the drop down arrow so you could
select (for example) yes or no, like you can in word or access? I have
a worksheet and this would prevent repetitive data entry. Thanks
Beenz75's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30471
View this thread: http://www.excelforum.com/showthread.php?threadid=501339
See Excel's Data validation feature.
Visi Debra Dalgleish's Contextures site for a Data Validation tutorial:
...Lists of Numbers
I have a spreadsheet with multiple columns of numbers. Some of these
numbers are repeated throughout the columns and rows. I want to run a
routine that checks each number in turn, if the number has not already
been found, then it puts it on a list on a different page. If the
number has been put on the list already, it just ignores it.
Hopefully you will understand this!!!!
Take a look here for a solution to a similar query from
"SantaUK" <email@example.com> wrote in me...Item Price history on POS screen
Is it possible to see the price of an item in the POS screen sold to that
customer previously or by a custom program button the item selected in the
cell or grid shows what we have charged this customer before by showing the
item name dates, and prices paid.
Some clients ask for bargain and we have to tell them that you have paid so
and so at so and so date etc.
Thanks for the help
Look at Purchase History in the Customer Properties. All of that
information is available, but is not searchable... You could also get this
information from a report, but that would only be within manag...Importing a distribution list into another distribution list
I am using Microsoft 2002 and wonder if I can import an
existing distribution list into another existing
distribution list? I am trying to avoid entering
individual emails into an existing distribution list.
I'd like to be able to import the entire list.
Pat Speir <firstname.lastname@example.org> wrote:
> I am using Microsoft 2002 and wonder if I can import an
> existing distribution list into another existing
> distribution list? I am trying to avoid entering
> individual emails into an existing distribution list.
> I'd like to be able to import the ...item default price level
Should provide for the option to be able to choose "customer price level" on
the item price list default price level window. This would allow for the
ability of customer based pricing. If the item did not exist on the sop
header, it currently then looks for the default price level setup on the
item. By using "customer price level" the item could be geared toward
default pricing established for the each customer.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, clic...How do i show the drop down arrow for a list in Excel
I have created an almost working data/validation/list in Excel 2003. I can
see the note when I click on the cell, but it does not show me the arrow for
the dropdown list. I have the "In-cell dropdown" box checked. Furthermore,
it will not give me an error if something is typed incorrectly.
Lastly, I can right click on the cell and it gives me the option to "Pick
from drop down list" and this DOES work.
I have created many dropdown lists before, but this one is giving me
problems. Hopefully it is something obvious that I have missed.
There are ...Sales Transaction Duplicate
I am Facing a problem in sales transaction - samrt list, that I have
duplicate transaction, but when I check customer transaction it shows only
Thank you for your cooperation
We had that issue as well for a few months. Look up Customer Source Article
# 850029 for the resolution. By the way, Microsoft couldn't give us a good
answer why this kept occuring.
"Eng. Tareq Sabri" wrote:
> Dear All,
> I am Facing a problem in sales transaction - samrt list, that I have
> duplicate transaction, but when I check customer transaction it ...Exchange 2003 POP3 service issue
We have Exch2003 running on a Win2003 server that was upgraded fro
The Exchange POP3 service will not start automatically at boot up an
once the server is up the service shows as "disabled" even though I'v
set it for automatic start and all dependant services are running.
can go in and start it manually once the server is up. Also notice
IMAP4 service is disabled but dont think thats necessary
As a result my Mac clients running entourageX cannot connect to thi
Exch box unless they use OWA via their browser in which case most o
the functionality is unavailable
Any ...CRM Performance issue
I have a install of CRM 3.0 on a WIN2k3 box. SQL2K is located on a different
WIN2K3 box. Both boxes are brand new dual procs. and plenty of resources.
The problem we are having is that while working in CRM it works great but
then after a few minutes randomly simply slows down and often takes 3 to 4
minutes to load a screen. but then jumps right back up and goes back to
normal. I have had Microsoft look into this via their support and they have
done a few things but have not fixed the problem. I also get sporadic
I have posted a docum...LIST PRICE VS PRICE LEVELS
For item prices, there is a need to enter a "list price" and then to go to
the item maintenance screen to enter the actual price. This allows for the
entry of multiple price levels. Most of the time, we do not use multiple
price levels. I would like for there to be an option which would allow the
list price to default to the actual price. This would save us a lot of data
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...How to batch update prices manually
May I update investment prices inport from a text file or execl file...
"STANLEY LAI" <STANLEYLAI@discussions.microsoft.com> wrote in message
> May I update investment prices inport from a text file or execl file...
...Can I list my workbook sheets?
I have an excell workbook in which there is a pricelist sheet for
ingredients and a (soon to be) large number of recipe sheets. Is it
possible for me to devise a list of recipe sheets from which I can
choose the recipe I wish to work on? Also, can I have the user use a
form for data entry, not the general one on the Data menu?
Thank you for your help.
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
for the second question see:
...Changing Item Prices
If you use the "Inventory Wizard" to Change item prices, say for a Given
Department for 10% off.....how do you cancel this if you find you wish to
stop the sale early due to it being toooo popular?
Well, run the wizard again to adjust the prices back up. Or have I over
simplified your question?
Tiber Creek Consulting
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.
Michael Thomas wrote:
>...Price change #2
I have a customer that in some instances when open an item at the Manager
Module and try to open the a second items, then the system change the sale
price at second item with the price of the first item opened. It this a
problem with ver 1.3 .? How we can be fixed?
That is a known issue. Upgrade to resolve.
> I have a customer that in some instances when open an item at the Manager
> Module and try to open the a second items, then the system change the sale
> price at second item with the price of the f...distribution lists as the FROM:
We're in the middle of a migration from Exchange 5.5. Several of the
servers have already been migrated successfully.
Now, here's the situation... follow me closely...
There is a distribution list created in Active Directory (via the ADC
connector I suspect) that multiple users can use to send FROM. One such
user, who is on a 5.5 server, is able to perform this operation just
fine. The messages are sent FROM the DL and TO other DL's in the directory.
After moving the user's mailbox to 2003, she is now unable to send
notices out FROM the DL. A non-deliv...Re: Drop down lists
Microsoft MVP Excel
"Don Guillett" <email@example.com> wrote in message news:...
> ??? That web site has all the information you will ever need on drop
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> "Don" <Don@discussions.microsoft.com> wrote in message
>>I accessed the website below but did not know...Public Folder Issue
I have an issue with my companies Public Folders on Outlook. First
off we cannot afford Sharepoint at this time so don't tell me to buy
We have about 100 public folders, all of them have different users
different attributes. There was a lady who helped develope all the
folders who worked for us for 10 years. She has since retired and
left. Some folders have her as the admin still. I want to be able
to go in and change the properties of the folders and set up
diffferent users permissions. When I click on summary it's grayed
out. Do you know of a way to either...and also, how to run a function upon selection of validation list box
I forgot to mention.
What if I would like to do something after the person chooses 'red' (see my
previous post). I would like to ask them if they would like to copy this
value to all rows with some common criteria, say category = dresses etc.
How to do?
I know vba from access .
Thanks again for your help.
...Can PM Edit List be modified to include GL Summary Distributions?
Is it possible to modify the Payables Edit List to inclue GL Summary
When a Payables batch is POSTED a report generates called "PM GL
Distributions Summary" which lists the SUM of each GL account used in the
batch regarless of the voucher.
For example, assume a Payables batch contains two invoices. The Accounts
Payables account on 1st invoice is $35 and on 2nd invoice is $15...this
report will basically show Accounts Payable account used on this batch is
equal to $50 total.
We would like to modify the Payabled Edit List so we can see these GL
distribut...Receiving POs and the Price Field
I cannot make sense of the "Price" field on the PO receiving screen! Only
the "New Price" field seems to update the item price in the database. The
Price field seemingly has no functional purpose, yet it helps calculate the
Extended Price and is itself a calculated field! Can someone please help me
make sense of it? How is it meant to be used?
This is a multi-part message in MIME format.
Without lo...Graduated pricing- mult-tiered pricing, bracket pricing
We have a client that wants to charge only for items over 500 units. Less
than that would be subject to a minimum charge. We did a item for the
minimum charge but when we did the price level with 0-500 units at zero cost
and item 501-9999999 at $0.50. (It is similar to the income tax brackets)
It charged for all 501 at .50 not just the one unit. The extended pricing
module says it can have multi-tiered pricing but there is no training
material addressing it and Microsofts search engine has no results on how to
do it, but does mention it in the marketing material.
In o...To-Do List hangs
I use Outlook with BCM 2007 running on Windows XP. All have current updates.
Clicking on "To-Do List" in the Navigation Pane always causes Outlook to
hang. "Tasks" and "Project Tasks" function normally. The "To-Do Bar" task
list functions normally (including display of BCM project tasks).
This problem started about 2 months ago. In the meanwhile I reformatted by
hard drive and reinstalled all software (for unrelated reasons). I had hoped
the To-Do List problem would be resolved with the reinstall, but it is still
Any solut...Mailing list in Excel
I have a mailing list in an excel spreadsheet. How can print envelopes to
the addresses listed in excel?
See David's site
Regards Ron de Bruin
"Lori Morris" <Lori Morris@discussions.microsoft.com> wrote in message news:4A249722-642E-4BE5-B53F-E3C53CF94CF6@microsoft.com...
>I have a mailing list in an excel spreadsheet. How can print envelopes to
> the addresses listed in excel?
...Internet Explorer Not connecting issue.
Until Ethernet is connected with another machine,Internet Explorer could
not able to connect with WiFi and GPRS.
I am working with VTC6100 Development board. It is having Atom x86
Processor,Ethernet,WiFi and GPRS(Sierra Wireless modem).
Bug Produced Sequence:
1. Boards Boots up from CF card but Ethernet did not connect with another
2.After Board Boots up WiFi is configured with Access Point.
IP,Subnetmask,Gateway and DNS
address are configured.Gateway and DNS of the Ethernet are cleared and
IP,Subnetmask is configured for Ethern...