Threads Replies Last Post 326 Pages: <<  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  36  >>   Excel 2K3 Macro - Find and Update Hi All- Trying to write a simple macro to do the following--Here's my basic excel spreadsheet. So I have a report that spits this information out....(could be hundreds of records..all different parts) A B Part AFM AFM ANT BAG BAG BAG What I'd like to be able to do is - for every part it finds - its update the spreadsheet with a loc... 2 31.08.2006 05:33:27 sum column while excluding corresponding text values? I want to sum a column of numbers in another workbook but exclude numbers from my total that have certain words ("batch" and "state") in a corresponding column. So using the table example below my formula would return a sum of 303. Table example: Routing Events Flood Plain Mapping 101 Mapping by Batch 150 Manual Determination 101 Sta... 7 30.08.2006 21:36:11 Lost the office assistant! Whilst working in Excel, I quickly dragged the office assistant out of the way to the right, and it disappeared completely off the spreadsheet. I can hear it running, how do I get it back? TIA tox ... 9 30.08.2006 21:28:14 Formatting email addresses I keep several spread sheets of club membership, etc, and need to concentrate email addresses, but I do not want them to be hyperlinks. I have formatted the entire column as Text, but sometimes when I add a line, the formatting rebounds to some sort of default. I never want any hyperlinks in my worksheets EVER. Can someone please advise? TIA!! -- Regards, P D Sterling Dallas TX... 3 30.08.2006 21:14:20 Question about formats I guess this is about formats - I am addicted to coloring cells and rows to catch my attention or to classify data. I dislike the default bright yellow, and usually use red, white and blue BUT some worksheets retain where I was last, and others lose my last point of reference on color, when I close all. Any idea why? All sheets are originated by me. -- Regards, P D Sterling Dallas... 2 30.08.2006 20:29:30 Pivot table field viewing; how to view all not shown items? I have a pivot table and want to show all not shown items, see pivot example below: x y total xx y 1 z 2 a 1 I want pivot to show in column "A" the "xx" data.. x y total xx y 1 xx z 2 xx a 1 Any micro that I can use to do this? Thanks!!! ... 2 30.08.2006 17:26:22 distinct count of text in different wb? How do you do a distinct count of text in another workbook? I've seached online and have found several formulas but can't get any to work right. This is the formula I last tried... =SUMPRODUCT((Queue_User_Routing.csv,$B$2:$B$2000<>"")/COUNTIF(Queue_User_Routing.csv!$B$2:$B$2000,$B$2:$B$2000)) Any suggestions? Thanks!!! -Danny ... 3 30.08.2006 17:01:11 Change condition in cell I would like to automatically have a cell change color if it is the largest number. For instance: B1=22 B2=24 B3=30 B4=15 Since B3 is the most, I would like for it to turn RED for instance. I can't think of the proper conditional format. Anyone? Thanks! ... 5 30.08.2006 16:26:44 Drop down list and obtain data in a cell I have this situation where I have a drop down list for a number of suppliers. There is a summary worksheet followed by a series of worksheets, one for each supplier all identical in their layout. What I would like to do is select a supplier from the list and when selected take the data in cell C75 on the supplier worksheet and place it in cell C75 on the summary sheet. Is this po... 3 30.08.2006 16:01:38 Pass cell data to Query Anyone know how to pass the contents of a cell to an sql query? I have a worksheet that I have connected to an SQL database that I want to query to get data. The worksheet is like an invoice. What I want is the user to input a product code and currency then the query to return the price. It sounds simple enough to do with a nested function but the price list is made complex by prices in ... 2 30.08.2006 15:28:01 Joining worksheets / outer join I've found some spreadsheet joining discussion threads, but I haven't found one which I think is applicable... Basically, I have 5 worksheets in an Excel file to be used as a mail merge. Each worksheet has lists of companies and the industries that they handle. Some companies have offices at different addresses, which should remain as seperate rows. Some companies handle more than on... 2 30.08.2006 15:22:13 Filter for bad email addresses I am not a spammer but I do have a customer who has given me I a column with 1200 email addresses in it. The person that entered these emails sometimes includes or misses one of the following items. - an extra space - a missing period before the .com (or .net, etc) part of the email - no @ symbol Does anyone know of a function I could use to pull out any emails that have one of ... 2 30.08.2006 14:56:58 Further to macros Thanks to the poster who unlocked the macro mystery - I did a nice little macro and did twice the work in the last few hours. One problem - this was to, from a given point, choose the entire row, mouse down one row and delete the two rows. When I did this by macro, there seemed to be no chance to undelete. Can anyone shed light on this? I did check the wording of the macro, and there wa... 3 30.08.2006 14:38:03 Retrieve row index number Hello all, I am writing a macro where I would like to retrieve the row number and set an integer variable to that value. For example I have: Dim RowVal As Integer If I am in cell M7, how do I get RowVal to be = to 7? ... 4 30.08.2006 13:25:54 Truncated graph-axis labels Googling this doesn't seem to get me anywhere. I'm finding the same problem on several ordinary line graphs. The numbers shown on the X-axis scale (these are always simple 4-digit years) become more frequently truncated -- losing their rightmost digit -- toward the right side of the axis. I say "more frequently" because it isn't even consistent. Sometimes a full 4-digit year is shown e... 4 30.08.2006 12:43:58 Hello from picasa Does anyone know how to send movie files from picasa through Hello! It transfer them into jpg. and cannot be viewed ... 2 30.08.2006 11:04:08 Saving a Template I have a spreadsheet that I have set up as a template (ProductionTemplate.xlt). How do I promt the user to save it under a new name each time it is opened (to avoid overwriting the template)....just had a thought, would making it Read Only do that....... Any help appreciated. Thanks Rob ... 2 30.08.2006 10:49:47 Unable to filter properly because of merged cells Hi all, my name is Sebastiaan of Holland and i could sure use your help!!! Thanks for taking some of your time to give me some advice, very apreciated!!!! To summarize my problem: I want to export a huge database, and then start a macro on it which will select the data according to country and put it on different worksheets per country. However, the way the database is being exported... 2 30.08.2006 10:49:42 Delete rows with macro code Hi, I would like to try and find a macro code that does the following: 1. Delete rows when cells in column C3:C2000 are less than (<) 50, and; 2. Delete rows when cells in column F3:F2000 are exactly equal to (=) "0" This 'exactly' is important as I have some blank cells in column F which are greater than 50 and I need them to remain within the sheet. If anyone can give me any ... 4 30.08.2006 09:53:45 combining bar diagrams for capacity planning Hi, I am trying to display the following information in one combined bar diagram: 1. the value for the available total capacity: this value should be displayed as 100% in a bar. 2. the value for capacity already reserved: this value should be disblayed in comparison to value 1. 3. the value of the required capacity for the actual work order that needs to be planned: this value shou... 1 30.08.2006 09:34:03 Macro basics? where can I get some resource about creating macros? I was a top expert in Lotus 1-2-3, and loved writing little macros to make work go faster and smoother, but MicroSoft doesn't seem to understands macros the same way and I am depressed about it. -- Regards, P D Sterling Dallas TX... 7 30.08.2006 04:30:54 Question about Excel (Office) auditing/changes I have a document that will need to be posted on a website available for users to download & change/approve. The approval process will not make any changes at all to the document. However, I do need to know they've opened the document. Is there a way to get the name/machine/ip or something regarding who opens a file and when they open it? If so, I would like to do something like th... 2 30.08.2006 02:25:58 Help with searching a column I am having some trouble searching an entire column to see if a value is in the column. I've tried =IF(ISNUMBER(SEARCH(A1,K:K)),"TRUE","FALSE") - But it doesn't seem to be working. It only works if the A1 is in every cell of K. I have two columns, the first I have a list of values each on its own row. column A 1. CSS-PB-350 2. CSS-PB-122 3. CSS-PB-100 The second contains multiple val... 4 30.08.2006 01:48:01 Inserting rows in link source - doesn't show up in link destination? Hi. Please help if you know an answer: - I am trying to setup a workbook with 2 worksheets. - The left column in each worksheet needs to be identical. - I have setup a link from the contents of the left column in worksheet1 to worksheet2 (copying the range in worksheet1, and pasting as link into worksheet 2) - When I change an entry in one of the linked range of cells in worksheet1... 6 30.08.2006 00:54:37 COUNTIF vs. Edit/Find (Crtl F) Sheet one is a "calendar" of events and in the various days different individuals are shown as assigned to a specific task. If I want to see how many times D.Smith is assigned, I can hit Ctrl F and search for all occourences of D.Smith, or even just smith, and all occurences will be dispalyed in the resulting dialogue box. I'm trying to perform the same task with the =COUNTIF function ... 4 29.08.2006 23:47:20 326 Pages: <<  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  36  >>