Dynamics GP v9 - Collections Management
Users are unable to use "user defined letters" (Word Documents) for mass
mailings. They are limited to only using predefined letters, or printing each
letter individually for every customer.
Error received when users attempt to use a custom letter:
Unhandled script exception:
Cannot find report "COL_Reminder_UpcomingDue".
This post is a suggestion for Microso...Can't find cells to change content?
I have been given an Excel document I'd like to use as template.
However, there is one item of text that I cannot change. In fact I can't
seem to find which cell it is entered in. It appears as an overlay over
the cells and does not relate to them.
I can click on any other item and see to which cell it relates. Inserted
Images highlight, and can be moved and placed anywhere. This text is not
an image either as it does not give the image handles.
If I select the whole document and delete the contents the text goes away.
NS <calypson@bell_kill_this_south.net&...IF STATEMENT REFERENCING A BLANK CELL
I'm trying obtain a blank cell with an IF statement based
on the formula B6-SUM(B9;B11;B13;B15;B17):
1. if B6 contains a reference which returns a blank if the
referenced cell is blank
2. if B6-SUM(B9;B11;B13;B15;B17) returns a 0.
I've resolved item 2 this way:
but everything I've tried for item 1 returns an error
If anyone can help, thanks.
> I'm trying obta...Extracting Multi-sheet values
I have many sheets with the same design, but on different "subjects". For example product1, product2, product3, etc...and I need to collect price-cell and 3 o 4 additional data from those products,into a summary-sheet. Is any easy way to create the summary-sheet and being able to repeat the formulas to collect the needed information?.
Jorge, the Spreadsheet Assistant add-ins, available at
http://www.add-ins.com, has a feature that does just what you want. You
would preselect the sheets, then you would b prompted for the range to
extract and the destination.
Macro...Captions and Citations won't format differently on same line.
Here's my issue:
I have several figures in my document, which I have captioned using the
"caption" command. Additionally, I have given the source for the caption as
For instance: "Figure 1: Elm Tree (Jones, 2007)."
I have created a Table of Figures, and the table of figures views the
citation as part of the caption. When I try to select the citation and
change it to normal text style (so the table of figures won't recognize it as
captioned text) it will not let me change it if it is on the same line.
My style book requ...Start assigned unique key at specified value
I am trying to set up a table that will use a 6 digit consecutive number
with a letter prefix as the key. I've got the format figured out, but how
do I start the numbering at say N100500 rather then N000001 ?
If you are using an autonumber field as part of your system, you can append
a record which is 1 before your starting point. Remember though, that even
though you may be formatting your number with the letter prefix, it will not
be used in searches.
If you have your own system coded counter, you should be able to start it
anywhere you want.
Arvin Meyer, MCP, MVP
htt...Mouse continues to select after clicking on a cell in excel.
I have read numerous posts detailing this issue and all the replies have been
unhelpful. So hopefully, I can get some actual help for this issue.
This issue seems to happen randomly, and effects one out of 10 similar
machines with the same setup. All the machines are running windows 2000
(fully patched to the latest service/security level), running Office XP, also
fully patched to the latest service/securit level.
The problem is, a cell gets selected and the mouse continues to select cells
even thou the mouse button is not pressed, basically disabling excel. The
only way to stop thi...Data Range #2
My data range for my chart is =Charts!$A$4:$C$28
How would I change the formula so the chart would update
as I add data from line 29 down to say line 40.
I would change my range from A4:C28 to A4:C40, but don't
want all the null data points.
For one possibility, check the Excel | Tutorials | 'Dynamic Charts'
page of my web site.
Tushar Mehta, MS MVP -- Excel
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <email@example.com>,
anonymous@discussi...Deleting part of a cell
I have a large number of cells containing text (name of co. or
individual, varying text string length) followed by a space and an 18
character string such as this "Shaving Centers </0016000000IMo40>" - I
wold like to retain only the initial text string (ie. "Shaving
Centers" - without the quotes of course) whether the space remains is
immaterial. Problem is the </*> part is not constant, though I think
it is of uniform length. I tried using the "IF(Right(..." function but
had no success using the substitution for the numbers ie, </*>. If
unclear ...Outlook 07 on Vista: 2 Different User Calenders Viewed Together?
My wife and I use Vista on separate user accounts. We're both set up as
administrators. We also are using Outlook 2007 for our own
Is there a way to view the calenders together, as ONE?
Is the only way to do this to set up one user account we're both
Any help greatly appreciated.
ZaveyZipper <das216at_comcast.net> wrote:
> My wife and I use Vista on separate user accounts. We're both set up
> as administrators. We also are using Outlook 2007 for our own
> Is there a way to view the calende...Application-defined or object-defined error
I find myself stumped by an incredibly easy piece of code and one that I
have used before.
I am getting the error:
Run-time error '1004':
Application-defined or object-defined error
I am getting the error when I run the following code:
Private Sub Workbook_Open()
.ScreenUpdating = False
.DisplayAlerts = False
Workbooks("phoneholdtime...runtime error 2465: application-defined or object-defined error
I'm trying to use a button on a main form to change the sort order of a sub-
subform.When I execute the following, I get runtime error 2465: application-
defined or object-defined error. opting to debug, I find the line with
orderbyon highlighted. Anybody see what's wrong?
Private sub timesort_click()
Forms![control]![worklist]![approved].Form.OrderBy = "Forms![control]!
Forms![control]![worklist]![approved].Form.OrderBy0n = True
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/a...How do I select data from a pick list and place in current cell?
How do I select data from a pick list and automatically
place the value selected in the current cell of my
Thanks John Day
You use Data validation.
See Debra Dalgleish's tutorial at:
"John Day" <firstname.lastname@example.org> wrote in message
> How do I select data from a pick list and automatically
> place the value selected in the current cell of my
> Thanks John Day
Thanks Norman...Repeat random numbers from a range and text
I am new at this, I need to create 2 different types of randomness, one of
numbers and one of text selections.
#1 a range of numbers, i.e, 134-2807 that allows repeat of numbers with a
return of only 25 numbers. This random option is use daily so I need to be
able to create a worksheet where each day only the range is changed, (without
having to key the each number of the range to a separate row line)
#2 a range of 5 process types, i.e, data, irsdat, ardat, ispdat, dsldat,
where 3 processes are selected daily from the 5 listed which allows repeat of
I reviewed the RAND and RANDBE...Splitting Cells
Im trying to enter two values into the same cell. I've seen it done, it
has a red diagonal line seperating the two values.
Thanks for any help.
MFFC2005's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25816
View this thread: http://www.excelforum.com/showthread.php?threadid=392130
First format the cell as Text. Then enter the two values separated by any
character you desire. The cell will hold exactly what you typed.
"MFFC2005" wro...Blank column to be unique increment
I'm trying to write an update SQL to fill an Integer column with an
My table has 500 rows, I want this new Integer column to be filled with
number of 1 to 500.
Is there a way to do this via an update SQL statement?
Thanks in advance.
Here is one example:
CREATE TABLE Foo (
keycol INT NOT NULL PRIMARY KEY,
INSERT INTO Foo (keycol, datacol) VALUES (1, 'a');
INSERT INTO Foo (keycol, datacol) VALUES (8, 'b');
INSERT INTO Foo (keycol, datacol) VALUES (11, 'c');
INS...sort sheet with Turkish Characters
I want to sort a column which contains turkish characters. A sample sort
output is as follows:
The correct form should be
since ç comes after c, i comes after ı and ö comes after o.
Please help me how to achieve this result.
Thanks in advance
PS: Solution for Excel XP and Excel 2003 are welcome
Microsoft sells a Turkish Language Pack for $25.00.
However, I don't know whether the pack includes a sorting capability.
http://buy.trymicrosoftoffice...Adding Comments From Cells To Chart Points.
Hi all I have spent a large portion of my weekend trying to find the
answer to this. Without much luck! I have finally come up with my
own code and was hoping someone could have a look at it. I'm looking
to clean it up and make it a little more efficient.
Thanks in advance,
Dim ws As Worksheet
Dim ct As ChartObject
Dim serSeries As SeriesCollection
Dim ser As Series
Dim Counter As Integer
Dim ChartName As String
Dim xVals As String
Dim xAddress As String
'Loop through each worksheet in workbook
For Each ws In Worksheets
'Lo...Defining a variable to = MATCH
Dim thingy As Integer
thingy = "=MATCH(""DiceC"",qperiodagentperformance!A:A,0)"
ActiveCell.Formula = _
"=INDEX(qperiodagentperformance!D" & thingy & ":D13000,MATCH(""Agen
Summary"",qperiodagentperformance!A" & thingy & ":A13000,0))"
my thingy doesnt seem to work..... no comment
Any suggestions on correcting this?
Message posted from http://www.ExcelForum.com
thingy = Application.Match("DiceC",
Sheets("qperiodagentperformance"...Order of Names in E-mail differs from that in Contacts (Outlook 2002)
I'm using Outlook 2002 and my contacts are all in the order of 'Surname,
First Name'. When I open up a new message and click on 'To' to address it
the names are all in the order of 'First Name Surname'. How can I change the
order to 'Surname, First Name'?
Thanks in anticipation. Andrew
Andrew Mawby <email@example.com> typed:
> I'm using Outlook 2002 and my contacts are all in the order of 'Surname,
> First Name'. When I open up a new message and click...difference between ActiveX and normal controls
I wanted to know what exactly is the difference between and activex
control and normal control?Is there difference in coding also?Other than the
usually used edit,combo,radio button what are other non activex controls.Are
the available on Internet for download and where are they used?
thanks in advance for the help
ActiveX controls use the COM mechanism for communication. In general, you will find
considerable differences in coding when using ActiveX controls vs. the default control
set. There are huge numbers of non-activex controls, mostly derived from other controls,...Simple "if word exist among theese cells, then true"
Im banging my head on the "find" functions. They give me a -value- when
I need TRUE/FALSE for an IF function.
It must be a much easier way to return TRUE or FALSE if a word exist
within an area:
1: Is "*Apple*" in A1:A3? = TRUE!
2: Is "*Tomato*" in A1:A3? = FALSE!
JemyM's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26945
View this thread: http://www.excelforum.com/showthread.php?threadid=517716
=N...how to do self-defined regression in excel?
Hi, I want to do regression ananlysis in excel using a
sigmoid function, which is not offered in the general 6
functions in excel(by adding trendline). How can I do it?
The Analysis ToolPak - VBA addin has a regression function
and probably everything else you want.
Tools > AddIns then checkmark Analysis ToolPak - VBA
Go back to Tools dropdown and it should be listed near the
bottotm of the dropdown.
>Hi, I want to do regression ananlysis in excel using a
>sigmoid function, which is not offered in the general 6
>functions in excel(by a...Cell Address in a pivot table
I have a pivot table which gets updated every day.
Last row in the pivot table is 'Grand Total' and the number of rows in
the pivot table varies every day.
I have another function which needs the count of number of rows in the
pivot table. Since the starting cell remains the same, I am counting
the number of rows in the pivot table = Row Number of 'Grand Total' -
Starting Cell value.
Now my question is .. how do I get the Row Number of cell 'Grand
Thank you for your time.
~~ Message posted ...Calculating age at different points in time
Using 2007, I need to calculate exact ages based on both full and partial
dates that could range from the 1400's to current day. This is for a
I would like to be able to enter a birth date into a cell which could be
month-day-year if known or month-year if known or just year.
In an adjacent column, say column 2, there would be a list of dates which
would mark various points in time, like census dates, marriage, etc. These
dates could also be month-day-year if known or month-year if known or just
In column 3, 4, and 5, adjacent to column 2, I ne...