| Subject | Date Asked | Expert |
|
| Excel Looping Macro | 2/8/2010 | Tom Ogilvy |
Q: I have 3 columns of data in a spreadsheet. I need a macro that will read down column 1 and find the ... A: Craig, Unforunately I can't write sample code for Field1 that might be anywhere on the sheet, so I ...
|
| Macros assigned to buttons changing after running program | 2/8/2010 | Isaac |
Q: Excel 2007, VB 6.5 I'm running programs I have run for months now and all of a sudden this month, ... A: well, the suggestion I am about to give may not help you figure out why it is just now happening, ...
|
| Count numbers within date range | 2/8/2010 | Aidan Heritage |
Q: I need help with a formula. Here is what the spreadsheet looks like (column B contains only the ... A: Before working out a formula, can I check - will the data be ONLY current year, or do we have to ...
|
| Excel | 2/8/2010 | Tom Ogilvy |
Q: I'm working on a spreadsheet that has different main accounts with a prospective name to them. Below ... A: Audri, If you sorted each grouping separately. Otherwise, you would would need to put some field ...
|
| Nested If, And, Or Functions | 2/8/2010 | Philip Buckley |
Q: I am having a problem calculating the following: Family Leave Calculation: 5 days for FT employees ... A: Jamie, These nested If, And, Or functions can get tricky that way. Rather than pull yours apart ...
|
| How to block first few rows at top of sheet | 2/8/2010 | Craig |
Q: I used to be a very low-level but regular Excel user. In the last cetury!! Today I made a simple ... A: I would not have answered the question this way, had I known you were on a Mac. I don't really have ...
|
| Multiple results from list | 2/8/2010 | Isaac |
Q: Using Excel 07 I have a "Splash" page where I have a drop down list with Supervisor names as my list ... A: Stephen, I would either use VBA (with code behind the sheet, that looks for sheet change and ...
|
| match partial string | 2/8/2010 | Stuart Resnick |
Q: I have 3 colums, (A)country-provider, (B)prefix, (C)rate/min the prefix (B) has anywhere between 1 ... A: The line of code nearestLookup = rngRow.Offset(0, 1) means that when the value in col B is ...
|
| Excel- Incident Calculation | 2/8/2010 | Aidan Heritage |
Q: I want to calculate how many hours the incident took to resolve from Date/Time logged and Date/Time ... A: This is a fairly common request - but not necessarily as simple (!) as laid out - can calls be ...
|
| Auto Columns | 2/8/2010 | Sixthsense |
Q: Trust all's well with you.I'm a managing partner of a language school and we currently offer ... A: One good use of Data Validation comes when there's a need to "link" two or more comboboxes, making ...
|
| Drop Down List + Auto Columns | 2/8/2010 | Victor Lan |
Q: Trust all's well with you.I'm a managing partner of a language school and we currently offer ... A: It is certainly possible. Debra Dalgleish a Microsoft Excel MVP professional has an excellent guide ...
|
| To get data to variable and display them in a summary quasi | 2/8/2010 | Tom Ogilvy |
Q: I would like to get the information about ActiveCellRow into variable after my macro processing ... A: Martin, since s comes in as a argument to your function, I have no idea where it is declared or how ...
|
| about excel... | 2/8/2010 | Richard Roberts |
Q: i m facing a problem in excel. i want to copy the row of one sheet to another sheet on which vlookup ... A: B This is what the excel help says aboout the #REF! error--- "Correct a #REF! error Occurs ...
|
| Excel and Learning | 2/7/2010 | Bob Umlas |
Q: I wanted to ask for a beginner on excel how long would it take to reach a "comfortable" advance ... A: Way too vague a question - I don't know you nor what you consider a "comfortable advanced" level. ...
|
| delete macro | 2/7/2010 | Aidan Heritage |
Q: I have an application that I wish to delete after 5 uses. It is opened by a macro in another file. ... A: When I checked this for you it did work - except that I got a path not found error, but I expected ...
|
| summtion of base 20 etc | 2/6/2010 | Victor Lan |
Q: Hay! I m zulfiqar and need help in excel Sir, As when we add the time in excel for example A1 = ... A: Yes, it is possible in Excel to get the value of 33:12:06 in A3 using different base value for time. ...
|
| Calculating hours | 2/6/2010 | Richard Roberts |
Q: Is there any possibility in Excel to calculate within a timelapse, how many hours are before and ... A: How about this--if A1 contains 13:00 and A2 contains 19:00 and C1 contains 17:00 The the formula ...
|
| summation of base 9 and 20 | 2/6/2010 | Aidan Heritage |
Q: Hay! I m zulfiqar and need help in excel Sir, As when we add the time in excel for example A1 = ... A: Using time as an example doesn't help, as excel stores time as a decimal fraction - it just gets ...
|
| delete macro | 2/6/2010 | Aidan Heritage |
Q: I have an application that I wish to delete after 5 uses. It is opened by a macro in another file. ... A: B1 is never changing - the change event is firing on you updating A1 - if you modify that then it ...
|
| Excel formula help. | 2/5/2010 | Sixthsense |
Q: Good day, I need help getting a formula that will help me do the following: I have several ticker ... A: I assume that in A1 cell you are having the data like the below:- A1 cell DAV.UL In B1 cell paste ...
|
| cell reference | 2/5/2010 | Aidan Heritage |
Q: Range("A1").Select Selection.Copy Cells.Find(What:="1370", After:=ActiveCell, ... A: you macro seems to just be a find macro, which I'm not sure is what you want - if it is, I'd just ...
|
| Formula not evaluating | 2/5/2010 | Sixthsense |
Q: I'm by no means an Excel genius, but I do have experience writing formulae. I've never come across ... A: Whether have you fixed the problem? -- Sixthsense Select the D Column and and press Alt+E+A+F. ...
|
| runtime error 13 type mismatch... | 2/5/2010 | Isaac |
Q: I am using Excel 2003 on Windows XP. This macro works for me. 'Option Explicit' is set at the ... A: I am not sure why 2003 to 2007 would make a difference, and I will acknowledge not feeling sure at ...
|
| Search for a word across multiple excels | 2/5/2010 | Victor Lan |
Q: I have more than 100 excel files on a local drive. Is there any way to find rows containing a ... A: Yes, it is possble to match the text string "Mentor" across 100 excel files and copy all rows with ...
|
| Print and Save button in excel worksheet! | 2/5/2010 | Stuart Resnick |
Q: How can I create a Print & Save button in my excel worksheet for it to open their dialogue boxes! A: If you understand vba (Visual Basic for Applications, aka "macros"), then this is possible. If you ...
|
| Prtoecting Worksheet | 2/5/2010 | Craig |
Q: Every time I set a password on the "protect Sheet" window and then saf thefie, thenextim I open t ... A: Setting a password means that you have to type the password to open it next time. What it appears ...
|
| Remove Filter | 2/5/2010 | Jan Karel Pieterse |
Q: Good day Jan Karel I have created a small macro to remove the filter and assigned it to a button ... A: If the macro should work on the current sheet, change it to: Sub RemoveFilter() 'Remove filter and ...
|
| Documenting Excel "engineering" | 2/5/2010 | Stuart Resnick |
Q: I have inherited a very complex Excel 2003 spreadsheet containing 32 worksheets and 10 VBA code ... A: Sub makeVBAlisting() 'IMPORTANT! in the VBE select Tools, References and check the 'Microsoft Visual ...
|
| Hyperlinks | 2/5/2010 | Bob Umlas |
Q: Is there such a thing as a function that will give you the hyperlink address of a cell? For ... A: Not builtin, but you can write this user-defined function. Press Alt/F11, use Insert/Module, type ...
|
| Hyperlinks | 2/5/2010 | Bill |
Q: Is there such a thing as a function that will give you the hyperlink address of a cell? For ... A: No, there is no built in function but you can create your own User Define Function (UDF). This UDF ...
|
| Pivot Table Running Account Balance | 2/5/2010 | Victor Lan |
Q: I have created a Project Finance Reporting Tool(which comprises Cash Book, Account Receivable and ... A: I would need a the working spreadsheet in order to follow your description. If you could send the ...
|
| Pictures in XL | 2/5/2010 | Adelaide carvalho |
Q: I'm working on a tool that makes it possible to select a item number by making several selections. ... A: How are you? If you are familiar with Macros (VBA for Excel), please do the following: 1. Run the ...
|
| how to count a coloured cell? | 2/4/2010 | Bob Umlas |
Q: how do i count the number of cells that have been "painted"? eg: ... A: Assuming you're talking about the FONT (not the pattern), then you can use a user-defined function ...
|
| adding rows to Excel 2007 pivot tables | 2/4/2010 | Bob Umlas |
Q: Bob, Hi, I am unable to trigger the original pivot table to incorporate the new rows added to the ... A: As long as you're in XL2007, you might as well have the source data be a Table. When it is one, then ...
|
| Function MAX() | 2/4/2010 | Sixthsense |
Q: Good day, I want to identify the SECOND bigger number in a list. The function MAX (=MAX(X$6:X$67)) ... A: Use Large Function. =MAX(X$6:X$67) =LARGE(X$6:X$67,1) this will get the result, which max function ...
|
| Excel for Mac | 2/4/2010 | Aidan Heritage |
Q: I am using Excel on my Mac. I want to highlight a few rows with the intention of hiding them. ... A: I'm not a mac expert, and I'm not sure exactly what you are doing but (in windows) to select more ...
|
| lookup data from multi workbooks | 2/4/2010 | Victor Lan |
Q: I am trying to lookup data from multi workbooks based on a user entering a date. The workbooks I ... A: You can use the following formula to look up data from your workbook - Chatt.Sched.week of 2-1.xsls ...
|
| Help on spreadsheet | 2/4/2010 | Isaac |
Q: Pls how can i combine two worksheet with dates, time, etc being the same values but arranged ... A: Put everything together in a column, then go to Filter - ADVANCED, then "show unique records only". ...
|
| match partial string | 2/4/2010 | Stuart Resnick |
Q: I have 3 colums, (A)country-provider, (B)prefix, (C)rate/min the prefix (B) has anywhere between 1 ... A: Do you know how to use Visual Basic for Applications (vba, sometimes called "macros")? If not, it's ...
|
| new spreadsheet takes a long time to open and often gets stuck | 2/4/2010 | Aidan Heritage |
Q: My computer is Windows XP. For the last few years I have kept our holiday bookings records on excel, ... A: A shortcut is a shortcut, so deleting this shouldn't delete the file. If you have a LOT of ...
|