Threads Replies Last Post 326 Pages: <<  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  >>   paste from clipboard issue Hello guys, I am encountering a really strange issue with standard paste in excel. Here is what I do and the strange behavior I observe: - I copy from excel a single line containing some blanks inside - I open notepad and paste the line into it - Then I copy the just pasted line from notepad and paste it into excel - Magic, the blanks disapeared. This is absolutely not what was expecte... 6 01.09.2006 17:04:19 formula question B55 calculates the difference of two values B56 calculates square root of B55 I want to set B56 to zero if B55 is negative. How do I do this? Thank you, Rob Excel 2003 (11.6355.6568) SP1 ... 5 01.09.2006 15:34:49 Over my head... Here is the situation. I have a workbook, where each worksheet has pricing data for each state. On the "state" pages the format is the same. 1-3.9 inches 4-7.9 inches 8-11.9 inches <2499 sq feet $$$$ $$$$ $$$$ 2500 - 19,999 $$$$ $$$$ $$$$ 20,000-23,999 $$$$ $$... 2 01.09.2006 15:24:31 Hmmm, Where do I begin??? Ok well my goal is to start out by using the DateAdd function to add the number of months in column F to Colum H and comare it to Column I. If that date is < the Date in Column I, then copy the data K of the corresponding Row and paste Starting in colum M of the same row. If that date is > than the date in Column I, a zero is placed in that cell. Repeat this step all the way to Colum AC... 5 01.09.2006 14:58:01 Conditional Formatting Issue After using conditional formatting on a column, then changing to view functions in cells (CTRL + ~), and then going back to view values, cells with a custom date format (3rd from last in the list), show up only in the function-view format of miliseconds. This happens no matter what, and it won't go back so long as conditional formatting remains in effect. So, this is a bug in Excel w... 3 01.09.2006 08:53:01 Can't find my work Hi All, I have a big problem and would really appreciate direction as to possibly retrieving it. I sent myself a file from work home in Excel. When I opened from my Outlook Express program I worked on it and completed my project after a few hours. I then went to SAVE and it saved it. It didn't ask to change the name or anything, it just disappeared like usual. I went back into my e-m... 3 01.09.2006 02:26:00 pivot table again i have a range of fields in a pivot table some are qty others are value how can i split the table into two seperate sections one showing qty and the other showing values (if that makes sense)... 3 01.09.2006 02:10:02 2 sheet replaceing; row on 1st sheet with row from 2nd sheet I have 2 sheet in the same workbook: (APCURRENT,CORPCONTACT) Both sheets have a column "vendor name". I want to look at APCURRENT "vendor name" and if the corresponding CORPCONTACT "vendor name" is the same take the informating in that row of CORPCONTACT(address1, address 2, city, st, zip code) and replace then APCURRENT(address1, address2, city, st, zip code) with it. But only do this i... 2 01.09.2006 01:52:28 Replace old data I'm working on a simple program that enabled the user to Search and Edit the data. The user has 2 options whether to save the data as a new record or to replace the existing data. I managed to get the job done for the user to SAVE AS NEW RECORD by using this coding : ActiveCell.Value = txtSpecificationNo.Value ActiveCell.Offset(0, 1) = txtIssueNo.Value ActiveCell.Offset(0, 2) = lblPly1.... 14 01.09.2006 01:38:34 Graphing by days of the week Hi all, I would like to create an individual graph for each individual day of the week for a complete month. What I have is two columns, column A consists of the date (i.e. 1-May) and column B consists of a number. I would like to graph every Monday of a month on a separate graph to a Tuesday and graph Tuesday on a separate graph than a Wednesday. How would I go about getting Excel ... 2 01.09.2006 01:03:02 Condition Formatting based on due date I have a spreadsheet where I am trying to color a row based on how close I am to a due date. The basic logic is: I need to color a row yellow if today's date is less than 45 days from the due date in column B or color the same row red if today's date is less than 14 days from the due date in column B. I am stumped, any suggestions would be greatly appreciated. Thanks, jaggy ... 4 01.09.2006 00:37:01 Is there any way to atttach a callout to a point in a chart series? I use the drawing toolbar, and put a callout into a chart, with the point of the callout touching a pointon the chart. But, if the chart re-scales, then the callout no longer points to the same series point that it used to. Is there a way to anchor that callout to a particular point in a chart series, so that the chart can rescale and the callout still refers to the same point? Thank ... 1 01.09.2006 00:02:10 IF cell is currency, not text, and over this much? I am trying to sort out a list using a helper column. The column I am trying to sort out has monetary amounts with cells formatted as currency. At odd places in the column, though, are headers in cells formatted as text. I put an IF formula in my helper column to give me "Yes" if the money amount was over a certain value. Unfortunately, it's also giving me a "Yes" at every text cell. ... 6 31.08.2006 22:54:26 Value Labels on Pivot Table Chart? Hi. I have a pivot table chart. I want to have its data labels show the value of each bar, e.g., if the bar is up at 26, I'd like the number "26" to show up on the bar. I can do this once by right clicking the chart's series, selecting Format Data Series, then checking Value on the Data Labels tab. However, the next time I refresh the pivot table, the labels go away. Is there a way I can... 2 31.08.2006 22:04:33 Moving Average - How can I make the function? Hi everybody! I need to construct a function to calculate (not simply calculate it!!) the moving average for the following data Day Data Moving average (5 days) 01-gen-06 5 02-gen-06 6 03-gen-06 7 04-gen-06 5 05-gen-06 6 06-gen-06 7 07-gen-06 6 08-gen-06 5 09-gen-06 4 10-gen-06 5 11-gen-06 6 12-gen-06 7 13-gen-06 6 14-gen-06 5 15-gen-06 5 ........ Any tips will be very he... 4 31.08.2006 20:25:05 Strange Date Format Bug Hi all, I don't know which subtopic this belongs to. Each time I work with dates in Excel 2003 on my machine, the date, regardless of the format, becomes a number. For e.g. When I type the date 1/1/2006, the Formula Bar shows me, 1/1/2006, but the column actually shows "38718". A different number for each date. I've tried all Date formats in regional settings, nothing works. Can ... 4 31.08.2006 20:21:33 Column Labels New to excel. How do I "name" or "label" columns, instead of A, B, C...? A quick step-by-step is much appreciated. Thanks in advance, Fran ... 4 31.08.2006 18:18:59 Hide empty rows in Excel worksheets I'm working on a program that enabled the user to insert 10 information and print them. I developed the forms using VBE. I have specified all the information into their own cells in Excel worksheets. When the user insert Info1, the data will directly go to Row 2, Column 1 in Excel worksheet. When the user insert Info2, the data will directly go to Row3, Column 1. Each info has their own fo... 6 31.08.2006 18:18:57 Function or Formula to Add lowest X number of values in a range I'm looking for a way to total (SUM) the lowest X number of values in a given range of values. For example, I have a row of 15 values. I'd like to do some analysis and determine what the total and average is for the lowest 5 values, lowest 10 values, or whatever number of values I desire. Is there a function or formula that will help me accomplish this?... 6 31.08.2006 15:40:02 Simple Chart Question? You folks seem to be able to do almost anything with excel, so this is probably childsplay to you. But not to me. I want to create monthly weather charts with Rain as bars, but Humidity, Min Temp and Max Temp as lines. How can I do this on the same chart? Thanks. ... 2 31.08.2006 12:09:20 Combo Box in control Toolbox i have multiple combo boxes in one sheet. where can i set the tab order so i can navigate using the tab key? need your help asap... 2 31.08.2006 11:23:22 Find Missing Records I searched enough on this topic but couldn't find anything that i could put to use. Hence this query to you all. I have two excel sheets. Both Sheets have two columns (Name, Email Address) Now i need to find out if there is any record(row) missing in the first sheet by checking the second sheet, such that i can create a third sheet with all the missing records(rows). Any help or macros ... 4 31.08.2006 10:46:48 Filter data by multiple drop down lists I have a worksheet with the following columns: Item name, Item type, Item size + some other columns On the second worksheet I have the same columns in diferent order (Item type, Item size, Item name) but at every column I need drop down lists. I use data validation to produce the list for the items in the 'Item type' & 'Item size' columns. For the 'Item name' column I need a drop down, whi... 3 31.08.2006 09:58:58 Double clicking xls doesn't work Hello, If anybody can tell me what the problem is I'd be much obliged. My PC has recently stopped opening xls files when double clicked. I tried deleting personal.xls and then just got an empty window. I could then drag the xls into the window and it would open fine. I then re-created a new personal.xls which I hid (attrib wise) and then double clicking an xls opened Excel with an empt... 5 31.08.2006 08:58:26 Creating applications Hi I use Excel to gather information from employees in an office. This is done with a userform that writes into an Access database. I want to create a second instance of Excel to gather another set of data too but Excel will obly open one instance of itself. Can anyone tell me what code I need to add in order to make my userforms into applications in their own right? Thanks Stuar... 1 31.08.2006 07:13:57 326 Pages: <<  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  >>