Autofit Row Height #3
I have a column on sheet 1 that is set to wrap text so that the row height
increases and decreases as more text is entered into the cell. This works
Users enter a number on sheet two where there is a lookup function that
returns the appropriate text from sheet 1. The problem is that when the text
is returned by the function, the row height does not adjust to fully display
all of the text in the cell. Is there a way of automating this?
Any help would be appreciated.
...RMS Troubleshooting and Basic Set up v4/3/2005
I have decided to post the information on the net because ms newsgroup does
not have a long message retention.
...Converting Crystal report from MSCRM 1.2
I have a client who has upgraded to V3.0 for CRM. They want to continue
using Crystal for their reporting engine because they have 40 custom reports.
Does anyone know how to easily accomplish this? I have created a new
connection to the new CRM Views in SQL, but I can't seem to figure out how to
easily replace all the fields that are currently in the report using the SSO
connection to my new connection.
Any help would be greatly appreciated.
many of the services such as rpttosql.com say they will only convert so
far. some even say they will only get the general lay...columns in RMSSO
Is it possible to change the columns on the forms ??
Receiving po contains:
Type, Item Lookup Code, Reorder Number, Description, OtyOrd, QtyRTD,
QtyRcv, Cost, Price, NewPrice, Extended
Item Lookup Code, Description, MPQ, Price, BinLocation
We need to modify few other forms as well.
I think I've seen that in one of the add-ons while ago, but I cant
remember which one was it and I'm not 100% sure if I really did.
...Need to export from outlook 2007 into Excel, include date and tim
Exporting from Outlook 2007 to either Excel or Access
Need email information
date sent not modified
Karl Timmermans - The Claxton Group
ContactGenie - QuickPort/DataPort/Exporter/Toolkit/Duplicate Contact Mgr
"Contact import/export/data management tools for Outlook '2000/2010"
"MicroMacroMicro" <MicroMacroMicro@discussions.microsoft.com> wrote in
message news:3B2AD2A0-7A64-45D7...I need to pull out a users email from Exchagne 2003 and put it into a .pst
I think I'm supposed to use ExMerge.exe, but when I try to run it, I get
"This application has failed to start because EXCHMEM.dll was not found.
Re-installing the application may fix this problem".
I found the application at:
I installed it into "Program Files\exchsrv\bin"
"Galvanon" <email@example.com> wrote in message
> I think I'm suppose...Reference column question
Setting up a tabulation speadsheet,has 40 rows and 10 columns.Question is
when I do my formula which is a subtraction for each column,I want to use a
refernce # from the first row of each column =Sum(F1-D3)=SUM (G1-D3)and so
to=Sum(P1-D3)Rather than enter each manually,because cut and paste adds 1 to
each column how can I get to use f1 as reference for that column G1 for that
If I understand correctly, try putting a $ in front of the row reference.
Also, sum is not necessary for what you are doing.
as you copy that down it becomes
copied across to the ri...Embedded word doc changed to image-need to change back to word.
I have an embedded word document that misteriously changed into an image.
This image is not a word doc converted into a picture (i.e. like I convert an
embedded word doc by right clicking and selecting 'image object', 'covert',
and then select to activate as a word doc.) but an actual image as if I
inserted a picture. Need to turn the image back into a word doc so I can
recover my work. It would also be nice to figure out how I am changing to an
image, amost seems like a bug since it has randomly happened twice.
I have a table linked from an SQL Server database that I would like to update
through an Access form. I need to use a series of check boxes to adjust
over 100 different fields, but I need the check boxes to update the fields in
the linked table with 1 for yes instead of -1. The reason for this is that
the other software that loads information from the database uses 1 as the
value for yes and cannot be configured otherwise. I cannot use custom
formatting on the table fields since they are linked. I am assuming that a
VB script is the way to go, but am having trouble getting...Protection Problem #3
I have a 3 sheet excel file with protection on all 3 sheets (let's call
them A, B and C). These 3 pages have formulas that link to each other.
Sheet A has a few checkboxes that link to sheet C. The problem is that
when I try to check any of the check boxes on sheet A an error box pops
up that says "The cell or chart you are trying to change is protected
and therefore read only". Is there a way to protect a sheet while being
able to check a box off that is linked to another sheet? What protection
options would allow me to do this?
Thanks in advance.
----------...Wild curser #3
> Your scroll lock isn't on ... is it?
No, it isn't- thanks! I've tried putting it on and off a few times
just to double check.
...Need help extracting text from EDLs
I really am trying to learn this stuff, but I haven't programmed anything
since my TRS-80 Basic days and I'm a bit overwhelmed.
I want to extract text from Edit Decision Lists so that I have a list of
shots used in a film. Here is an example of one event of an EDL:
002 TAPE004 V C 04:45:22:06 04:45:24:14 02:00:08:00 02:00:10:08
FROM CLIP NAME: 7C-4_B_
DLEDL: PATH: /raids/luc_1/bun/reel_02/oscans/1222/bun_7c_4_b_02/2048x1556/
The text that follows "FROM CLIP NAME:" is the name of the clip that I want
to extract so that I have a document on onl...All Columns are not to move
How can I stop the columns from moving to the left of the Table?
On Sun, 3 Feb 2008 17:28:39 -0800, Roger <Roger@discussions.microsoft.com>
>How can I stop the columns from moving to the left of the Table?
You'll have to explain what on Earth you're talking about, Roger. What columns
are "moving"? How?
John W. Vinson [MVP]
Good evening John,
I found my own answer:by bringing the cursor to the first cell, the first
column will not scroll to the left anymore; however, when I bring the cursor
to any other cell and scroll to the rig...sending attachments #3
I downloaded all the security updates for Outlook 2000.
Now Outlook can't send attachments. The attachments
appear in the "send" directory, but the receiver of the
email gets no attachments.
The Outlook security feature blocks attachments that are potentially unsafe. This security feature provides an additional level of protection against
malicious messages. Although Outlook 2000 SR-1 or Outlook 2000 SR-1a blocks access to the attachment, the attachment still exists in the message.
For more information on resolving this issue, please refer to Knowledge Base art...Synchonization with SFO 3.0 performance
I would like to know if the syncronization of the Sales for Outlook has
better performance in release 3.0 ??
Is there a place i can find information on the way the new SFO is working ?
I was meaning 'Is there a place i can find information on the way the new
SFO is built' . Does it still use Cassini ?
> Hello everyone,
> I would like to know if the syncronization of the Sales for Outlook has
> better performance in release 3.0 ??
> Is there a place i can find in...Text-To-Columns Fixed Width
When using Text-To-Columns, Excel "recognizes" that the data fits the Fixed
Width criteria and PRE-assigns the width.
In most of the cases I work with Excel is wrong 99% of the time.
Is there a way to force Excel to NOT pre-assign the width (leave everything
On the first panel of the wizard click Delimited, then on the second
panel click space as the delimiter.
Hope this helps.
On Feb 4, 12:50=A0am, TP <T...@discussions.microsoft.com> wrote:
> When using Text-To-Columns, Excel "recognizes" that the data fits the Fix=
> Width ...How to get total "conditional sum of cells" in a column?
I have dollar amounts in one col, and status in another. I want the
sum of those dollar amounts where the corresponding status cell is
empty (blank). How do I do this?
Thanks for any hints,
Status in Column A and dollar amounts in Column B:
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"sherifffruitfly" <firstname.lastname@example.org> wrote in message
news:email@example.com...Publisher help #3
I created a website and i am able to upload it and view it in firefox but not
in any version of IE. Not exactly what i did wrong. But any help would be
Repost this question in microsoft.public.publisher.webdesign newsgroup and
add the URL to your problem website.
Microsoft MVP Expression
"Astroda" <Astroda@discussions.microsoft.com> wrote in message
> I created a website and i am able to upload it and view it in firefox but
> in a...Delivery Status Notification (Delay) #3
I have been receiveing several message stateing thet my message has been
delayed. Why is this happening and is there a way to configure this so that
the message does not become delayed?
below is a copy of the message that i receive;
This is an automatically generated Delivery Status Notification.
THIS IS A WARNING MESSAGE ONLY.
YOU DO NOT NEED TO RESEND YOUR MESSAGE.
Delivery to the following recipients has been delayed.
...newbie needs help in Ezcel programming
Hi everyone, please help me with this, newbie to Excel.
I know what I want but, but dont know how to get it!
I have a spreadsheet called Rawdata.xls and within that a sheet called
"table a". The sheet contains data within B10:I100
where column b contains a list of non-unique codes, and column C
contains a number of unique identifiers.
Another spreadsheet called Tables.xls contains a sheet called
"Numbers". Cell B10 contains a list of all the codes contained in a
defined range (which is the same as all the codes in column b of "table
a" in RawData.xls
What I ...Sort column with first and last name by last name
I have a mailing list with 10,000 names. The first cell has first an
last name in the same cell. First name is listed first. Is there
formula to sort and/or separate text in a cell. I would like to sort o
separate the first name from the last in the cell to allow for a mai
merge by name. Using Excel 2002. Thank you
Message posted from http://www.ExcelForum.com
If you have just first and last names separated by a space, Data>Text to
Columns would be the easiest method to split into two columns.
If more than that, like names with van or von or de etc. you may need a
different m...I don"t office,but need Excel or some part of it to open a web pag
help me I don't won't to load all of office
> help me I don't won't to load all of office
you can buy Excel as separate product.
"cowboy" <firstname.lastname@example.org> schrieb im Newsbeitrag
> help me I don't won't to load all of office
When about to load office, choose custom. You can then
choose when to load certain parts. You can install them
when you use them the first time. The installer will ask ...Integration GP 8.0 with CRM 3.0
Hi. i'm newbie in GP but i have been know CRM 3.0, i want to do integration
between GP and CRM using Microsoft Dynamics CRM Connector for Microsoft
Dynamics GP. After all installation and configuration, the integration was
work. I add an account in CRM then the account which i was added is display
in GP (as customer). But why the order between GP and CRM can't integrate? I
was follow the instruction in the integration guide. The guide book says that
the tax details, tax schedules, shipping methods, payment terms, unit of
measure, unit of measure schedules, price groups, price le...Multiple e-mail addresses #3
When a Contact has multiple e-mail addresses, how do I set
one of them as a default? Now, emails are going to ALL of
their addresses. Thanks-Rose
...Finding unique numbers in a column
Is there any way to find the number of unique values among a set o
values in a column in an excel sheet. I would also like to know th
number of times each value appears in the column.
coolkid397's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2431
View this thread: http://www.excelforum.com/showthread.php?threadid=37924
There was also a similar thread under Excel Worksheet functions titled
Solution provided was to use: