Threads Replies Last Post 1369 Pages: <<  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  41  >>   Sorting I need to change an excel table to alphabetical order. I have 9 columns and 121 rows. I've tried with the sort button but nothing happens. Could somebody please give me some light in this? Thank you.... 3 22.09.2006 21:00:09 VBE - Possible to have one of five modules in a VB project to be "default"? 2003 Would like to have one of 5 modules in a VB Project to be the default Code window and in Explorer window. Is it possible? TIA EagleOne... 3 22.09.2006 20:58:35 Double quotes when concatenating with CHAR(10) Hi everybody, I have a case where I am using Excel to build a series of SQL queries. I am concatenating several columns and want to insert a line break in the middle so I can separate the comment lines from the query itself (each comment line is different). I can use CHAR(10) and everything looks great in Excel. However when I paste the resulting text into the SQL query analyzer (or any te... 1 22.09.2006 20:57:54 How can I use a long URL in a web query? When setting up a web query in Excel, the URL length is limited. However, the URL I want to use is quite long. I wonder if there is any way around this limitation.... 2 22.09.2006 20:42:01 make it blank! hi! cell A1 has no data and seems tobe blank. but in B1 when I enter =ISBLANK(A1) it gives me FALSE!! what's wrong with me and how can I make the cell actual blank??? help me pl! -via135 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200609/1 ... 4 22.09.2006 20:32:42 Linking a pdf file from Excel I need to link pdf files from Excel 2002. When I try to do this, it flashes the adobe window but then closes it right away. The pdf's were created from word documents and are for viewing only. I can't convert my excel file to pdf as I need users to be able to sort the data using filters I've put into the worksheet. Is there a way that dates can be automatically updated in a protected... 4 22.09.2006 19:48:16 COMBINATION FORMULA Is there a possible way LINK a (formula table array) to a cell, that when updated it shifts that formulated array to corresponding coordinates? WORKSHEET 1: columns A,B,C,D 9/8/2006 9/15/2006 Item Item Item Item Number Quantity Number Quantity 300482 162 300482 162 300485 2 300485 2 490806 73225 490806 72935 490808 10309 490808 10277 490810 109835 490810 109467 490815 32042 49... 6 22.09.2006 19:41:02 Date custom formats XL2003. I've checked Help and this forum, but I am still wondering what these notes like [$-F800] in front of date custom formats mean? I understand the other bits but these bits don’t seem to do anything. [$-809]dd mmmm yyyy and [$-F800]dddd, mmmm dd, yyyy... 3 22.09.2006 19:28:02 Edit Data Form? Is there a way to create a simple "Data Form" in Excel, and then use the VB Editor to edit it? I'd like to create a form very similar to the Data Form but need a few changes, but I don't want to create one from scratch.... 3 22.09.2006 19:25:02 select a range, copy it to a new sheet For the VBA gurus. I have a data table, 500,000 rows, in XL 2007. A colleague wants this data put into XL 2000. My take: write VBA code which splits the 500,000 rows into 10 tabs of 50,000 rows each. Then save the document in XL 2000 format and send to my colleague My problem: I don't know how to do that. Dave -- Brevity is the soul of wit.... 2 22.09.2006 19:06:26 Concatenate have 16 columns of income brackets in thousands (1.64=1642 etc) would like to list these incomes and their respective % in the same cell and do a wrap text that woud look like information is in two rows but just a little larger row. to look like Jones 1.64 .95 .93 1.07 10.3% 5.9% Smith 4.87 8.7% so forth when doing the math it yields about 12 decimels the text... 6 22.09.2006 19:06:01 Why does Excel 2000 crash when formatting a cell to Date? XP Home Office 2000 (2) user accounts, both administrative. One user account works fine. When logged in under the other account, Excel crashes when you try to format a cell to a date format. All other formats work (Text, Currency, Number...). When I right click in a cell and select format cell, once I select date, Excel shutsdown. If a cell is already in Date format and I righ... 3 22.09.2006 18:58:31 Drop Down List Ignore Blank ..Hi, I am trying to use a drop down list and have checked the "ignore blank" option but it does not ignore the blank cells. So I did the following to try and cricumvent it but need some help. Column M contains the list Column N I put an if statment to set the cell's to 1 if they are not blank Column O I used the index to list only the cell's that have something in it. Column P I d... 2 22.09.2006 18:53:02 How to save only row changes to a new sheet Hi, I'm working with a large worksheet(40 000+ rows). I would like to allow the user to make data changes to cells and then only save those changed rows to a new spreadsheet. I know Tracking will keep track of the changed cells, but I want to actually copy the entire row to a new sheet. -- Tks, J Sears... 2 22.09.2006 18:50:47 autosave macro excel I would like to create an active macro, which when you open the file is autosave only this file every 10 min but don't disturb any other program or files. Someone can help me. PS : I tried the autosave addin but it save all excel document. -- Cordialement, Philippe B.... 4 22.09.2006 18:41:49 Disable Close Button I wanted to disable the close button in the upper right hand corner of Excel so users would have to use a button on the spreadsheet (assigned to a macro) to close the worksheet. I used the following code: Private Sub WorkBook_BeforeClose (Cancel As Boolean) Cancel = True End Sub The code works great but now my macro button will not work and I can't close the worksheet at all. Can you... 6 22.09.2006 18:39:18 Sumif to external file I'm trying to create a sumif statement that pulls data from an external file. I am also trying to enter the path of the file using the full UNC path. If I create the formula without entering the UNC and just leave it as the default file name etc. it works fine. With the UNC path, I get the error. It also appears that the linked file needs to be open or it returns a value error. Is this t... 2 22.09.2006 18:37:20 List of values If you have a column of some random, and some repeating values, how can you have the sheet return to you which values are in the column. For example, if I have a column of 6 values, two values are 39, two values are 45, and two values are 34, how can I have excel tell me the values making up the column are 39, 45, and 34? ... 3 22.09.2006 18:28:53 how to find a closing parenthesis? Hi all, I wonder is there an easy way, like a keyboard shortcut, that I can find a closing/matching parenthesis in a long formula? Thank you. ... 2 22.09.2006 18:12:52 How do I get the Excel Find function to keep finding what I want? The "Find" function in Excel 2003 finds what I want sometimes, and on the next worksheet, it will say "Microsoft Office Excel cannot find the data you're searching for." I would like to look through a column of numbers, and they all start with 0.____, or a negative -0.____(fill in the blanks with any given number ie: 0.452213, or -0.59263). My goal is to identify where the negative num... 4 22.09.2006 18:09:02 Pivot Table - 50th Percentile instead of Average Can I calculate the median instead of the mean (average) in a pivot table?... 1 22.09.2006 18:08:02 Drop down box If I choose a word/command/field from the drop down box, how can I format the next cell over recognize this selection and display a number? Basically I created a drop down box, Van, Bus, etc... When I choose Van, I would like the next cell over to recognize this selection and show $80. Many thanks and appreciate the help! Rob... 2 22.09.2006 18:07:47 What does the symbol <> mean in an Excel formula? ... 2 22.09.2006 18:05:40 How do I view the header/footer when working on a worksheet I have created a Header or footer on a worksheet in Excel. How do I view that header or footer when I am working in that worksheet?... 3 22.09.2006 17:48:02 FILTER & IMPORT DATA I HAVE A BOOK NAMED "INICIADOS" WITH 6 PAGES INTO (JAM, LBL, ALS, ALV, GZG, INICIADOS) WELL, I NEED FILTER INICIADOS WITH SOMEFIELD AND EXPORT THE DATAS TO ANY PAGES. ADITIONALY, I WANNA DO IT INTO DE PAGES LIKE "MACRO", IN ORDER TO IT WAS DINAMIC, AUTOMATIC... 1 22.09.2006 17:45:01 1369 Pages: <<  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  41  >>