Is there a way to get an auto page break as data changes in Excel.
I list my students by grade and by teacher. Is there a way to force a page
break automatically as a specific piece of data changes (ie; teacher name,
only possib le using VBA.
"george_visalia" <firstname.lastname@example.org> schrieb im
>I list my students by grade and by teacher. Is there a way to force a page
> break automatically as a specific piece of data changes (ie; teacher name,
> grade, room)?
If your teacher n...how do i transfer data from excel to another program
how do i transfer data from excel to my maximer
Whats a maximer?
> how do i transfer data from excel to my maximer
Copy and paste?
I think "transfer" would depend upon how the other program handles data from
"maximer" is not a program I am familiar with.
Perhaps it has an Import function?
Gord Dibben Excel MVP
On Fri, 21 Jan 2005 12:51:08 -0800, ann <email@example.com> wrote:
>how do i transfer data from excel to my maximer
...Erron on Web.config identity impersonate
My Web.config file in my C# .Net web application has the
< identity impersonate="true" userName="myaccount" password="mypassword" >
However, in some cases the web.config and our environment didn't match
and in client's browser there's error page showing that line
< identity impersonate="true" userName="myaccount" password="mypassword" >
How do I config the Web.config so the error message won't show the Username
and Password stuff?
Thanks for help.
Jason Huang ...Populate sub form
I have asubform that is linked to the main form via one field, multiples
entries are allowed in the sub form, but the linked field is the same for all
I can add new records manually in the sub form okay.
What I want to do , sactivate a query/programming etc that is done by
clicking a button that automatically adds several records to the subform from
a table that contains potential data items based on a field in the main form.
ie if the item in the main form is set to tru, then the sub form is to have
several specific records added to it.
how do i do populate the subform ...Auto reply #4
I was just wandering if there is a way to Auto reply to
emails you receive, if you are gonna be gone for like a
See if the information on the following page helps:
MVP - Outlook
*** Replies sent to my e-mail address will probably not be answered --
please reply only to the newsgroup to preserve the message thread. ***
"Jeff" <firstname.lastname@example.org> wrote in message
> I was just wandering if there is a way to Auto reply to
> emails you receive, if...new desktop shortcut fAils with data protection error
windows xp sp3
internet explorer 7
solid state hard drive, sata second drive.
New desktop shortcut to second drive when you double click it brings up a
data protection error. If you right click and go to open it brings up the
open with dialoug box.
All of the original shortcuts work correctly. Only a problem with the ones
that were made with in the past 3 weeks.
Loretta, the drive opens fine when you try from MyComputer? When you
rt click the shortcut does it show you properties dialog
box with path of target ( sata drive )? Or, when rt click...Auto reply on sent once to each recipient.
We are using Exchange 5.5 sp4 on Win NT 4.0 server sp6a and varied client
setup of Win 2k SP3 / office 2k sr1 or NT 4.0 sp6a / office 2k sr1.
When Out of office reply is swicthed on, people who send the Out of office
mailbox an email will only receive the out of office autoreply the once.
Every time they send an email after that they do not receive the Out of
office autoreply even though the reply is switched on. If how ever the Out
of office is switched off and on again, the process will start again, only
one auto reply will be sent to each sender.
I have found MS KB article 1579...Delete all server data
We need to delete all the server data in crm. All accounts, contacts,
activities, sales data etc but we have to keep all customizations and custom
Remind that we have also several outlook laptop clients that go offline with
How to do this?
Delete all data in crm manually??
Does the synchronisation delete all this records also in the local database
on the laptop?
Give the server a new database after we did export all customizations?
How do we get the new database on the outlook client afterwards?
Uninstall outlook client and install again?
If you really want to ...importing bin data
Since Integration Manager does not offer the ability to import Inventory
items along with their bin locationsand quantities, is it worthwhile to try
to import bin quantities into GP via Table Import?
Table Import certainly offers that advantage over IM and any other
integration product. Take a look at my article on Table Import at
http://dynamicsgpblogster.blogspot.com/2008/10/often-overlooked-yet-powerful-table.html for a complete overview.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
The D...Auto Number Concern
While looking at my tables, I noted that the AutoNumber has changed
radically. Expecting the table to continue building on the three digit
autonumber, I was surprised to see 10 digit autonumbers appearing and at
times preceded by a minus sign. What gives? I created a master with a
replica...is this the source for the change? Thanks Cheese
Yup: when you use Replication, the AutoNumber field is changed from
Sequential to Random. There's no way for you to change that behaviour.
Fortunately, it doesn't matter. The only intent of an AutoNumber field is to
provide a (practically ...AUTO CATEGORIZE
Does anyone know how to set up money so that it will
automatically categorize charges to a particular payee to
a cateogory? Currently only some of my credit card
transactions come with a category and it will be too much
work to categorize the rest of them. Also without
categorizing transactions then the reports do not make
Perhaps personal finance management is too much work as well.
"Jeffrey Sanders" <email@example.com> wrote in message
> Currently only some of my credit card
>...How do I "auto save" my file in MsOffice2003 Exel?
Dave Peterson's reply to a similar message may help you:
Excel FAQ, Tips & Book List
...eliminating unwanted data
Column a has data, column b has data.
I want ap1 to equal q1 if a1 equals b1.
Actually I am looking for a way to eliminate rows if data in one column
a second column.
Your question is confusing. Do you simply want to delete rows where the value
in column A equals value in column B?
I don't see the relevance of making ap1 to equal q1 if you are deleting the
row anyway where you have 2 equal values. Might as well compare A and B and
Anyway the following is a sample of deleting rows based on a condition. It
firstly sets the interior ...OWA public folder data does not match actual data
Viewing a public folder calendar through OWA does not match the
contents when viewing it through Outlook 2002 or 2003. If I change an
existing appointment or add a new appointment, the data shows up but
random existing data does not show up in OWA.
Running EX2K3 SP2 on Windows 2K3 SP1
How many public folder servers do you have? Are they perhaps looking at
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"B.E. Jorgenson" <firstname.lastname@example.org> wrote in message
news:1163007900.164594.135120@h48g...Auto Forward Problem...
Is there a way to set auto forwarding to an address not in the global list.
I 've tried creating a rule to do this ... but it's not working.
I would just like to check for mail from a specifc user and send any
that come in to email@example.com
thanks in advance...
> Is there a way to set auto forwarding to an address not in the global
> list. I 've tried creating a rule to do this ... but it's not working.
Rules aren't the best way to do this anyway - see
http://www.msexchange.org/tutorials/MF015.ht...Import data from Money 2002 to Excel
I'd like to import some transactions history from Money
2002 into Excel. Does anybody know how I can do this?
In microsoft.public.money, Nick wrote:
>I'd like to import some transactions history from Money
>2002 into Excel. Does anybody know how I can do this?
Prepare a report in Money and right-click into it. You can copy and
paste or choose Export....
For more sophisticated information access, search Google for
...Auto tab- Auto fill
I'm looking for a general formula for the entire worksheet. My secretary
spends extra time looking for the proper column each time she subsequently
enters a vendors name .
Is there some formula that would recognize the second (third, fourth, etc)
time a vendors name is entered and auto tab to the column that was last used
for that vendor? Also, the same for many different vendors on the same page.
Same question a different way: if the vendor's name were entered a second
time and a different amount were entered could that amount be auto filled in
the column that was used p...Outlook Web Access...
We're using Small Business Server 2003 & several of our sales people use the
outlook web access for email.
When creating a new email, is there any way to be able to hit the "To"
button & just have it bring up a list of addresses from the contacts, rather
than have to search for them?
Mike <firstname.lastname@example.org> typed:
> We're using Small Business Server 2003 & several of our sales people
> use the outlook web access for email.
> When creating a new email, is there any way to be able to hit the ...Great Plains POP10390 distribution data gets deleted when posting a batch
We are using GP version 10.1...Since last week, we started to lose the GL distribution on POP transaction (invoice matching)...it seems that the records of the POP10390 file get 'flushed' randomly...
Today we had an occurence where a posting report got 'stucked' at 50% of progress on the screen of a user...we waited more than 1/2 an hour and the batch never end posting...it did also create a situation where other users could not post either...(just like there was a lock on the file...where the record got flushed....
Any clues...we can't believe that it never ha...Main Outlook Data File Appears Several Times
The same data appears two times in the navigation pane view. The folders are
identical and information changed in one is duplicated in the lower view. It
is obviously one file but appears twice. Any suggestions?
Michael Obymako <email@example.com> wrote:
> The same data appears two times in the navigation pane view. The
> folders are identical and information changed in one is duplicated in
> the lower view. It is obviously one file but appears twice. Any
You have a corrupt mail profile. Create a new one with Control
Panel>Mail>Show Profile...Insert & update data
Is there any tool to update exsisting data and insert record if data is new?
Exp: when we are importing data from a file say excel(accounts)based on
Account name, tool has to check whether that particular record(Account) is
already exists in CRM or not if record exists then it has to update that
record with new data comming up from file.if not present then it should
insert/import new record(aacount) with new data.
Thanks in advance,
You can use Scribe (http://www.scribesoft.com/) to update existing records
in MS CRM and insert new if the record does not exist. You ca...Auto protection of cells
I have the Dates in Column A , I want to protect the cells in Cloumn
B , based on todays date .This needs to be done automatically w/o
going to format cells , protection . How to do that ?
I mean noone can make any entry to the date other than Today's date
Try Data Validation.
Select Select cells then to get into data validation:-
xl2007 version: Data tab on ribbon->Data tools block->Data Validation
pre xl2007 versions: Menu item Data->Validation->
In allow field: Select Dates
Data field: Equal to
Uncheck Ignore blanks
In Formula field: =today()
Regards...Limit data synchronization in Outlook
I try to find a solution to limit all user to synchronize
his own record for security reason in Outlook.
I know CRM have a checkbox for BU only but this check box
can be remove by the user, theire is not a big security...
Did somebody know ISV or something else for that?
I've got an excel spreadsheet with a column of 120 names.
each name has columns of stats that were entered weekly and have summary
The league ran for 22 weeks.
I would now like to use the spreadsheet again.
How can I remove the data entered weekly that utilized formulas? What I mean
is the weekly stats utilized weekly formulas and then the overall summary
I can't just clear the data weekly because it wipes out the formulas. I can
only clear the columns that were entered for the weekly stats.
I hope I'm explaining this correctly.
Also, the spread sheet ha...Returning a value in excel my matching 2 data points
A B C D
Number1 Number2 Date
436542 142165 1/13/2010 #N/A
436542 416041 9/2/2009
1412386 426560 11/24/2009
1470623 1450350 9/10/2009
1477592 1454289 11/20/2009
1477592 1461105 10/14/2009
1478272 1470623 7/13/2009
1479975 1479975 8/25/2009
1484981 1485960 7/13/2009
1485960 1487238 8/25/2009
1485960 1487238 1/13/2010
1487238 1491168 10/26/2009
1502653 1491168 1/13/2010
1502653 1491822 1/13/2010
I have two sets of data is seperate reports. 1 lists number and other info I
need and the other lists Number and date. I added co...