Data Validation using List (But needs unique list in drop down lis
In sheet 1, column A is my title name while column B is person name.
Sheet 1 is my database where i do data entry in this.
In sheet 2, contains my query page. In cell A5, i uses data validation -
list, on this cell. Say in sheet 1 :
column A column B
XXXXXXX Mr A
YYYYYYYY Mr A
ZZZZZZZZ Mr A
AAAAAAA Mr B
WWWWW Mr C
DDDDDDD Mr C
But In sheet 2, cell A5, I saw in the drop down list as follows:
But i want to see this in cell A5 instead (Unique name that is) :
...Customization: disabling built in features
I would like to disable/remove some of the sections on the left hand
side of CRM. For example, on the home screen I would like to remove
the Invoices section since we don't use these. And on the Account
level I would like to remove the Notes and Contracts sections for the
Is this possible?
...Multiple name appearances
Have a list of 1000 names trying to sort by appearances >5.
Not sure if Lookup or Hlookup?
> Have a list of 1000 names trying to sort by appearances >5.
> Not sure if Lookup or Hlookup?
If your list is in A1:A1000, put this in B1:B1000 and sort by column B:
I need to figure out how to automatically assign dynamic range names to
each "Saturday to Friday" in a list of monthly day numbers and associated
day names for an entire year.
I don't know where to start.
Depending on what you wish to do, XL's built in WeekNum function may assist.
"Wes" <email@example.com> wrote in message
>I need to figure out how to automatically assign dynamic range name...Address and e-mail contact list
I do not want the e-mail address of sender automatically added to my contact list
How do I suppress
No clues here so no help forthcoming.
Want assistance? Help us help you. Give your version of Outlook. If
Express, post in an Express group - this is not one of them. If you are
using the Web interface, look under Internet Explorer as it is a part of IE,
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
A...How to force special layout of File-as, Full Name and Company
When I enter a new business contact, "Johnny Rockets" for example, I want the
Full Name, Company and File As to all show "Johnny Rockets" and not "Rockets,
Johnny." Is there a way to cause that to happen without having to go back and
adjust the items?
Outlook 2007. vista.
You can control it for new contacts - Tools, Options, Contact Options to set
the file as format and the default name order.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook &...How do I save a password protected Excel doc in order to open?
Is there a way I can "save as" a password protected Excel spreadsheet to a
different location in order to open it, bypassing the password?
on the SaveAs dialog, click on Tools|General and erase any password you find.
> Is there a way I can "save as" a password protected Excel spreadsheet to a
> different location in order to open it, bypassing the password?
Thanks for your response. I appreciate your willingness to give me some
guidance. This suggestion did not work, however. The document is not one ...Name change due to marriage...
I have a user who recently got married and would like to have her new married
name for her emails, but also wants external users to be able to send emails
to her old address until she has adequate time to inform everyone. Her new
email would be something like lastname-newname, firstname instead of
Should I create a new account with her new name and forward all her emails
from the old account to the new one and can I copy her current pst into the
THanks for everyone's help.
No. Just highlight her account in ADUC, and choose re-name. Make the
neede...Great Plains order processing
I am using Microsoft Dynamics GP 9.0 version 9.00.0310.
At our company we have a need to add an additional Sales Order Type ID
to our orders.
We want to have a different order type associated with Warranty
Returns, versus standard Sales orders. Reason behind this is because
of the end result of a Crystal report we need to generate during Order
Our ultimate goal is to have a commercial invoice generated at time of
fulfillment. But the commercial invoice needs to have different
results based on the type of order. For instance, a sales order would
have a cost associated with th...how do i add all my suggested contacts to my contacts list?
How do i add all of my suggested contacts to my plain old contact list?
Are you asking about a beta?
"Teagan" <Teagan@discussions.microsoft.com> wrote in message
> How do i add all of my suggested contacts to my plain old contact list?
CTRL+A to select all of them then just drag and drop...
Ben M. Schorr, MVP
Roland Schorr & Tower
Aut...Distribution Lists #30
Wasn't sure which would be the best group to post this in.........
We seem to be having some issues with people viewing distribution list
members. The members are not hidden and if I remove the persons permissions
and reapply them it seems to rectify the problem for a little while. I don't
know if it is coincidence or not but most of the people having a problem
seem to be listed as the manager of the DL. I have looked and followed the
article about setting the permissions in security rather than on the managed
by option but this doesn't seem to make a difference.
T...Changing font size in data validation drop-down lists
In Excel 2003, I created the value list on a separate worksheet and labled
the range so I could use it in the data validation wizard on a different
The list is working fine; however, the font size in the drop-down list is
too small to comfortably read.
So far, I have tried:
Making the font in the list larger.
Formatting larger font size in the active cell with the drop-down button
And, creating the list on the same worksheet.
All three remedies have not increased the size of the font in the drop-down
Suggestions are welcome.
There is n...Unable to Open received PO (change to "change order")
Great Plains will not allow me to change this Purchase Order from Received to
Here is the message I get:
However, if I try to enter a quantity cancelled, I get:
How can I re-open this Purchase Order so I can change the price???
Unfortunately, the pasted messages did not come through.
Once a line item is received, you can change its cost only during invoice
matching. The process would be to return the item; add a new row with the
correct cost; and receive and invoice the new item. Not an elegant solution,
Charles Allen, MVP
&quo...Could very much use a Field List
I apologize if this is out there already, but it seems that at least a few
field names changed from 1.2 to 1.3. Although I had downloaded a field list
before, from here, I cannot even find that original post, let alone any more
recent that might contain the correct field names.
I need to do some custom SQL and would prefer not to reinvent the wheel.
Thanks in advance very much to anyone who could help.
Do you have MS Access? Make a new project and attach to the database as
your data source.
You will be able to see all the tables and the field names. It has been ...Change order of A/R Statements
How can I change the order in which customer statements print out of RMS? I
would like to print statements sorted by company name. Currently, the
statements print in some random order....I think based on CustomerID.
I just had a customer tell me the same thing. They need the statements in
Alphabetical order. The current order appears to be straight out of the
customer table in the order they were entered.
It has been posted as a suggestion - vote for it and push it higher on the
"Paul Arenson" wrote:
> How can I chang...List details in another sheet
Hi, I have a sheet "Data" with transactions by customer. Column A has
the Customer ID. In another sheet called "By Customer", the user
selects from a drop down a Customer ID, and clicks a button. What I
want for this button is to run a macro to get in a 3rd sheet,
"Transactions", columns B, C, D and E from the Data sheet, for the
selected customer ID. Is that possible? Can somebody help?
"Chechu" <cecichi9@hotma...List number of permutations for text nums
I've got 4 digit text nums in A1 down
In B1 down, I would like to list the corresponding number of permutations,
Game for any formula, udf or other vba solution
Thanks for insights
Dim I As Integer, J As Integer, Rng As Integer
Rng =3D Cells(Rows.Count, "B").End(xlUp).Row
J =3D 1
Do Until ActiveCell.Value =3D ""
For I =3D 1 To Rng
Cells(J, "D").Value =3D "'" & ActiveCell & Cells(I, &qu...List of kernel mode compatible functions
Is there a list of kernel mode compatible C/C++ functions (preferably for
Wouldn't that be the WDK Help file?
Thomas F. Divine
"Jan M" <firstname.lastname@example.org> wrote in message
> Is there a list of kernel mode compatible C/C++ functions (preferably for
> WDK 7600)?
Your right of course. I just didnt look hard enough.
...when i am in the window to choose a folder to export none are list
I want to export my contacts to an excel file. When I am in the window to
choose a folder to export, there are no folders to click on.
What version of Outlook are you using?
Does anything show in that pane of the Import/Export Wizard?
"outlook export files" <outlook export email@example.com>
wrote in message news:17414043-FCB0-4C02-8ABF-C5288395157F@microsoft.com...
>I want to export my contacts to an excel file. When I am in the window to
> choose a folder to export, there are no folders to click on.
...Filtering data by custom fields in pivot tables from Visual Report
I have recently upgraded to MS Project 2007 and like the visual reporting
feature, except I really need to filter and group the resulting pivot table
in Excel by custom fields. For example, for task usage, I cannot filter my
pivot table to show only the tasks that have costs > $0, thus my table ends
up showing too many lines and a lot of 0's. I would also like to group by
department/ function which I put in a custom text field. How do I do this?
I saw related posts about saving the file as an Access database and then
creating the pivot table by connecting to the datab...Keeping Custom Properties When Forwarding or Replying to a Message #2
We have emails saved on the file system, that is kept track of by
another program. These emails have custom properties attached to
them. There is no custom form, just custom properties. These fields
were originally added using objPost.UserProperties.Add. We need it
so that when someone opens up one of these emails through the file
system, and then replies or fowards the message, these custom
properties are kept in the reply. This is so the external program can
track these emails. Is there a way this can be done? We could have
these emails opened up using an Outlook command line that i...List Box no displaying added choices
I have several drop-down list boxes in a few forms that I am having trouble
with. When I originally set up the database, I created the tables and
entered a few items to be included in the drop down list in the lookup
section of the table (design view). I then created the forms and inserted
those fields. I have since added several new choices to the drop-down list
of the table, and those new selections are available in the Table, but they
are not available in the Form. The only items available in the drop down
list on the Form are those choices that were originally there when I set up
the fo...Import contacts from Public Folder into Address List
we had an Address List that mysteriously disappeared. I have been able to
restore its contents into a Public Folder of the same name as it was
published as such. Now I have a Public Folder full on contacts but I need to
move them back to the Address List which has been recreated but is now empty.
Does amyone know how I may go about this?
Sorry, we are running Exchange 2003 Standard.
> we had an Address List that mysteriously disappeared. I have been able to
> restore its contents into a Public Folder of the same name as i...Faulting application name: iexplore.exe In Windows 2008 Server R2
I am not certain why I keep getting this exception message. In fact I get a
pop up most each time I try to access or connect using IE. Did a bit of
searching, and have not found a good fix for this yet.
I am running a Windows Server 2008 64bit machine. I tried blaming it on IE
add-ons, but now I am running in NO-ADDON mode with no add-ons but the
problem persists.I would appreciate it if someone helped with with a fix for
this on my server.
ERRORS TYPES SO FAR
Faulting application name: iexplore.exe, version: 8.0.7600.16385, tim...Contacts List Closes Outlook
A user in our company recent found that when using the
Contacts, as soon as he scrolls down the program locks up
and closes without warning or any dialog box. Any Ideas?