| Subject | Date Asked | Expert |
|
| Accumulation of time in a log | 11/10/2009 | Tom Ogilvy |
Q: I am upgrading my Log Analyzer that extracts performance statistics from a date/time stamped log. ... A: Robert Assume your data is in C2:C3000 and the user specifies the time lower bound in G1. ...
|
| excel extracting data from cell | 11/10/2009 | Tom Ogilvy |
Q: I am trying to extract data from within a cell that contains a massive string. For example, in cell ... A: TX technically yes, you can do that cell C4: =Mid(A1,find("sample",A1),6) But that seems ...
|
| Using marked cells to select and copy rows | 11/9/2009 | Tom Ogilvy |
Q: I have a spreadsheet with many rows of data. I have created a column A that a user puts a mark in ... A: Dan, If I wanted to copy rows that have a text value in column A I would do Sub ABC() Dim r as ...
|
| Vlookup and Match | 11/9/2009 | Craig |
Q: I have a list as follows:- Column A B C Reg Branch ... A: If you know how to do vlookup, you are halfway there. All you need to do is add a column to each ...
|
| Use Excel Shrotcuts in VBA | 11/9/2009 | Victor Lan |
Q: I want to use the excel shortcuts such as Ctrl + C, Ctrl + V, Ctrl + A etc...anything in my VBA ... A: Do you mean what you want to copy, cut and paste data using Excel VBA? If so, you can certainly do ...
|
| Copy values from one sheet to the other | 11/9/2009 | Jan Karel Pieterse |
Q: I am having two excel sheets, W1 and W2. In W1 i have certain charecters and in W2 i have the 3 ... A: It looks to me like this is something you do have to do manually. To aid a bit, you could have both ...
|
| Copy values from one sheet to the other | 11/9/2009 | Bill Hermanson |
Q: I am working with two excel sheets W1 amd W2. I have some charecters in W1 and corresponding values ... A: Terrance, You will use the VLOOKUP function to compare the characters (hopefully you mean WORDS) ...
|
| Copy values from one sheet to the other | 11/9/2009 | Aidan Heritage |
Q: I am having two excel sheets, W1 and W2. In W1 i have certain charecters and in W2 i have the 3 ... A: Im not following what needs to be done here can you clarify if it helps, you can email me at ...
|
| Enhancing the formula | 11/9/2009 | Tom Ogilvy |
Q: Remember, you wrote a custom formula to look up on the basis of both time range and B Number? Well ... A: It isn't clear to which column the differential would be applied, but assume the right most column ...
|
| How do I change the active cell in a non contiguous range or selection? | 11/9/2009 | Tom Ogilvy |
Q: I know that "tab" "enter" etc change the active cell in a non contiguous range in the spreadsheet . ... A: ptroiano There is no reason to select the cells or change the activecell v = Range("A1").Value ...
|
| compare, match and copy between sheets | 11/8/2009 | Victor Lan |
Q: sorry to email you directly previously.. below is what im trying to do If cell H of Worksheet A = ... A: The method SpecialCells(xlCellTypeLastCell) simply returns the range of the last cell that is used ...
|
| VBA | 11/8/2009 | Tom Ogilvy |
Q: Evening, I'm trying to circumvent the conditional format limit of 3 in Excel 03. I have a file ... A: David, percent values are stored as decimal values if the cell actually holds a number and you have ...
|
| How do I change the active cell in a non contiguous range or selection? | 11/8/2009 | Tom Ogilvy |
Q: I know that "tab" "enter" etc change the active cell in a non contiguous range in the spreadsheet . ... A: Flip, just activate the cell you want to be the activeCell. As long as it is in the current ...
|
| Excel question | 11/8/2009 | Aidan Heritage |
Q: I hope you may be able to help me with a problem I am having with Excel. I am a commodities ... A: Im tempted to suggest getting office 2007 which has a higher row count, but I suspect you would ...
|
| SUMIF | 11/8/2009 | Jan Karel Pieterse |
Q: I have 20 worksheets that contain some of the same data (names). I want the formula to look at ... A: Unfortunately, there are not many functions that can really work accross multiple worksheets like ...
|
| SUMIF multiple worksheets | 11/8/2009 | Victor Lan |
Q: I have 20 worksheets that contain some of the same data (names). I want the formula to look at ... A: SUMIF is not a 3-D function, thus it cannot be used across multiple worksheets. See ...
|
| SUMIF formula across multiple worksheets | 11/8/2009 | Aidan Heritage |
Q: I have 20 worksheets that contain some of the same data (names). I want the formula to look at ... A: Cannot be done directly with functions its one of the annoying things about excel you CAN do it ...
|
| Excel is subtracting numbers when it gets bumped off the bottom of my spreadsheet | 11/8/2009 | Jan Karel Pieterse |
Q: I'm a commodities trader and i have real time data coming into my spreadsheet all day. I fill up ... A: I'm not sure how this part is caused by Excel: "when the data gets down to the bottom, about row ...
|
| save sheet as separate file | 11/8/2009 | Tom Ogilvy |
Q: I am always happy to have your kind support. Your help, comments and suggestions are really useful. ... A: attis, I can't test the specific code offered because I don't even remotely have any situation ...
|
| count if | 11/8/2009 | Richard Roberts |
Q: I have two criteria in column C "individual,"organization" I need to switch between the two , using ... A: Bill I am not sure that I am reading the question correctly but-- You can use data validation to ...
|
| Hiding rows with blank value | 11/8/2009 | Tom Ogilvy |
Q: The spreadsheet containing a list box which enable user to drill down by Region and the results will ... A: I assume your dropdown is done using the List option from data validation. If so, you can react to ...
|
| Hiding rows with blank value | 11/7/2009 | Tom Ogilvy |
Q: The spreadsheet containing a list box which enable user to drill down by Region and the results will ... A: Sian, Let's assume that column B can be used to determine which rows are blank - i.e. if a cell in ...
|
| Calculations using Visible results of other Calculations | 11/7/2009 | Tom Ogilvy |
Q: I think there will be blindingly simple answer to this but it eludes me at the moment. I have a ... A: IAN, Based on your stated sitation and needs, I would recommend making the stored value and the ...
|
| VBA Formula | 11/7/2009 | Aidan Heritage |
Q: I am trying to write a formula in VBA to update the value of a specific cell based on its value in ... A: use the CHANGE event of the worksheet to handle the macro (vba editor, click the worksheet, change ...
|
| Insertion point | 11/7/2009 | Aidan Heritage |
Q: assume that the insertion point is positioned at the beginning of the txtName text box. which one of ... A: technically none of them as it needs round not square brackets, also not a method I use myself, but ...
|
| visual basic help | 11/7/2009 | Jan Karel Pieterse |
Q: assume that the insertion point is positioned at the beginning of the txtName text box. which one of ... A: You do need to specify the SelStart too, so this should do the trick: txtName.SelStart = 0 ...
|
| vsual basic | 11/7/2009 | Tom Ogilvy |
Q: which of the following would place the insertion point in the first position of a text box named ... A: Nessie, I created a userform and with Textbox1 and a commandbutton. I then put this code in the ...
|
| time calculation | 11/7/2009 | Tom Ogilvy |
Q: I have a large spreadsheet with production times, ie time job started and time job finished. ... A: Malcom, E2: 8.55 E3: 11.2 E4: ...
|
| finding letters of the alphabete | 11/7/2009 | Aidan Heritage |
Q: I like to do crosswords/codebreakers I automated the process but know want to cross the letters used ... A: I think the easiest way to do this would be with conditional formatting where a formula is used ...
|
| Using formulas to sort rows of data automatically | 11/7/2009 | Victor Lan |
Q: I'm making a financial spreadsheet. I need to be able to sort 5 columns and up to 20 rows (can be ... A: I looked at the website and it shows us how to use Excel formulas (without VBA) to generate a ...
|
| Error with looping macros | 11/7/2009 | Aidan Heritage |
Q: In Microsoft Excel 2003 I have a macro set up that pulls information from a database where the ... A: There isn't a limit for looping as such, but there IS a limit for variables - you haven't included ...
|
| Password protect cell editing | 11/7/2009 | Adelaide carvalho |
Q: :) Please look at this post before trying to answer my question. ... A: How are you? Yes it is possible. Please see the following for Excel 2007. But similar way for Excel ...
|
| Password protect cell editing | 11/7/2009 | Chad Welch |
Q: Please look at this post before trying to answer my question. ... A: Thorsten, That is a functionality that is built into Excel. You don't mention which version of Excel ...
|
| Formatting Dates in a Formula | 11/7/2009 | Miguel Zapico |
Q: =if(today()+45>A1,"Warning: Payment is coming due","") In your example above, how should A1, which ... A: In order for the formula to work, it has to be in a Date format. You can check if it is a date ...
|
| compare, match and copy between sheets | 11/7/2009 | Victor Lan |
Q: sorry to email you directly previously.. below is what im trying to do If cell H of Worksheet A = ... A: The VBA code given is working fine. However, your description of the problem is not too clear. I ...
|
| Excel formula needed | 11/7/2009 | Bill Hermanson |
Q: I looking for an Excel formula to perform the following: Objective: The spreadsheet will compute ... A: Mark, Your problem is most likely more complex than a simple formula, especially given your ...
|
| Fuctions Running Automatically | 11/7/2009 | Richard Roberts |
Q: I am doing this in VBA because when I write if statements in excel itself it causes a circular ... A: Eric I am definately not a VBA expert--while I may be able to figure out an answer for you It won't ...
|
| Using formulas to sort rows of data automatically | 11/7/2009 | Victor Lan |
Q: I'm making a financial spreadsheet. I need to be able to sort 5 columns and up to 20 rows (can be ... A: In order to sort it automatically, you will need to use VBA macro to capture worksheet events. ...
|
| VBA Formula | 11/6/2009 | Aidan Heritage |
Q: I am trying to write a formula in VBA to update the value of a specific cell based on its value in ... A: As a function, it should have something stored in a variable called FF, and to VB you have a lot of ...
|
| Formula in VBA | 11/6/2009 | Jan Karel Pieterse |
Q: I am trying to write a formula in VBA to update the value of a specific cell based on its value in ... A: Not sure what your requirements are, the proper syntat inside the function might be: Public ...
|