Threads Replies Last Post 125 Pages: <<  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  36  37  38  39  >>   How do I create a formula that lists only the last entry in a colu -- Walter... 2 27.07.2006 20:26:28 Copying information from one cell to another without modifying it. Please tell me how to stop Excel from Adding 1 to my data when I copy it from the first cell in a column to the rest of the cells in the same column. For example, when I key WC123 and try to drag & copy this value to the cells below, the result is WC124, WC125, etc.. Thanks. Ken K. - 2191 -- akkrug... 5 27.07.2006 18:48:01 Need to recover data Forgot to save a new file Shut down computer Opened Excel and hoped to see a file (a la the function in WORD) that was unnamed that I could open with the data and then save as. Any ideas - thoughts on places i could look for a tmp. file....would it be named book1.xls?... 7 27.07.2006 18:23:36 How do I sort a proctected worksheet ... 4 27.07.2006 17:13:42 Numbers appear as ##### instead of the actual number, how to fix? Some of my stydents have entered numbers into cells or done a summation of a series of cells and they get ###### signs in place of the actual number...when mousing over the cell with the ###### a fly out appears with the actual number. How do we make the ###### signs appear as the actual number?... 2 27.07.2006 16:50:24 Can my excel doc be made into a calendar? I have an excel document that is fairly large in my opinion, is there a way to make the information in the excel doc populate a blank calendar?? Will need to take a combination of v and h look-up Is there possibly an applescript out there that can be adjusted?? Man i'm at a loss..... Any help is much appreciated thanks -- proflex -------------------------------------------------------... 2 27.07.2006 16:30:46 Importing data I'm building a datbase using Filemaker Pro for Macs. I can import data from an Excel spreadsheet into the datbase pretty seamlessly. I would like to send out an excel template and have people fill in the needed data (names, phone numbers etc.) I would like to merge all this info into one excel spreadsheet and then import it into my database. My question is what is the easiest way to merge all... 3 27.07.2006 16:19:58 How change maximal value in excel for filter (1000) ? ... 2 27.07.2006 15:03:56 sheet names What returns the name of a worksheet in a workbook if you are in the workbook. for instance: findit(1) gives the name of sheet 1. Thanks John... 7 27.07.2006 09:00:35 Problem vertically aligning multiple rows with tickboxes added using VB. Hi guys. I searched for days to find the solution to adding a column of checkboxes down a table with 500 rows in it - a checkbox at the end of each row. The good news is that I eentually found that someone had posted a little VB code that did it nicely. I used some additional conditional formatting and now each individual row changes colour when the checkbox is ticked! It's a thing... 5 27.07.2006 08:30:21 Multiple Row to columns I know this seems so simple...maybe I'm now frustrated due to looking at the computer screen all day. I am formulating an excel sheet as my data base to create mail merge. The website that I have gotten the information from pastes to the excel sheet as such: File Numer 1233112 John Doe 12563 E Washington St ... 2 26.07.2006 23:25:56 Exporting a toolbar Excel 2003 I've created a personal toolbar, which includes specific canned command buttons, as well as about six "designer" buttons which I created to activate several formatting macros. I'd like to recreate this toolbars, along with the embedded macros, to a different computer. What is (are) the file(s) I should copy over, and in what folder(s) are they? -- PT ... 2 26.07.2006 22:09:30 how do I make more then one line of pasted text not move to one cell? Hello. How do I make one block of text I pasted not go in to 2 cells and if I want to merge those 2 cells together in to one cell let's say merge 5d in to 4d, is that possible? Thanks. Oh, I'm visually impaired so is this possible with the keyboard? Thanks. ... 10 26.07.2006 19:22:53 Removing dead Link I've got my own *simple* problem Somehow my workbook thinks there is a link to temporary sheet I was usin= g. I can't work out a way to get rid of *the link* Edit Links - tells me the file (which has gone), but won't let me delete= = the link nor tell me where it *thinks* it is. -- = Steve (3)... 4 26.07.2006 17:55:06 How do I use formulas and what is the secret to making them I am an extern in a not-for-profit organization. I need help with formulas and do not know how or what to do? Please help me. ... 7 26.07.2006 16:51:03 Decimal point I have a cell that reads 21.59 [for example] but when I click on it, the data entry field on the tool bar extends that number to 6 decimal places. How do I get Excel to read the number only as 21.59? Assuming that the two decimal place version is display only. I ask this because this data is going to populate a SQL database over which I have no control and I don't want my price data d... 4 26.07.2006 16:02:06 how to view the document recovery task pane i an trying to recover a lost file that i didn't save, and there is a feature called the document recover task pane, however i can't seem to activate it for some reason. please assist... 3 26.07.2006 15:45:42 Division Basic one this...but Excel makes it reasonably clear how to add and multiply, but not how to divide. I want the values in column S to be those in column P divided by 0.75. How do I do this please? Thanks David ... 6 26.07.2006 10:06:03 Auto open a .xlt template I have my own Menu application that I can easily open files or create new files based on my templates. (I use CDMenuPro to make this). It's easy to make a button that open MSWord, then run a macro at the same time to open a template that I created. But I don't know how to do the same thing in Excel ! I wonder how to write a macro that automatic create a file from a template (xlt ?) when ... 3 26.07.2006 05:54:02 I want to match and insert info on 2 different sheets Really embarassing newbie question: I have two sheets of data, both sheet have a common identifier "school code". One sheet has some results (numbers) for each school code that I'd like to match to the school codes on the other sheet. I can't seem to figure it out using "MATCH" or "VLOOKUP", what do I need to do? Hope this is enough info. Thanks. -- shanmac ----------------------------... 2 26.07.2006 02:02:01 using arrow keys moves page not the cell ... 2 25.07.2006 23:15:45 envelope printing how do I print envelopes with customer addresses from excel?... 3 25.07.2006 23:05:33 how do you divide the average of a number into 3 different cells. i am trying to do a stock and order for work. i have to divide the amount of sales by the quantity of units in a case to come up with ( cases required to order). i have done that but i need to average that total into to three cells. e.g 12 = 4 4 4, 11 = 4 4 3... 3 25.07.2006 21:08:35 Sorting malfunctioning A column contains a list of dates in the form: day/month/year. If the list contains all single-cell days, then sorting in descending order works fine. However, if the list contains a date such as 24/4/2005 as opposed to 2/4/2005, the date 24/4/2005 always appears first on the list, _above_ an earlier date such as 1/1/2006! For example, here is a "sorted" list: 24/2/2005 6/3/2006 3/4/200... 11 25.07.2006 20:58:28 How can I data sort to more than 3 levels Is there a technique or add-in utility that will let me do a data sort in Excel to 4 or more levels at once. Currently you can only do 3 levels, and then you have to separate the data to do more. Thanks for any help -- Pam LaDue ------------------------------------------------------------------------ Pam LaDue's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36773 View t... 2 25.07.2006 20:25:22 125 Pages: <<  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  36  37  38  39  >>