How do I add a second line or paragraph within a cell?

Here is exactly what I am trying to do through VB in Excel: Weekly data pull fills colums A:G. Row count is always different. I am modifying the data pull through VB, and I have a VLOOKUP formula in cell H2. What I want VB to do is copy that formula down column H to the last row (with data) each week. I guess I want it to be dynamic so that as rows decrease/increase the formula is only copied down to the final row/record. I know someone out of this smart group will know how to do this! Thanks in advance! Tony (pseudo code) in a macro .... dim lngLastrow as long dim rngTarget...

i need to compare age and gender on a line graph but i can not get gender to be different from just a line how do i change that? Your question is not too clear. It would be nice to see part of your data. Are you saying that Excel plots two lines rather than one? If so, delete the text at the top of the first column you are using for data. -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "lost&needhelp" <lost&needhelp@discussions.microsoft.com> wrote in message news:88472E93-9D32-48B6-8B2C-FAF17EED4ACB@microsoft.com......

Using Excel 2002. I have a workbook with 12 worksheets (one for every month of the year), wherein a lot of the information is looked-up (using VLOOKUP) in simples arrays. I saw no point in implementing the arrays as a 13th worksheet, because I will have a yearly version of my monthly worksheets in one workbook (so one for 2003, 2004, etc). If I change the array(s), I want them to be reflected in all referencing cells. Problem: If my workbook containing my arrays (called "Global") is loaded, I have no problem and the references to it read as: (blabla) 'Global.xls'!Roster ...

Bernie Deitrick Wrote: > Xprezons, > > Are you really recording every 1/10 millionth of a second? And, yes > Excel > limits you to three decimal places on the seconds > > Thanks a ton for your help, Bernie. I guess this is what I have to do. And yes, the system does log time to the accuracy of 6 decimal digits. Thanks and Regards, Xprezons -- Xprezon ----------------------------------------------------------------------- Xprezons's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1505 View this thread: http://www.excelforum.com/showthread....

Can I increase the # of characters that are visible in a cell? 67 Excel Help on "limits" or "specifications" reveals that Excel will allow 32,767 characters to be entered in a cell. However, it goes on to state that "only 1024 characters will be visible or can be printed" To work around this limitation, stick a few ALT + ENTERs in at appropriate spots. The ALT + ENTER forces a line-feed and expands the 1024 limit. How far is not really known. Just experiment. .........From Dave Peterson.......... I put this formula in A1: ="xxx"& REPT(REPT(&...

Hello, Will blame it on my age. Using Excel 2007 (or, at least trying to) and XP. When I have a chart page opened up, how do I get it to show the bar on the bottom (that the real old versions had) that allows one to click on one of its icons shown to "draw" lines, arrowed lines, boxes, add text with a box, etc on the chart itself ? Thanks, Bob Hi, With the chart selected you can use the Insert tab > Illustrations > Shapes. To add shapes to the chart. Textbox is in the Text group of the Insert tab. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypo...

Let's say I have a spreadsheet with two worksheets = SheetA and SheetB. SheetA might reference a cell in SheetB with a formula like =SheetB!A1 But when I move this to the network the reference changes to include the network drive and file name like: ='Z:\FOLDER\[FILE]SheetB!A1 the file may move from my laptop to the network several times and this becomes completely confusion as the reference looks, not within the same spreadsheet which is what I want it to to, but for another file out on the network. How do I explicitly reference a cell within a difference worksheet but alwa...

"" generates a zero-length string, not a truly empty cell. This is causing problems elsewhere. I'd like to find an output for an IF statement that will give me a truly empty cell. The current formula is: =IF(COUNT(C24:C29)>0,SUM(C24:C29),"") Any ideas? If it involves a macro (as I think it might, having read other posts), please explain how to implement it. Thanks! <This is causing problems elsewhere> It shouldn't. Don't use ISBLANK(A1), use A1="" -- Kind regards, Niek Otten Microsoft MVP - Excel "paulkaye" <paulmjkaye@gm...

