Excel/Questions

SubjectDate AskedExpert
combobox and text box redundant reoutines11/24/2009Tom Ogilvy
  Q: I have two questions which are similar but unique. I have a form with 5 comboboxes and 5 textboxes ...
  A: Scott, First, by form I assume a Userform, but regardless, the below works with a userform or a ...
IFERROR formula11/24/2009Tom Ogilvy
  Q: I have created an spread sheet to be used by many different people with many different versions of ...
  A: Danielle, say you have =ifError(exp,"") where exp is your expression/formula that could produce ...
finding duplicates in Excel11/24/2009Aidan Heritage
  Q: I am usually great at Excel but this one has me stuck. I have names listed in column A. In column B, ...
  A: To highlight the cells, use conditional formatting (you didn't say which version of excel so I'll be ...
Copying columns from another workbook11/24/2009Bob Umlas
  Q: My requirement is a little larger version of following problem, and I will follow your guidance for ...
  A: Adjust the workbooks names accordingly: Const WBA as string = "BookA.xls" Const WBB as string = ...
Excel 2007 macro for hiding specific columns11/24/2009Tom Ogilvy
  Q: Hope you do well I am currently struggling on the below...(excel 2007) I have a range of columns ...
  A: Dominique Sub HideColumns() Dim r As Range, cell As Range Set r = ...
Excel Macros11/24/2009Bill
  Q: I'm trying to create a form for my staff to complete in Excel which then feeds into a 2nd sheet ...
  A: Dim FirstBlankCell as Range Set FirstBlankCell = ...
Conditional formatting11/24/2009Craig
  Q: With regard to the question on this following link ...
  A: It sounds like you are on the right track. You need to go in to the conditional formatting in that ...
enter formula and autofill to end of data in the column of selected cell macro11/24/2009Jan Karel Pieterse
  Q: I'm trying to extend a formula that creates a column in the middle of a sheet depending on what ...
  A: Not sure I understand the difficulty here? You formula already sums every other column and if you ...
FOLLOW-UP11/24/2009Tom Ogilvy
  Q: I'm using the IF function for my project, but I encountered a problem when it reaches up to 7 ...
  A: Victorino, ="Mr. " & MID(A1,FIND(", ",A1)+2,FIND("#",SUBSTITUTE(A1," ...
Automatic File numbering11/24/2009Miguel Zapico
  Q: I badly needed an help on automatic case numbering interconnecting with File no. Please open the ...
  A: Sorry but I don't accept files any more. Regarding the automation, can you describe what you need ...
followup question...the e-mail said you couldn't answer and didn't allow mee to rate or nominate you..11/24/2009Tom Ogilvy
  Q: Your answer was spot on and your speed in coming up with it was incredible - if I wanted to select ...
  A: Marcia, this worked for me. Sub AddColumns() Dim lastcol As Long, i As Long lastcol = Cells(1, ...
Lookup a value from muliple lines11/24/2009Tom Ogilvy
  Q: I have an Excel 2007 Spreadsheet, which has one sheet which contains a long list of names, and ...
  A: Andy, Say the names in Sheet1 start in row 2. so in B2 (or the next available column) put in a ...
Copying columns from another workbook11/24/2009Bob Umlas
  Q: My requirement is a little larger version of following problem, and I will follow your guidance for ...
  A: Select wb B's Sheet 1's range B4:B1000 (as far down as the last used cell is), copy, activate wb A, ...
IF statement11/24/2009Jan Karel Pieterse
  Q: i got problem using IF statement which is cannot use in more than 7 input. in my problem also got ...
  A: You can achieve this with the IF function without a problem. THis formula does what you describe ...
Help required with Excel Macro11/24/2009Aidan Heritage
  Q: I require assistance from you in a college project where I need an excel macro which would save an ...
  A: easiest way would be with the Filecopy command Dim SourceFile, DestinationFile SourceFile = ...
Date sensitive password protection11/24/2009Bill
  Q: Is there a way to have an Excel password work up to a certain date and then no longer work beyond ...
  A: One way would be to use something like the code below, however you will need to do something to hide ...
Looping with VLOOKUP11/23/2009Richard Stephens
  Q: I have two columns C and D. I would like to extract ALL the rows from Column D which match a ...
  A: VRJ The simplest solution would be using the Data Filter option, you can do this on the existing ...
Looking up information11/23/2009Tom Ogilvy
  Q: I have a grid type spreadsheet that I use as a wire-lenght matrix chart. You can imagine that there ...
  A: Jim, Assume you header data is in B1:J1 (9 racks), and row labels in A2:A10 (Same 9 racks) then ...
How to Concatenate a Text String from multiple cells containing a search value11/23/2009Aidan Heritage
  Q: On 11/20/09 you answered a question that partially helps solve what I'm attempting - I am aware of ...
  A: I would do this using a User Defined Function in VBA -=- ...
Multiple Count Formulas (Excel 2003)11/23/2009Aidan Heritage
  Q: I am having problems trying to count multiple variables using Excel 2003. I have attached a picture ...
  A: You can do multiple condition countif or sumif calculations by a clever use of the sumproduct ...
Format Automation11/23/2009Tom Ogilvy
  Q: Hey Tom, My question is regarding excel 2003. I have recorded 2 individual macros(Landscape and ...
  A: Vish, You say it doesn't process the files, so I assume if you run it, then nothing happens. Is ...
how to make one cell follow other in specific rule11/23/2009Miguel Zapico
  Q: could you please tell me how to do the following: I have to column, one of them for Item code and ...
  A: One way of doing this is to use VLOOKUP. For that, you will need to create a table with all the ...
Macro to enter and fix date11/23/2009Tom Ogilvy
  Q: I have a spreadsheet with 2 columns. In column A I enter the date and against it in column B I enter ...
  A: Tony, You would need a macro to do this Right click on the sheet tab where you want this behavior. ...
Macro to move rows between worksheets11/23/2009Tom Ogilvy
  Q: I am trying to create a macro that will cut (remove) all rows that contain “Resolved” in column M, ...
  A: Claudia, If Resolved is found in column M as your code seems to indicate, then this worked for me: ...
Looping in Macro11/23/2009Richard Roberts
  Q: can the macro look in a set of folders for a specific name based on a specific cell value and copy ...
  A: Khaled I am definatly not a expert in macros--but I do believe you can do what you want--I suggest ...
Excel formula question.11/22/2009Bob Umlas
  Q: I am a real estate agent who created a spread sheet for our deals. I have a close date on the ...
  A: First issue is getting the series you want. In cell Q1 enter 12/1/2009. Select Q1:Q2 (Q2 is empty), ...
Excel Spreadsheet11/22/2009Aidan Heritage
  Q: I am creating a mileage chart in Excel with same cities horizontal and vertical - is there a way to ...
  A: Hopefully that's a different question - the original question seemed to relate to how to put the ...
Excel Spreadsheet11/22/2009Aidan Heritage
  Q: I am creating a mileage chart in Excel with same cities horizontal and vertical - is there a way to ...
  A: if you are doing this as a one off, then you can copy the results and use edit, paste special to ...
Check boxes in forms11/22/2009Aidan Heritage
  Q: I created a form in EXCEL 2003 on an XP machine using check boxes which, when checked will do ...
  A: Not sure what method you have used to create checkboxes as they exist in the control and forms ...
Excel Number11/22/2009Miguel Zapico
  Q: in excel once I enter in A1 cell as "40" in need the result should be as "Fourty" in cell "B1" ...
  A: You will need VBA for this. Fortunately, you have code from Microsoft that is ready for that, in ...
Count/Countif11/22/2009Richard Roberts
  Q: ... I am trying to do a input sheet for a questionnaire. Currently having trouble trying to get a ...
  A: Matthew It sounds as though you need the countif() formula, where the formula only counts the cells ...
Date computation excluding Sundays11/22/2009Tom Ogilvy
  Q: I need to computed for the expected date, i have a data of actual date and lead time. the straight ...
  A: Apple, For 9 days, the formula would be Assume A1 contains the start date ...
pulling only some data daily to different rows11/21/2009Bill
  Q: I have got a 3rd party stats program to pull data daily for me either to txt or xls formats. I have ...
  A: It seems to me that your stats program is the one that needs "adjusting" and not EXCEL since you ...
Exel Conditional Format11/21/2009Bill
  Q: I am in the military and i am currently deployed. We are trying to keep track/log of when our ...
  A: For the week before up to THE date then use this as one conditional formatting formula, assuming B1 ...
Using INDEX with multiple criteria11/21/2009Tom Ogilvy
  Q: On Feb 22 of this year you answered someone's question who was looking to insert names in a table ...
  A: Norm, This isn't my site. This belongs to Allexperts. I am just one of the volunteers here. ...
#DIV/0! error11/21/2009Tom Ogilvy
  Q: I have a spreadsheet that I have the coloums set as accounting so all the $ line up. But when I put ...
  A: Angela, my formula produces a zero stored as a number. how it looks depends on how you format the ...
Open workbook without defining the path11/21/2009Tom Ogilvy
  Q: I was wondering if there is a way to open a workbook without having to define the path, I do not ...
  A: steven, first, you asked for code to open a file without the path. But I don't know where that ...
spreadsheet for completing tasks.11/21/2009Miguel Zapico
  Q: I have a spreadsheet which displays. If TODAYS DATE(C1) is greater or less than DUE BY DATE(B4), ...
  A: You could use a formula like: =IF(ISNUMBER(D4),"COMPLETED",IF(C1>B4,"DUE","")) This will check first ...
delete row where cell has specified text11/21/2009Bob Umlas
  Q: I need to develop a macro that will search through a worksheet and delete any row with the word ...
  A: Sub DeleteNotDue() 'untested Dim Rg as Range On error resume next For ...
VBA search using inputbox11/20/2009Tom Ogilvy
  Q: I am trying to use inputbox to search a sheet for specified text e.g "town" and when it finds the ...
  A: Andreas, Sub FindMultiple() Dim tgt As Variant, sh As Worksheet Dim r As Range, sAddr As String Dim ...

Page:   1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10  |  Next

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

All Answers

Answers by Expert:


Ask Experts

Volunteer


Tom Ogilvy

Top Expert on this page

Expertise

Worked with the program for many years - provided assistance on MS Excel Newsgroups since 1997. Have received the Microsoft MVP award annually since 1999. I don't answer questions on using Excel in a browser Since I have no way to test this. Prefer not to answer charting questions. I consider myself to be particularly knowledgeable about using VBA internal to Excel but have no problems with formulas and pivot tables either.

Experience

Have Used Excel for 15 - 20 years. Answered in excess of 70,000 Excel related questions in MS Excel newsgroups. Unless obvious, please specify whether you want a worksheet function or macro/VBA solution.

Education/Credentials
BS General Engineering (concentration in Industrial Engineering) MS Operations Research Systems Analysis

©2009 About.com, a part of The New York Times Company. All rights reserved.