Looking for a method to print only those worksheets that the user has entered data into
I have a workbook that has 7 worksheets un-hidden. Of those, each has a limited number of cells that are un-protected. Each sheet prints to a single page. The user can enter data on one, some or all of the sheets. Is there a short-cut method that would allow the user to (at a single click) print all of the sheets that have user-input data and not any of those that are left 'blank'
not possible without VBA
"rpw" <firstname.lastname@example.org> schrieb im Newsbeitrag
news:732719CD-1559-4CD1-B0...Advance Find Order Product
Using Advance Find, is there a way to search Orders that have both Order
Product A AND Order Product B?
I can easily find Orders that have either Order Product A or Order Product
B, but can't seem to make it look for both.
Three Day Bump.
Don't have CRM in front of me, but try this:
Create advanced find with 2 lines using the same field. Select both lines,
group as 'AND'.
> Three Day Bump.
Ok. I tried that and got no results back even though I saw at least two that
fit my query.
...Function to find largest number from a series of numbers?
Is there a function to go across several columns of numbers and pick out the
largest one? If not, how would I write that function?
thanks to all
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
It's easier to beg forgiveness than ask permission :-)
"rs" <r_schiller@REMOVEcomcast.net> wrote in message
news:2p-dnW3P0f...Finding Values With more than 2 decimal Places
I am using sumif to verify some numbers. These should all be dollar
values and thus should not contain and values past 2 decimal places
however when I use the sumif it returns values with long decimals? I
have been unable to find where these decimals exist visually and i
tried this formula to help me identify them
^ hopefully this would let me know if a decimal past 2 places is
present in a value but I still am unable to find them?
any help would be apreciated
-------------------------------------------...how to find the last modified user?
Is it possible in CRM to determine who last modified/altered a particular
record (of any entity)?
Esp, who last modified the details of a particular contact?
There is an example in the SDK of building an "Auditing" module for the CRM
admin which would give views of who changed which records, etc.
> Is it possible in CRM to determine who last modified/altered a particular
> record (of any entity)?
> Esp, who last mod...Modifying the "Required Attendee" lookup columns
Is there a way to modify which columns appears in the lookup view of the
multi-select "Required Attendees" lookup on the Appointemnt? This special
windows does not seem to take the usual "account" or "contact" lookup view.
Right now it only shows the name and full name of the account or contact.
Did you happen to get the solution to your query as i am with the same
problem and looking for someone to help....:(
"Fred Bang" wrote:
> Is there a way to modify which columns appears in the...Modify/customize login and logout page
Anyone know if it is ok to modify/customize the exchange login and logout
Yes. This may help:
Customizing the Outlook Web Access Logon Page
MVP - Exchange
NEW blog location:
"Brent Anderson" <BAnder9447@aol.com> wrote in message
> Anyone know if it is ok to modify/customize the exchange login and logout
...Modifying cell entries?
I have a range of cells in a spreadsheet containing values, say cell A1 : C5.
Example as follows:
A B C
1 100 100 100
2 100 100 100
3 100 100 100
4 100 100 100
5 100 100 100
I often need to edit all the individual cells in the range to become
"=100*86%" because i need to keep the original value in the cell as well as
shown the resulted value in the cells too, in this case it is 86 (result
after 100 multiple by 86 percent).
How do i cr...NDR Sending to E2K3 Users from E5.5
I have recently installed E2K3 in mixed mode to work with our existing
Exchange 5.5. AD is running in interim mode while our NT 4 BDCs get replaced.
I have migrated a few users over to E2K3 with no problems. However, Exchange
5.5 users cannot send email to mailboxes that were created on the E2K3
server(NDR report 5.1.1). The migrated users can send to these mailboxes. Any
help is appreciated.
After a little more digging I have found that the new users being created are
being placed in a USER container instead of the recipient container which is
where the 5.5 user...very simple question, but i cant find the answer
I am trying to write a generic tool that accesses a SQL server and
reads/updates/deletes/creates records. I want to reference this tool from
my asp.net pages to talk to my db. by the way, i want the results of any
read, update and create to be returned in xml.
when reading data, i populate a dataset with data and then use the
dataset.getxml method to return xml. is this a neat way of reading data?
how does it compare to the FOR XML EXPLICIT command in sql server?
when creating/updating data i was thinking of using a data adapter but this
seems a bit over the top, maybe i am wrong?...Create appointments for another user
Is it possible to create an appointment from another user. I need to be able
to create a case for a CSR and if necessary, also create an appointment on
his/ner calander. Thanks in advance.
You can create the appointment or case, after you created it (for yourself)
you can assign it to someone else or to a queue (if you have enough rights
for it). The assign option should be in the action menu.
Hope this helps,
"Chris Pelon" wrote:
> Is it possible to create an appointment from another user. I need to be able
> to creat...Import users from mixed mode Domain
I have a domain with 2 sub domains (Sub-Domain A and B), and I installed the
MS CRM 3 on sub-domain A. The functional Level of Sub-Domain A is 2003 Native
and Sub-Domain B is Mixed, because the existence of NT4 PDC.
On Deployment Guide 3.0.5 MS CRM, on page 6-12 tell how to add users from
mixed mode, and because I'm new on this, I can't find the role "Browser for
Microsoft CRM", wich is necessary to be assigned to the local security group
that I will create with users from mixed Sub-Domain B. Can anyone help me
with this step?
...Finding a row with the heigest/lowest value under specific conditions.
Goal: Find the row with the highest of lowest value (can be with extra
Example 1 find the row with the highest value.
Example 2 find the row with the highest value not exceeding 3.5.
What is the most elegant (???) way to do this ?
The examples are simple enough, but if they become part of a larger query,
the solutions become less elegant.
(In example 2 the condition is repeated which I consider less elegant.
In the second solution for example 2, the with is used this only works in
recent versions of SQL-server and not in other SQL implementations)
S...Any way to change default FIND options?
When I do a CTRL+F to find information, the OPTIONS always
is set to Look In Formulas. Is there any way to get is to
default to Look In Values?
Put this in the ThisWorkbook module of your Personal.xls workbook (or
any other workbook in the XLStart directory):
Private Sub Workbook_Open()
Dim result As Range
Set result = Sheets(1).Cells.Find( _
Find options are persistent, whether done in the GUI or in VBA, so doing
a find will set the LookIn value for the next search.
In ...Add Users to the Business Portal site
I have a new installation of Dynamics SL FP1, Business Portal FP1 and MOSS
All of the installs went great without any errors during the installation.
Next I configured Dynamics SL with a database update, added users, added all
of my registration keys, created databases and then installed the business
Agian all went well..
Then I went into the business portal site and tried to add users.
So I go to the business portal home page and click site actions>site
settings> under Business Portal administration i click the link users
The first thing i get ...One user cannot logon to OWA
I have an instance where one user cannot login to OWA. It worked for her
before and she is the only one experiencing the issue. I actually deleted
her entire account from active directory, deleted her entire email from
Exchange, synchronized to all domain controllers, re-added the account (same
naming conventions), but she is still having the same problem. When I create
a new account with totally different naming conventions, no problems at all.
I thought everything for accounts was recognized as a SID, not by name. Is
it possible using the same naming convention is causing the aut...Finding contacts with user-defined fields
About 10% of my Contacts have two extra user-defined fields,
CMADatabase and CMAContactIndex, which appear to have been added by
either copying and pasting or playing with Small Business Contact
Manager at some point. I can't import these contacts into another app
from Outlook, therefore I need to replace them first
I can do this by exporting them as vCards and reimporting them,
however I don't know how to /find/ them without examining each contact
individually, because the fields don't show up in "user defined fields
in this folder". Is there another way of finding thi...How Do I Find My Posts Here?
Sorry, but it's not obvious to me how I find my posts here. Doesn't seem to
be a way of searching for my user name that I can see.
Any help appreciated.
Ironically, by posting this, I have found one way, i.e. by clicking on my
user name in this post and searching for recent posts.
Is there another way?
> Sorry, but it's not obvious to me how I find my posts here. Doesn't seem to
> be a way of searching for my user name that I can see.
> Any help appreciated.
Try using a better news reader?
http://www.insideoe.com/resou...Excel user form interface
I am hoping someone can help me with the following problem. I have a form as
the interface for an excel spreadsheet where a user enters the data into the
form which in turn sends it to the spreadsheet. Unfortunately the worksheet
is unprotected and user can therefore manipulate the data or formulas.
I was wondering if anyone can help me with any lines of code that i will
need to incorporate into my code so that the worksheet can be protected
without causing errors when the user form is invoked. One way I believe may
work is that the worksheet is initially protected. Once the user clicks on
I have exchange 2000 and I need that all users have an internal mail but
only some have external mail.
How I can configure this?
Please help me?
Sorry for my English.
...Autofill to last row in a database
I have a large file but it varies in size each month. When i recorded a
macro the file seems to copy down the column in a fixed method as shown below-
I was wondering what i can insert in these areas so that it will AutoFill
automatically to the bottom row of column F no matter how many cells are
Please help me out. Thanks
Message posted via http://www.officekb.com
Selection.AutoFill Destination:=Range("H2:H" & Range("F65536").End(xlUp).Row)
HTH...Can't find how to change Y-axis range to show new data in Excel Mac 12.2.4
Operating System: Mac OS X 10.5 (Leopard)
I have a simple bar chart that I created some years ago in a previous version of Excel. I add data each month and it shows miles I drive per month over the year, very helpful to keep track of distance and gas mileage. I've extended the Y-axis range downward a few times before, but can't find out how to do it this time. I always install the latest updates from Microsoft and now I'm running Excel 2008 for Mac version 12.2.4 (100205). My Y-axis range in this chart starts at 800, but I drove only 772 miles ...Start/stop Services for Power users
Does anyone know of a way to give start/stop Services permissions to our
Power Users group? I know a GPO can be created to give permission to each
seperate service but I would like to give start/atop permissions for _all_
services if possible.
Actually the power-users group goes away in 2008, so for future-proofing
your plans, you may want to reconsider this plan.
What is the goal you are trying to accomplish? *WHY* do you want power-users
to be able to restart services?
"Nick" <NoOne@NotHere.com> wrote in message
news:uZ...No webmail access for W98 users
We are running MS Exchange2003 on WServer2003.
W98 & 95 users outside of our network are denied access to their web based
email. IE displays "access denied" before reaching the login window. WinXP
users have no problem. All our clients in network are XP Pro.
Thanks to anyone who can help!
"hswpit" <email@example.com> wrote in message =
> We are running MS Exchange2003 on WServer2003.
> W98 & 95 users outside of our network are denied access to their web =
&g...CRM should let me decouple conditional statements in Advanced Find
We have set up a number of saved searches in CRM 3.0 that users would like to
use Save As to create a copy and then add search terms to. Unfortunately,
CRM 3.0 does not allow you to decouple conditional statements once the search
has been saved. In order to add an AND condition, this feature is required.
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...