You are here:
Excel/Tom Ogilvy
All Reviews from Users
Column Headings: K = Knowledgeability C = Clarity of Response T = Timeliness P = Politeness
N = Nominated for Expert of the Month
| Date | User | K | C | T | P | N | Comments |
|---|---|---|---|---|---|---|---|
| 2009-11-24 | marcia | 10 | 10 | 10 | 10 | Yes | YOu have been teriffic hep to me - many thanks for your time. |
| 2009-11-24 | Andy | 10 | 10 | 10 | 10 | Yes | Thank you, this was exactly what I have been looking for |
| 2009-11-24 | steven | 10 | 10 | 10 | 10 | No | Thank you for your help and sorry if I was not clear to begin with it was late and I had been strugling with this for nearly a day. Your solution has help me alot and thank you for the links they have been bery helpful. Many thanks steven |
| 2009-11-23 | Apple | 10 | 10 | 10 | 10 | No | thank you tom! such a great help. :) |
| 2009-11-23 | Steven | 10 | 10 | 10 | 10 | No | |
| 2009-11-23 | Tony | 10 | 10 | 10 | 10 | Yes | Brilliant!! |
| 2009-11-23 | Claudia | 10 | 10 | 10 | 10 | No | Thank you :)) |
| 2009-11-21 | Angela | 10 | 10 | 10 | 10 | Yes | This response was closer to what I am looking for, but not exactly what I am looking for. But response was clear and understandable. |
| 2009-11-21 | Michele | 10 | 10 | 10 | 10 | Yes | Hi Tom Thank you for the quick response. Your assumption on the column being identified as it is the only column selected was spot on. I am sorry my post left a lot to assumption. I applied your code into my macro and it works perfectly. Many thanks for your help with my problem. Kind regards Michele |
| 2009-11-20 | Hans J Hamm | 10 | 10 | 10 | 10 | Yes | Tom...dead on! I thank you very much for your help and time once again....Hans |
| 2009-11-19 | Warren | 10 | 10 | 10 | 10 | Yes | Thanks Tom, Worked great! I will take a bit of time to work out how it works for next time. I'm sure I'll be able to figure it out :) Thanks again Warren |
| 2009-11-19 | Sujan | 10 | 10 | 10 | 10 | Yes | Thank you once again for a timely and fabulous answer! This is how it looks now(certain factors made me change it hence): Sub GetTitle() ActiveSheet.Unprotect "inout" Dim r As Range, r1 As Range, res As Variant With Worksheets("In&Out") Set r1 = .Cells(ActiveCell.Row, "F") ' reference to cell to receive title Set r2 = .Cells(ActiveCell.Row, "H") ' reference to cell with barcode End With With Worksheets("List") Set r = .Range("A2", .Cells(Rows.Count, "A").End(xlUp)) ' reference to barcodes column in List End With ' to search for the value in D, then use r2 instead of r1 res = Application.Match(r2, r, 0) ' find the matching barcode If Not IsError(res) Then ' this should be r(res) rather than r2(res) r1 = r(res).Offset(0, 6) ' get the title from column G of the matching row Else MsgBox "Not found" End If ActiveSheet.Protect "inout" End Sub |
| 2009-11-18 | Trevor | 10 | 10 | 10 | 10 | Yes | Thanks Tom will give that a go now, looks good Regds Trevor |
| 2009-11-18 | Kim Hillard | 10 | 10 | 10 | 10 | Yes | Tom, Thanks so much for the timely responses to my questions. The revised code runs flawlessly and gives me exactly the data I was looking for. I now have a very valuable data collection that shows the trends in our products. I have learned a little something during this from you and that is a good thing. Best regards, Kim |
| 2009-11-18 | marcia | 10 | 10 | 10 | 10 | No | Tom was even better than 10 - he responded quickly and patiently even when i asked a really silly question due to my own nievity....tom you are a gent and a brilliant VBA expert...many many thanks... |
| 2009-11-18 | marcia | 10 | 10 | 10 | 10 | No | sorry - ignore followup quetion - just being really dim....I made the correct addition and of course it works perfectly...sorry |
| 2009-11-18 | Bert | 10 | 10 | 10 | 10 | Yes | Thank you very much for your fast response!! You will see that I asked a new follow-up question, mainly because my question wasn't clear. So I hope you can solve my problem now?! Thanks!! |
| 2009-11-17 | Ana | 10 | 10 | 10 | 10 | Yes | VEry helpful.. thanks! |
| 2009-11-17 | Donald | 10 | 10 | 10 | 10 | No | I have not tried the solution yet, but it looks very clear. I am very grateful for your insight. I will message with a result. Many thanks. |
| 2009-11-16 | Bob | 10 | 10 | 10 | 10 | Yes | Wow! I was VERY impressed with the fast and precise response. Please contact me if you are interested in doing some freelance paid work for us. |
| 2009-11-16 | Chris | 10 | 10 | 10 | 10 | Yes | That seems to work! You are AWESOME! Thank you. |
| 2009-11-16 | Jim | 10 | 10 | 10 | 10 | Yes | Mr Ogilvy was very helpful and was very timely in his response. |
| 2009-11-16 | Per | 10 | 10 | 10 | 10 | Yes | Exellent - thanks a lot Per |
| 2009-11-16 | Sam | 9 | 9 | 9 | 9 | No | Hi Tom, Your Data Validation List Box macro solution works Great! Your time and assistance is very much appreciated. Thank you. Cheers, Sam |
| 2009-11-15 | Emre | 10 | 10 | 10 | 10 | No | |
| 2009-11-15 | Liliana | 10 | 10 | 10 | 10 | Yes | Thank you once againg for the code, it worked straight away! Also your explana tions were very useful. |
| 2009-11-15 | Joshua | 10 | 10 | 10 | 10 | Yes | thank you very much, tom! |
| 2009-11-14 | IAN | 10 | 10 | 10 | 10 | Yes | Perfect answer, clear explanation & exaamples - thanks very |
| 2009-11-13 | John | 10 | 10 | 10 | 10 | Yes | |
| 2009-11-13 | John | 10 | 10 | 10 | 10 | Yes | Tom, you've delivered time and time again! Many thanks! |
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
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
Answers by Expert:
- Nathan Head
- Chad Welch
- Philip Buckley
- Tushar Sakhalkar
- Bhaskar
- Amal
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bob Umlas
- Edward H. Mori
- Jessica L.
- Jan Karel Pieterse
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- Craig
- Adelaide carvalho
- Miguel Zapico
- JP
- Douglas M. Smith
- Richard Rost
- Ken Marron
- Victor Lan
- Bill
- Anne Troy
- Claire Blinman
Tom Ogilvy
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.