AllExperts > Excel 
Search      
Excel
Volunteer
Answers to thousands of questions
 Home · More Excel Questions · Question Library  · Free Encyclopedia ·
More Excel Answers
Question Library

Ask a question about Excel
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
About Aidan Heritage
(Top Expert on this page)

Expertise
I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for all versions from 2 onwards

Experience
My background is in the insurance industry and call centre areas, but have been called upon to provide many varied solutions.

Education/Credentials
I'm educated to UK A level standard, but as I left school some 30 years ago that is rather irrelevent - university of life has provided more of a background!

   

You are here:  Experts > Computing/Technology > Microsoft Software > Excel

SubjectDate AskedExpert

Code that displays the Date at which a cell/cells Changed.11/20/2009Tom Ogilvy
  Q: I am working on a book check-in/out Excel file. I currently have the relevant sheet working with the ...
  A: Sujan, Based on what you have said, I would do this: Private Sub Worksheet_Change(ByVal Target As ...
Array Formula in VBA11/20/2009Tom Ogilvy
  Q: Tom you have helped me out in the past several years ago actually and glad I was able to finds you ...
  A: Hans J Hamm, this worked for me: Sub abc() Dim s As String s = ...
VBA search using inputbox11/19/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, This worked for me. Sheet1 is the hidden sheet where the data is. Sheet2 is where the ...
Multi email sender11/19/2009Aidan Heritage
  Q: How can I send personalized email to many (ex 40) customer with same subject and a bit different ...
  A: This is a standard mail merge - you didn't specify the version of word, but basically set your ...
Adding formulas worksheet to worksheet11/19/2009Miguel Zapico
  Q: I've been able to figure out how to add a cell in one work sheet to a cell in another worksheet. ...
  A: This can be because of the use of absolute references. Check that the row number in the reference ...
Excel Macro11/19/2009Bill
  Q: I am trying to build an agent-based model in Excel. I need agents to talk to each other. The agents ...
  A: Yes, I know how. But, HOW do you want the code to display, mark, identify, flag, highlight, etc., ...
ranking and pivot tables11/19/2009Aidan Heritage
  Q: Is there a function that allows you to work out the ranking of a particular column (ie. fees ...
  A: A good question- I THINK from research that this might be included in Excel 2010, but for now try ...
toggle button11/19/2009Aidan Heritage
  Q: I am using Microsoft excel 2003 and have just created a questionnaire using if statements. ...
  A: Not clear what the purpose of this is, but the easiest way would be with data validation to give you ...
VBA Code for Hyperlinks11/19/2009Stuart Resnick
  Q: 2nd Attempt... I used the code found at the following link: ...
  A: Look at the first 3 lines of your code: With Worksheets(1) set r = .Range("A3", ...
Copying multiple worksheets data and updating11/19/2009Jan Karel Pieterse
  Q: I am looking for a Macro that can help me with the following: I create several worksheets in the ...
  A: Something like this (paste code in normal module, always make sure your first sheet is active before ...
split one sheet in 2 others11/19/2009Bob Umlas
  Q: I have the following problem: I have an Excel file with 3 sheets: B+N, B and N. The user has to add ...
  A: I need to know what would trigger this thing happening -- you want a button on the sheet to run a ...
Sheet / Tab Protection11/19/2009Bill
  Q: I am working on a very large excel workbook with multiple companies. Each Company (4 total) have ...
  A: Yes there is a way. HIDE all tabs except for a generic one. Give each company its own unique ...
question about excel formula11/19/2009Stuart Resnick
  Q: In column A I have list of dates in ascending order. In column B I have the number of students a ...
  A: Example: in B2:B200 you have numbers. You want conditional formatting applied to this range, such ...
To Remove duplicate rows11/19/2009Bob Umlas
  Q: I have an excel sheet which has data. Column B contains Name, Column C contains cell phone numbers ...
  A: According to what I read, your 3 scenarios are really one: If name & phone are the same, it's a ...
split one sheet in 2 others11/19/2009Bob Umlas
  Q: I have the following problem: I have an Excel file with 3 sheets: B+N, B and N. The user has to add ...
  A: Still a bit fuzzy -- you want that when a user types info into B+N that that info is copied into B ...
Minutes formula11/19/2009Chad Welch
  Q: I am trying to divide minute and seconds. I have :00:30 (a value from a report meaning 30 seconds) ...
  A: Alex, The problem is that Excel doesn't recognize :00:30 as a time. It will however recognize ...
excel solver11/18/2009Aidan Heritage
  Q: Subject: excel solverI need help figuring out how i am going to do this - please help me - not sure ...
  A: It was to the first time you asked the question - I'm in the UK and work during the day with no ...
Conditional Save11/18/2009Aidan Heritage
  Q: Hey Aidan, Im trying to config. this macro to meet my condition but cant seem to get it to work. The ...
  A: but it is appreciated when people do. At no point in your macro have you set a default condition – ...
userforms-find and edit info11/18/2009Aidan Heritage
  Q: My office works with specific job folders, each one with a unique job number. I need to keep a ...
  A: I’m slightly concerned that this is being done in excel as it SOUNDS as though it may need to be ...
excel solver11/18/2009Bob Umlas
  Q: I need help figuring out how i am going to do this - please help me - not sure what to put in solver ...
  A: Yes. put this formula in E3 & fill down: =C3*D3 put this in E7: =SUM(E3:E6) Set solver so that the ...
merging data in Excel11/18/2009Tom Ogilvy
  Q: I have two spreadsheets with lists of part numbers and some data. I would like to check if a part ...
  A: Trevor, I tested all parts of the formulas with the sample part numbers your provided (having the ...
Spreadsheet layout design11/18/2009Aidan Heritage
  Q: I am seeking resources which will assist me to understand the elements of efficiently designed ...
  A: http://www.google.co.uk/search?hl=en&q=spreadsheet+design+best+practices&meta=&aq=2&oq=spreadsheet+d ...
Icon Sets11/18/2009Aidan Heritage
  Q: I have added Icon sets (flags) to given formula results that equate in percentages. I.e. H9 = g9/f9 ...
  A: I assume you have used data validation to achieve the colours - I would do this by having TWO levels ...
Pulling certain data cells from multiple Excel files11/18/2009Tom Ogilvy
  Q: Tom, This is my first visit to this site and I see it as a quite valuable learning place. My ...
  A: Kim Hillard, When I typed it into excel yesterday, I put in C129 three times as a place holder ...
Reseting numberous cells back to zero11/18/2009Bob Umlas
  Q: I have a Worksheet (calculator) on my website that projects my clients ROI, but how do you reset the ...
  A: select all the cells you want to reset to 0 (ctrl/click), then insert/name/define and give a simple ...
merging data excel11/18/2009Bob Umlas
  Q: I have two spreadsheets with lists of part numbers and some data. I would like to check if a part ...
  A: Before you can get this to work you MUST make the part numbers identical in content and text/number, ...
merging data in Excel11/18/2009Tom Ogilvy
  Q: I have two spreadsheets with lists of part numbers and some data. I would like to check if a part ...
  A: Trevor You work should be done from sheet A. Sheet A has to look at sheet B to see if there is a ...
Removing Links11/18/2009Bill
  Q: I have an excel macro that opens the Word application and copies an excel file into a word document ...
  A: Why not just not run the macro since that all the macro does, from what you said. Or, alter the ...
Countifs non-null values11/18/2009Stuart Resnick
  Q: I am working on a spreadsheet involving Countifs formulae, I am aiming to count cells that match two ...
  A: Example: you want a count of how many cells in Actu!$A$5:$A$127 are equal to 'Q on Q'!$B40... but ...
autofill in a macro11/18/2009Tom Ogilvy
  Q: I am trying to get get a macro to enter a formula in the last column of a worksheet -done! and then ...
  A: Marcia, This worked fine for me. I headers in row1 out to BA1 I had data in column 1 down past ...
formula11/18/2009Stuart Resnick
  Q: Tried this code: Dim date1 As Date Dim date2 As Date date1 = ActiveCell.Offset(0, 1).Value date1 = ...
  A: You are defining date1 and date2 relative to the activecell. So the value of Format((date2 - ...
Multiple Y axis11/18/2009Richard Roberts
  Q: i want to know whether is it possible to have more number of Y axis in a single graph with different ...
  A: Shimjith I am pretty sure you can have more Y axis, but I do not know if you can have different ...
select item dropdown list and copy a value 211/18/2009Tom Ogilvy
  Q: Apparently I asked too many follow-up questions, so I had to ask a new follow-up question this way. ...
  A: Bert, this does what I understand you to want: Private Sub Worksheet_Change(ByVal Target As Range) ...
Findnext highest value11/18/2009Tom Ogilvy
  Q: I have a list of employee numbers in sheet 1 column A - There are duplicate values in the list. I ...
  A: Warren, Put you data in A1:A1000 ' In B1 put in this formula: ...
Left Lookup11/18/2009Jan Karel Pieterse
  Q: I have 2 columns of data Column A with Student Names Column B with Locations E.g Column A Bob Doug ...
  A: I think the easiest way to do this is by using a pivot table. I put a row above the data, with ...
Excel11/18/2009Aidan Heritage
  Q: I am attempting to create an excel worksheet that will allow inputs on one page, such as the name, ...
  A: I’m not sure I follow the requirement for the sets etc – but it SOUNDS as though you will need VBA ...
excel solver11/18/2009Miguel Zapico
  Q: I need help figuring out how i am going to do this - please help me - not sure what to put in solver ...
  A: You can use the column D to record the quantities, and then use a formula like this on E1, for ...
Word VBA11/17/2009Aidan Heritage
  Q: I have an excel macro that opens the WOrd application and copies an excel file into word. I would ...
  A: Not sure what the document is actually doing with regard to the copying across, but something like ...
Pulling certain data cells from multiple Excel files11/17/2009Tom Ogilvy
  Q: Tom, This is my first visit to this site and I see it as a quite valuable learning place. My ...
  A: Kim Hillard, the problem is that a line of code is missing - while I distinctly remember putting ...
merging spreadsheets11/17/2009Aidan Heritage
  Q: I have 2 spreadsheets and each one in column A has an ID that I want to match up. Worksheet #2 has ...
  A: Two step process I think – the first is to get the data across to worksheet 1 which you can do with ...

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


Questions by
Active Experts:
Nathan HeadChad WelchPhilip Buckley
Tushar SakhalkarBhaskarAmal
Damon OstranderGyula GulyasStuart Resnick
Bob UmlasEdward H. MoriJessica L.
Jan Karel PieterseAidan HeritageTom Ogilvy
Richard RobertsRichard StephensCraig
Adelaide carvalhoMiguel ZapicoJP
Douglas M. SmithRichard RostKen Marron
Victor LanBillAnne Troy
Claire Blinman  

Email this page
     
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
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2006 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.