Threads Replies Last Post 326 Pages: <<  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  36  37  38  39  40  >>   possible to have a view of column with field names? XL 2002 Sp3 U know how u can go Insert|Name|Paste|Paste List and paste the list of names u have defined with their values, etc. can u do the same for columns fields so that u have the column denomination (A, B or C, etc.) and column header (field u define in 1st cell of each column on 1st row in table) appear in a vertical list of 2 columns, say: After operation u wd have: A1=A ... 4 24.08.2006 19:02:35 ActiveSheet.Paste error I have a consolidation routine that will, if the user chooses, consolidate the output of all the sheets in our generated report onto one sheet by appending them one after the other with the ActiveSheet.Paste method. It has been working fine with no problems until one customer generated a LOT of reports which means a lot of worksheets in the book and a lot of calls to cut and paste them all ont... 3 24.08.2006 18:57:21 insert row below where the cell data is "Wednesday" Can someone help me? I checked Excel Help and didn't find insert row based on data....thanks!! ....Lisa Excel 2003 ... 6 24.08.2006 18:32:25 file with subtotals hi Everyone, My friend has an excel file which uses a lot of subtotal formulas for a specific column in his file. His issue is that this file takes a few minutes to open in Excel 2002. But in Excel 2003 it takes hours together but doesnt open. Any ideas ? Please Guide.... Thanks Sampy ... 5 24.08.2006 18:28:44 Like MODE but not quite. Hi, I'm sorry if this question seems a little newbie-ish, only I haven't used MS excel since GCSE, and that was over 3 years ago. Could someone tell me how to take the values in a list, and then display the most common one -if the values aren't numbers-, only I've tried looking for it and endlessly had to sift through instructions on how to use MODE! -- Markusdragon ---------------------------... 9 24.08.2006 18:07:20 Pivot table from CSV data, problem getting a percentage from the total Hi, (P.S. This is more readable with Courier font.) I'm using data from a CSV file to make a Pivot Table. My data is sum of widgets per year. In the Pivot Table, I have the years across the top as column headers so it looks like this : 2000 2001 2002 2003 2004 2005 2006 A 437 179 431 203 14 321 270 B 267 382 429 432 205 257 176 ----------------------------------------------------... 3 24.08.2006 15:36:59 .NET 2.0 COM Excel add-in stops responding when SqlConnection object is created Dear All I have encountered a problem when creating a System.Data.SqlClient.SqlConnection in my Excel add-in. I am using: - Visual Studio 2005 - Excel 2003 SP2 I created the add-in with the VS2005 Shared Add-in Wizard. I then included the required Office and Microsoft.Office.Interop.Excel assembly references. In the OnConnection method I add two buttons to the Excel menu. In the ... 1 24.08.2006 15:35:33 Merge- top to bottom not left to right I ahve a list of over 300 names that i am tryiing merge onto a ticket format that carries 8 tickets to a page. Problem is when I try and merge I get all the same name on the 8 tickets each page 300 times. I want to have each name only once --or 8 names per page. If I merge and change the format by taking and changing each of the 8 tickets ( name1, name2, name3 etc.) That turns into me ahveing... 9 24.08.2006 13:23:00 Default formatting How can I change the default setting for cell formatting - even on existing spreadsheets. I wanted all numbers to be inputed as currency with 0 decimal places, but it always defaults to numbers with 2 decimal places. I know I can change the formatting after the fact, but I wanted this to be the default setting. Thanks for any help.... 5 24.08.2006 13:05:02 Excel changeing name and type When I open an excel file I some times get's the "unable to read file" message, what than happends is that excel changes may filename from filname.xls to something like FB4ED000(I can right click and open this file in excel an all its fine) What can be doing this and how can I avoid this from happening so often. I also have trouble with that I get "unable to read file" when I try to save a... 5 24.08.2006 12:50:21 Pivot Tables Case Sensitive Grouping Hi I have a pivot table which is group items even if the text in the field is not the same case - ie I have abc123 and ABC123 - The Pivot Table is grouping it one the line rather than displaying two lines. Anyone come across this before ??? I've looked for some options around this but can't see to disable the case insensitive grouping. Thanks ... 3 24.08.2006 12:39:53 How to get DATE-TIME column into chart as X-axis (domain) values How do I get DATE-TIME column into chart as X-axis (domain) values? This should be easy so obviously I am doing something wrong. The date-time is in on column with 4 other columns already set as data values in the Y-dimension. The chart is giving me one "increment" of X-value for each entry but the data was taken at multiple/random times through each day so this is both inaccurate and ... 2 24.08.2006 10:40:16 Problems with Conditional Formatting Hello All, This may have been covered by previous topics, but I could not see it. I want to apply 3 different conditional formats to a column where the cells have a formula applied as follows: =IF(Q11>=5,"1",IF(Q11>=4,"2", IF(Q11>=3,"3",IF(Q11>=2,"4",IF(Q11<2,"5"))))), Q being a column where a SUM is calculated. The conditions I want are RED for value >=5, ("1"); O... 6 24.08.2006 10:19:04 Excel macro "loop" To avoid several hand mader starts (400 x) of a macro I want to edit the VSB macro in a loop. I am not familiar with VSB but do have some experiance with other database languages. What is the exact way / commands to write down (edit) the macro? Someting like this. --------------------------------------------------------------- Start loop if n < 401 n = n+1 ... 4 24.08.2006 08:21:35 sumif? Hi... I have a pretty simple spreadsheet with a record of ticket sales for an event. One column has the date the ticket(s) were sold, and I would like to have another column that will sum the totals sold for each month. Is there a way to use sumif to accomplish this, or is there a better way? Thanks in advance... Jim -- "The trouble with the world is that the stupid are cocksur... 3 24.08.2006 04:25:03 Excel 2003 - is there way to tab from field to field on simple fo I have a user who is trying to make a very simple form on an excel spreadsheet --mostly text boxes, a check box or two. She finds that she can't tab from field to field, though -- the cursor goes from cell to cell. I find I can only tab from field to field in design mode -- are we missing something easy? -- Lisa M... 3 24.08.2006 01:10:02 Automatically open Excel file set to "Enable Macros" Is there any way in Excel 2003 to set a spreadsheet to automatically open enabling macros, so the user doesn't get that annoying dialog box? -- Lisa M... 4 24.08.2006 01:07:02 Copying from HTML textarea to Excel I have a weird situation where a user is copying data on a webpage from a html textarea. When he copies it into Excel, there are quotation marks around the copied text which wasn't there before. Has anyone encountered this before? This is not occurring when he copies from any other text input field on the webpage. thanks for any help in advance, Geoff ... 1 24.08.2006 00:11:09 Formula Guidance Requested Folks, I'm baffled as to which formulas to use to perform these calculations: I have a sheet with three columns: A = Customer Number B = Number of Users C = Total Monthly Fee There are 700+ rows of data. The values in A will range from 1-500. I've created a table on another sheet that segments the above data into groups that I assign. The table looks like this: B = Group (Alph... 2 23.08.2006 22:38:51 Thank you Bob Philips Bob, I thought this was as good a forum as ever to thank you for the SUMPRODUCT article in xldynamic. It has to be one of the single most informative articles I've read on Excel, and has really opened my eyes to the possibilities of SUMPRODUCT. I printed it & pored over it for the last few bus journeys to work. Thanks again, Jason... 7 23.08.2006 22:29:20 Formatting text in a check box I made a check box on a form in Excel and typed the word "Rush" in it....then tried to bold "Rush" and enlarge the font. I couldn't find where to format the text in the "Format Control" menu, or any place else....my formatting toolbar buttons were grayed out too. Has someone found a way to do this gracefully? (I ended up inserting a small text box in the Check box text area to get the fo... 4 23.08.2006 22:09:40 macro button This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C6C6C5.BFB1B7F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a "button" that I created and assigned a macro to. I no longer = needed the macro or the button, so I deleted the macro but can not find = ANY way to get rid of the button. Any help? --=20 CARMEN... 9 23.08.2006 22:01:04 Open and Jum to specific cell I am running Excel 2003 SP2 and have a wondering. The spreadsheet lists by row functions along with tools to support each function. For example, one row has a tool to support handling risks. The spreadsheet is stored on a server and we have links to it to open it. I'd like to be able to open the spreadsheet and then jump to a specific row rather than to just open it and have the user have ... 7 23.08.2006 20:50:32 between numbers Hi All My work sheet 1 contains below columns ( ticket log ) Sale person name begin no end number Person 1 1 100 Person 2 101 200 Person 3 601 700 Sheet 2 contains sales Ticket no sales person activity 177 ? What kind of formula can I put on... 3 23.08.2006 20:20:22 Excel adds "Copy of" to file name I frequently copy protect my Excel files to prevent overwriting a working file I am using as a template. For example I may open the read only "Filename001.xls" make a few changes and select save as so I can rename it "Filename002.xls." The problem is with MS Office 2003 SP2 every time I hit save or save as on a read only file it adds the text "Copy of" to the beginning of the file name (i.e... 3 23.08.2006 19:08:56 326 Pages: <<  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  36  37  38  39  40  >>