in cell A1 i have the numbers 123456789. i want cell B1 to have numbers 1234567 and cell C1 to have just 89. what is the formula? i have tried text to columns If this is for extracting the first 7 characters use LEFT() =LEFT(A1,7) =RIGHT(A1,2) -- Jacob (MVP - Excel) "fazz" wrote: > in cell A1 i have the numbers 123456789. i want cell B1 to have numbers > 1234567 and cell C1 to have just 89. what is the formula? i have tried text > to columns Hello Jacob - i did not explain this very well.The digits in cell A1 is variable length. In cell C1 i n...

I want to multiply text boxs ie 4(1box)x $1.00(2box)=Total $4.00 (3box). I also want sum total (5 text boxes) for grand total. Is this feasible on form?? Thanks On Mon, 14 Jan 2008 18:58:01 -0800, He cries for help <Hecriesforhelp@discussions.microsoft.com> wrote: Have you tried an expression like: =[1box] * [2box] (assuming your control names are 1box and 2box. This expression would go in 3box' Control Source property. -Tom. >I want to multiply text boxs ie 4(1box)x $1.00(2box)=Total $4.00 (3box). >I also want sum total (5 text boxes) for grand total. > >Is this ...

I have the following data: Date Value 1/07 700 3/07 550 9/07 600 10/07 550 7/08 500 9/08 700 2/09 750 8/09 600 I would like to create a simple line chart connecting the Value points. Note that the points correspond to random dates (not evenly spaced). How can I create a line chart that has time on the x-axis, (say shown in months) with a line connecting the Value points, which are shown at various locations in time. Soun...

Does anyone know the source of this error message and how to fix it? well, you have to provide more info than that before people here could provide possible solutions. Info like, what GP application? what window? what module? what are trying to do on that window? posting? printing? saving? do you have customizations? ---Darryl Bajaro "Phil" wrote: > Does anyone know the source of this error message and how to fix it? ...

I have 3 columns of single figures. At present i'm using the sumproduc fuction to multiply and total the figures in column A that fall betwee 4 and 9 with the adjacent figure in column B... =SUMPRODUCT(--($A1:$A600>=4),--($A1:$A600<=9),($B1:$B600),($A1:$A600) I'd like to add column C to the formula, so that if it contained value of -1, 1 or 2, the sum of the adjacent figures in columns A and appears as a negative number. For example A3= 7, B3= 2, C3= 1 Outcome= -14 A4= 9, B4= 1, C4= 5 Outcome= 9 A5= 3, B5= 2, C5= 2 No sum because figure in column A ...

I have imported data into Excel. The left-hand column has merged cells containing a reference number. The remaining columns contain varying records associated with the reference number, a one to many ratio. I need to display the worksheet so that the appropriate reference number is displayed in the left-hand column for each of the records in the worksheet. There are hundreds of reference numbers. Is there an automated way to do this besides unmerging each section and copying the reference number into the now unmerged cells? Thank you. ...

How can a frequency of a specific character be counted with in a cell. Ex -" #4 Bluebirds, #6 Aquatic" is in cell B2 - how do I count the number of "#" that appear in cell B2? =LEN(B2)-LEN(SUBSTITUTE(B2,"#","")) HTH Jason Atlanta, GA >-----Original Message----- >How can a frequency of a specific character be counted with in a cell. Ex -" >#4 Bluebirds, #6 Aquatic" is in cell B2 - how do I count the number of "#" >that appear in cell B2? >. > ...

When I type a paragraph within an email, it looks great, even after I've added words to the sentence, or changed the sentence structure. Then I send the email, and sometimes send it to myself, but the sentences and paragraph are chopped up, and the idea doesn't "flow" like I wanted it to. Any suggestions on how I can keep the sentences together so they make more sense? I have looked at every option in "Tools", but haven't found a solution. Thanks. Are you using HTML or plain text? HTML will generally keep the same formatting while plain text ...

How many decimal places can be displayed in a cell? I'm running a brute force VBA procedure of finding fractions that will approximate pi to as many decimal places as Excel will display, but I don't know how many decimal places Excel will display accurately. Anybody know? I guess this is also a matter of how many decimal places VBA will calculate accurately as well. Sub PiFractions() Dim dividend As Integer, divisor As Integer, quotient As Double Dim rowpointer As Byte rowpointer = 1 For dividend = 22 To 10000 For divisor = 7 To dividend \ 3 quotient = dividend / diviso...

When I paste information from a different source into Excel and scroll down the text in certain columns is disappearing. When I scroll back up some of it reappears and some disappears again. The template was originally created in Excel 2003 (I think) and we've just upgraded to 2007 so I'm assuming it has something to do with that as I've never come across this problem before. Is there a setting I need to change or do we need to start the template all over again. It's quite a complex template so that would have to be my last option. Any help appreciated. Many thanks...

I'm using quick test professional which uses Excel DataTables, but with half the functionality. I'm basically exporting a the datatable from Mercury quick test to excel. With in my quick test script I'm performing a compare between two excel documents, and I wish to represent the difference with a Red background. Basically, Is they anyway in which I could add so code within my cell that would automatically change the back ground color. Example: My result is 4.13. I would then change this variable within quicktest to something like vbRed.4.13. Then when it gets sen...

In Excel, I have a column with various numbers in each row. I want to multiple each number by 1.02. Short of doing this with extra columns, is there a way to use find/replace and add *1.02 to whatever is already existing in each cell? Paige, Enter 1.02 in some blank cell and copy that cell. Then select the number you want to multiply by 1.02. Go to the Edit menu, choose Paste Special, and choose the Multiply operation. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com chip@cpearson.com "paige" <anonymous@discussio...

I'm trying to figure out why the date fields (strtdate, enddate, fulfildat) are not being populated in the Service Call Line Detail table (SVC00203). Can anyone give me insight on these fields on why they are all 1/1/1900 dates? We are trying to generate a report based on the dates of the line items on a Service Call Work Order. Thanks ...

Is there a way to get the SUM function to increase the range if a row is added right above the previous SUM range. FOr example to go from SUM(C3, C22) to SUM (C3, C23) when I insert a row directly above row 24 - wher the SUM function resides. You could use a formula like this in C23: =SUM(C2:OFFSET(C23,-1,0)) FredZack wrote: > > Is there a way to get the SUM function to increase the range if a row is > added right above the previous SUM range. FOr example to go from SUM(C3, C22) > to SUM (C3, C23) when I insert a row directly above row 24 - wher the SUM >...

I'm setting up a spreadsheet that will be added to daily. Each day has two columns... column A is a drop down list with limited choices (lets say 2). Column B will be a number. Day two will be column C and D... C will be the drop down list and D will be a number. Day three will be column E and F and so on. Now the tricky part is for me to SUM the numbers from each day for the matching drop down choice. Example: I want to SUM B1,D1,F1... but only if A1,C1,E1... equals the criteria. Trying to be as clear as possible... what I should have in the end is 2 (the drop down choices) different ce...

Hello. I'm using Outlook 2000 on Windows XP. I moved my .pst file from another Outlook 2000 on Win98. Plain text e-mails show no line breaks. I remember on the previous Outlook I modified a registry key so they would show correctly. Do you know how to fix this? Example: MEDIA RELATIONS OFFICE JET PROPULSION LABORATORY CALIFORNIA INSTITUTE OF TECHNOLOGY NATIONAL AERONAUTICS AND SPACE ADMINISTRATION PASADENA, CALIFORNIA 91109. TELEPHONE (818) 354-5011 http://jpl.convio.net/site/R?i=I- hdBIN6ChJO-3BCLCXxIg.. http://jpl.convio.net/site/R? i=QKroV09E4GFO-3BCLCXxIg.. Guy Webster (818) ...

I have used the formula below to work out the amount of hours from a start time to a finish time for each day. Start - Finish - Total Hours =TEXT(D3-C3,"h:mm:ss") It works fine and give me the result but if I try to add the weeks hours I get is 00:00:00. Each sell has a formula which shows the correct times but the value shown can not be used. I hope this makes sense as it has got me beaten. Any help would be appreciated. Tia You can't add text. Replace this: =TEXT(D3-C3,"h:mm:ss") with: =D3-C3 and format Custom as "h:mm:ss" Format the to...