| Subject | Date Asked | Expert |
|
| Code that displays the Date at which a cell/cells Changed. | 11/20/2009 | Tom 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 VBA | 11/20/2009 | Tom 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 inputbox | 11/19/2009 | Tom 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 sender | 11/19/2009 | Aidan 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 worksheet | 11/19/2009 | Miguel 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 Macro | 11/19/2009 | Bill |
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 tables | 11/19/2009 | Aidan 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 button | 11/19/2009 | Aidan 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 Hyperlinks | 11/19/2009 | Stuart 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 updating | 11/19/2009 | Jan 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 others | 11/19/2009 | Bob 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 Protection | 11/19/2009 | Bill |
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 formula | 11/19/2009 | Stuart 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 rows | 11/19/2009 | Bob 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 others | 11/19/2009 | Bob 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 formula | 11/19/2009 | Chad 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 solver | 11/18/2009 | Aidan 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 Save | 11/18/2009 | Aidan 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 info | 11/18/2009 | Aidan 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 solver | 11/18/2009 | Bob 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 Excel | 11/18/2009 | Tom 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 design | 11/18/2009 | Aidan 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 Sets | 11/18/2009 | Aidan 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 files | 11/18/2009 | Tom 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 zero | 11/18/2009 | Bob 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 excel | 11/18/2009 | Bob 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 Excel | 11/18/2009 | Tom 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 Links | 11/18/2009 | Bill |
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 values | 11/18/2009 | Stuart 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 macro | 11/18/2009 | Tom 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 ...
|
| formula | 11/18/2009 | Stuart 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 axis | 11/18/2009 | Richard 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 2 | 11/18/2009 | Tom 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 value | 11/18/2009 | Tom 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 Lookup | 11/18/2009 | Jan 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 ...
|
| Excel | 11/18/2009 | Aidan 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 solver | 11/18/2009 | Miguel 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 VBA | 11/17/2009 | Aidan 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 files | 11/17/2009 | Tom 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 spreadsheets | 11/17/2009 | Aidan 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 ...
|
