Need more columns #3

Thank you all for your replies and your suggestions

--
LoucaGree
-----------------------------------------------------------------------
LoucaGreen's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1210
View this thread: http://www.excelforum.com/showthread.php?threadid=26719

0
10/7/2004 8:56:33 PM
excel.misc 78881 articles. 5 followers. Follow

0 Replies
482 Views

Similar Articles

[PageSpeed] 40

Reply:

Similar Artilces:

Autofit Row Height #3
Hello, 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 fine. 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. -- Thanks, MarkN ...

RMS Troubleshooting and Basic Set up v4/3/2005
http://www.simonajewelry.com/rms.aspx I have decided to post the information on the net because ms newsgroup does not have a long message retention. Natt ...

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. Thanks, Amy 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
Hi There, Is it possible to change the columns on the forms ?? For example: Receiving po contains: Type, Item Lookup Code, Reorder Number, Description, OtyOrd, QtyRTD, QtyRcv, Cost, Price, NewPrice, Extended We need: 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. Thanks, Arthur ...

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 subject line to from http://www.codetwo.com/freeware/outlook-export/ Karl -- ____________________________________________________________ Karl Timmermans - The Claxton Group ContactGenie - QuickPort/DataPort/Exporter/Toolkit/Duplicate Contact Mgr "Contact import/export/data management tools for Outlook '2000/2010" http://www.contactgenie.com "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 the error: "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: http://www.microsoft.com/downloads/details.aspx?FamilyID=429163ec-dcdf-47dc-96da-1c12d67327d5&displaylang=en I installed it into "Program Files\exchsrv\bin" Never mind.... "Galvanon" <galvanon@online.nospam> wrote in message news:e7iaMaxYGHA.3704@TK2MSFTNGP03.phx.gbl... > 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 column.Thanx If I understand correctly, try putting a $ in front of the row reference. Also, sum is not necessary for what you are doing. =F$1-D3 as you copy that down it becomes =F$1-D4 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. ...

Check Box
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. Dave -- Dave123 ----------...

Wild curser #3
DNA Wrote: > 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. -- Jo3 ...

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? -- Roger On Sun, 3 Feb 2008 17:28:39 -0800, Roger <Roger@discussions.microsoft.com> wrote: >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. Hi Stu, 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
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 information on the way the new SFO is working ? Thank you, -- Marie-C I was meaning 'Is there a place i can find information on the way the new SFO is built' . Does it still use Cassini ? Thank you -- MC "MC" wrote: > > 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 blank)? On the first panel of the wizard click Delimited, then on the second panel click space as the delimiter. Hope this helps. Pete 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= ed > Width ...

How to get total "conditional sum of cells" in a column?
Hi all, 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, cdj Status in Column A and dollar amounts in Column B: =SUMPRODUCT((A2:A100="")*B2:B100) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk "sherifffruitfly" <sherifffruitfly@gmail.com> wrote in message news:bc08584b-1338-4b3f-8ab3-cc3e1602e581@n1g2000prb.go...

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 appreciated. Thanks Astro Repost this question in microsoft.public.publisher.webdesign newsgroup and add the URL to your problem website. -- ~~~~~~~~~~~~~~~~~~ Rob Giordano Microsoft MVP Expression "Astroda" <Astroda@discussions.microsoft.com> wrote in message news:2ADC0F87-CD62-421D-8088-61541AD6117B@microsoft.com... > I created a website and i am able to upload it and view it in firefox but > not > 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. bsetten@microsoft.com ...

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
Hello, 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 "cowboy" wrote: > help me I don't won't to load all of office Hi you can buy Excel as separate product. -- Regards Frank Kabel Frankfurt, Germany "cowboy" <cowboy@discussions.microsoft.com> schrieb im Newsbeitrag news:5B015950-A7AC-49D0-9386-7EFFF9B9404D@microsoft.com... > help me I don't won't to load all of office Hi, 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. Thank -- coolkid39 ----------------------------------------------------------------------- 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 "Delete duplicates". Solution provided was to use: Data>Filter&g...