Threads Replies Last Post 1369 Pages: 1  2  3  4  5  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  >>   Searching Multiple Workbooks Hi all I require an easy and free way to search through multiple workbooks. However the only ways i have located around this is via complex macros or buying an application (which I do not want to do). Say i have a new workbook and in cell A1 i want to do a search for the info i type in there and i click an icon to run the search macro. I want the macro to search 3 workbooks, named Alpha... 2 28.09.2006 16:52:14 Changing 1234.00- to -1234.00 automatically Everyday I have to copy and paste data from a program to an excel spreadsheet. Positive numbers come in fine, negative numbers don't. They align to the left of the cell with the negative sign to the right of the numbers. Currently I: F2, backspace, home, put in the - sign and enter to the next cell where I repeat this approximately 80 times. I have tried setting up a macro, a scener... 8 28.09.2006 20:20:08 Why does this formula not work? Why does this time formula *NOT work* if I leave out '(E8<D8)'? The formula works normally when written as below... =(E8<D8)+E8-D8 When I leave out '(E8<D8)', the cell shows ######### If I use any 'number' format, the number is a negative number. The 'Start Time' is in cell D8. Tne 'End Time' is in cell E8. The formula works properly even if the 'End Time' cr... 22 28.09.2006 20:18:09 RIGHT Arguement? If the number 123456 was displayed in cell A1, how could I get the fifth digit (5) displayed in cell A2? TIA... 8 28.09.2006 20:01:08 How do I shade the area underneath a curve ... 1 28.09.2006 19:55:01 Why won't text in cell wrap. Cell format set to wrap. The text in the cell only wraps when I click on the text. As soon as I move the focus away from the text it goes back to unwrapped. The format of the cell is wrapped.... 3 28.09.2006 19:27:01 Formula starts =+(cell reference) Can anyone provide a detailed explanation of what it means when a formula is input into a cell with the addition sign immediately after the =. Examples: =+a1, =+C:\Excel\[WB]Sheet1!A1, =+L187+(Q213), =+Sum(A1:A33) I inherited several spreadsheets that I am revising that use this convention and I can't seem to find any information on what it means other then a note in Excel for Dummies ... 4 28.09.2006 19:19:36 How to print only the used portion of excel spreadsheet? When printing a 5 page excel spreadsheet, printer wants to print 1200 pages. Can I get it to print only the pages with data (the first 5)?... 5 28.09.2006 19:18:52 Countif Function in Two Columns I have a little problem I am trying to count the # or occurences in once column as it relates to a specific object in another. An example is below. ColumnA ColumnB LA Cancel DC Submitted LA Submitted CH Reschedule LP Cancel LA Submitted DC Submitted I want to know in a seperate cell ... 3 28.09.2006 19:15:02 Paint fill - up to three colors Is there a way to paint fill an object equally using two or three colors?... 1 28.09.2006 18:39:02 How to globally replace a value and set a format. I have a bunch of records that contain data similar to: job_history.txt:DC_D01|Update Statistics|01062005|430|01062005|431XXX|2| I want to change all 2005 to be bold and RED. Any ideas how to do this? Thanks... 1 28.09.2006 18:25:02 replace question Hey guys! I have 2 columns A and B. What I need to do is take what is in column A and replace a string of astricks in Column B. For example: Column A Column B Result ABC need****help needABChelp DEF more****help moreDEFhelp Any idea how to do this?? Thanks guys! Mike ... 5 28.09.2006 18:24:59 Numerical patterns in Excel How do I create a pattern of 50? Example 32001-32050... 4 28.09.2006 18:20:49 On Excel I need to round up in tens of thousands On Excel I need to round up to tens of thousands... e.g. 158000 to 160000 or 21500 to 30000... Does any one know this formula??? Thank You in advance... 4 28.09.2006 17:51:13 Paste Array Hi, I have an array Array(750,200) I want to paste the contents into the worksheet, i tried Sheets("Sheet1").Range("C1:GU750").Value = Application.WorksheetFunction.Transpose(Array) but this didnt work, I guess because of transpose? Is there a way to output a 2x2 array automatically? Thanks for your help!!!... 2 28.09.2006 17:48:17 Another replace question Hey guys! Thanks for the help on the last question! Here is another one. I have column A with this text: sometexthere=moretexthere What I need to do is make it like this with quotes: sometexthere="moretexthere" Any way to do this? Thanks!!! Mike ... 3 28.09.2006 17:14:02 How do I change default colours and print settings for Excel2003 (WinXP) ? Hi How do I change the default colours and default print settings for new Excel2003 (WinXP) files ? With thanks Ship Shiperton Henethe ... 2 28.09.2006 17:09:30 Find a character in a textstring I would like to find a character (in my case the letter S) in a list of textstrings, and then return the textstrings containing "S" , as well as the two other columns that correspond to it . My columns are as follows 36359 LP 21227.78 36360 FLS 16218.75 36361 FS 14471.59 36362 FS 30109.59 36363 FS 7801.26 36364 FAP 29816.75 36365 FLS 16875 So if I wanted to search for "S" in c... 3 28.09.2006 16:56:03 triangular correlation matrix I would like to set up a triangular correlation matrix in Excel, as per the upper portion of the "House of Quality" (a system engineering technique). ... 2 28.09.2006 16:51:02 Excel + user input + external data (URL manipulation) Is there any way for excel to manipulate the values sent with the external data (URL) request? Here's the basic concept: - User opens survey excel file on their desktop. - Excel displays default data. Some of which is defined from a URL (www.foo.com/search.php) - Excel populates a drop down with part of the returned data (Company A => 1, Company B => 2, etc) - User makes selection ... 3 28.09.2006 16:48:39 how do you keep the template helper from opening every time? ... 1 28.09.2006 16:47:02 Automatic page breaks I have a large Excel spreasheet that has page breaks that I inserted. However, there are also Excel automatic page breaks in the file that I don't want. Is there any way to turn off the automatic page breaks for future spreadsheets? Is there any way to turn off the automatic page breaks from my current spreadsheet (I know how to remove them but I am hoping there is a way to turn them off... 1 28.09.2006 16:38:03 duplicate text How do you find duplicate text entries using conditional formatting? All information is geared towards number format. I have names (all in one col) that I would like to find out if they are duplicated...... 5 28.09.2006 16:37:02 I want to track sales, gp vs. budget I need a template Can someone email me a template I can use to track sales, gross profit vs. budget... 1 28.09.2006 16:31:02 Excell 2003 [1] How does one show negative numbers in red color? [2] How does one "paint" cells/fields?... 2 28.09.2006 16:22:00 1369 Pages: 1  2  3  4  5  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  >>