 |
Rodney,
...
Thanks for your help!
- Kevin Cunningham [Compass Bank]
|
| |
Rodney,
I’ve used your site and it’s examples for clues to my projects for years. The site is laid out beautifully; it is clean, and concise.
...
Thanks
- Mark Trevithick,
|
| |
Last Excel Row - Thanks!
You rock.
- Bill
|
| |
Thank you! Thank you! Thank you! I've been searching for this technique for years (being a reasonably clever Excel hack but hardly an MVP). I just knew there had to be a better way than the xlUp from the bottom, which requires knowing the longest column or testing all of them in the known column-range.
Very much appreciated!
Regards,
- Peter Straton [Symantec]
|
| |
are awesome
this saved my life
=OFFSET(MySheet!$A$1,0,0,COUNTA(MySheet!$A:$A),1)
THANK YOU
- Steve Brooks
|
| |
Howdy,
Great web site. I really appreciate the clear and logical way you explain how functions, formula’s etc are processing their logical steps. I wish Microsoft help was as clear and effective as yours.
...
Have you written any books? There are lots of great ideas out there on the net. Sample formula's, user defined functions etc. the issue with most of them is they are difficult to decipher for the layman. You do a great job of that. You may consider writing a book or even hunting for the great techniques, then posting them on your site with your clear and plain way of explaining what is going on.
- John Engelmann [U.S. Air Force - contractor]
|
| |
Rodney,
I was reading your site and it is a great help to so many people . Thank you.
- Travis Weaver
|
| |
Rodney:
I am nowhere near the Excel guru that you or Bob Umlas or John Walkenbach or Chip Pearson can claim to be. I am the Excel go-to guy for my office.
And I couldn’t have done my latest critical project without your help. Thank you for the "Identifying the Real Last Cell" tip.
Best wishes,
- Geoff Lilley [Pearson] Sacramento, CA
|
| |
Hi Rodney,
Your article on shrinking spreadsheet bloat was fantastic and VERY helpful.
- VL Vawter
|
| |
Hey,
I just checked your site. It is good. You have described the things very well.
Regards,
- Ravi Sagar India
|
| |
Rodney,
Just a quick thanks - nice site.
- Cam Howie [Lake Erie Steel Works] Canada
|
| |
EXCELLENT
Thank you,
- Mark Stinson [Lockheed Martin]
|
| |
Rodney,
I stumbled across your geat Excel tips and techniques and found at least two formulas that will help me.
- Mike Connolly Phoenix, AZ
|
| |
Hi, I purchased your breakeven analysis guide with Excel sheets. It was a big help ...
Sincerely,
- Sherilyn McGah
|
| |
I am writing you, first of all, to thank you for teaching me through your Web site to work with VBA for Excel. I've been developing an application of post processing data from reports of Power Quality and, even without knowing each other, your knowledge was very helpful for me and my workmates.
Sincerely,
- Igot Ferreira Visconti Brazil
|
| |
Rodney--
Fantastic job with the site ... I've been using it for two weeks and it has really, really added to my knowledge of Excel and VBA ... Anyway, keep it up.
- Nat Arem
|
| |
Hello Rodney, I was looking at your examples that you provided and they are very helpful ... Much Thanks!
- Erika Ramirez [U.S. Department of Agriculture]
|
| |
Rodney,
Great site. It has been very helpful.
- Andy Male
|
| |
You gave the answer when the MS Help gave nothing - THANKS!
- Marjorie Kolkin [Compass Systems & Programming] Exeter, NH
|
| |
Good morning! Your site is very professional and the content you provide gratis is useful even to advanced Excel users.
- Paul Gillespie
|
| |
I stumbled upon your web site and find it useful.
- David Cramton
|
| |
I have been avoiding performing standard deviation analysis for years. Your advise has greatly helped me understand the process. Thanks.
- Debra Gardner
|
| |
Hi Rodney,
...
I had found your site when searching through Yahoo ... the site is very well laid out and helpful.
- Bob Gowens
|
| |
Rodney,
...
Thanks for the web page. I found it very helpful.
- Guang Tong
|
| |
Hi Rodney
I am now using the drop down list you described on your site. Thanks for that.
...
Cheers,
- Iain Smith United Kingdom
|
| |
Rodney,
Randy Hayes and ExxonMobil - just wanted to say thanks again for the e-mail list of possible MS Access assistance. I've placed the e-mail in ExxonMobil's database folder. For now we are waiting for the IT department to decide what they are going to do (or not be capable of doing).
Anyway, I greatly appreciate your help yesterday.
Best Regards,
- Randy Hayes [Kellog Brown & Root] Houston, TX
|
| |
Hi Rodney,
I'm enjoying your website with all the spreadsheet formulas ...
Thanks for your help,
- Anthony
|
| |
Hi my name is Thomson and I found the tips on your Excel sheet very interesting.
- Thomson Mathews
|
| |
Hello Rodney:
I've enjoyed your helpful hints and tips ...
- Gerry Fitzgerald [Halliburton]
|
| |
Thanks for the magnificent tip of dynamic validation list ranges ! I was searching for this for years and finally I have it now.
...
thanks:
- Ivan Fenyves Johannesburg, South Africa
|
| |
Hi there,
I was interested in your little article related to Dynamic Named Ranges, which leads me to ...
Cheers,
- Jim Carter Australia
|
| |
Rodney,
Thank you for your web site. I love it. Not only is it relevant, but it presents the topics within context!! This is a tremendous time saver and where the real learning takes place.
- David DeLancey
|
| |
Thank you so much for this information!!
Love this web site. I really need to understand VB and this website has been great fun!! and useful.
I just need all kinds of tips. Generally, I'm new at VB and trying desparately to use it for data collection work. ... I like your website ... it's been very helpful to me.
- Joan Sibbitt [Motorola]
|
| |
Hi Rodney,
Love your website! ...
- Lindy WIlliams [Vodafone] Australia
|
| |
Your website has been of greate help. I was delighted to find your charting procedures for dynamic data ...
Thank you,
- David Noto
|
| |
Dear Experts,
... This is such a great website ...
- Sue
|
| |
I must begin by saying your Tips make my Internet browsing worthwhile. Keep up the good work. I promise to keep you in mind for any future projects, etc.
- Ravi Korlahalli [ANCA Pty Ltd.] Australia
|
| |
Rodney,
Your 'power tips' have been a lifesaver for me. I found your website through a link in the Microsoft Office web page and have already found answers to two frustrating problems I've had.
Thanks for this service, it has truly been helpful.
- Starla Vigil
|
| |
I was looking online for an anwer to an Excel question and came across your site. Very impressive!
- Richard Murray [Carrier Sales]
|
| |
I am a management consultant for a Swiss company. Your web site tip on converting dates to quarters was very helpful and well written. We appreciate it!
Many Thanks,
- Neal Mueller
|
| |
Rodney,
Thanks for your vast pool of wisdom and rapid response to my plea for help. You came through for me with your solution to my problem ...
- Mark Usher [Global Technologies, Inc.]
|
| |
Greetings,
I just wanted to say thank you for the wonderful Excel help site.
I spent over a day looking for Excel help on the Web and then I came across your site, which is a godsend. I've been through the "spreadsheet power tips" and "getting to know VBA" and I'm into the "for geeks only" section now.
Thanks Again,
- Natasha Drake [Chaucer Digital]
|
| |
I visited the Beyond Technology web site and found it to be extremely helpful.
I've been using the power user tip that allows you to reference the most recent entry in a list ...
...
Also, aside from what is offered free on the website, does Beyond Technology offer any courses or manuals that would teach me VBA ?
- Chris Hudson
|
| |
I happened to see your site accidentally. A quite informative one, especially on VBA.
Could you please add me in your mailing list for tips on Excel.
- Balaji Ranganathan
|
| |
Rodney,
Your web site is excellent.
- Trevor McCarthy [BP Amoco] Queensland, Australia
|
| |
Thank You for your help.
...
Again thanks for your help. I learned something useful.
- Rick Parkinson
|
| |
Thank you and great website. I can't wait to actually use some of the information (I just discovered the site today!)
- Kenn Sturgis [K Hovnanian Mortgage, Inc.]
|
| |
Strong Work
Really nice website. Great tips, clean design, easy navigation.
Thank you for the time and energy you put into this site.
- Scott Davis
|
| |
Neat interface. I have gotten a book about making stuff with Microsoft Agent and had hoped to go into business.
Your interface is the most developed I have seen (you use the correct gestures in the correct contexts, etc.) Not that I am an expert or anything!
Anyway, it would be good if you would make Peedy a real interface, like allowing me to navigate the site with him... Good job!
P.S. Could you e-mail me if you update it? I would like that! Thanks!
- Shawn Boles
|
| |
Rodney -
I appreciated your dynamic named range explanation ...
- Jim Shoenfelt [AmTrust Services]
|
| |
Rodney:
First, I'd like to express my thanks for your clear explanation on how to apply drop down list boxes into Excel. It's been a great help for me.
It's a source of pride to find out you are a neighbor, living right down the street in Spring - Klein area here in Harris County.
...
Thank you for your kind attention.
- Art Montemayor Spring, TX
|
| |
Rodney
I really appreciate what you have done with your website. I wish you would write a book. Until today, only John Walkenbach could write so I could easily understand.
Thanks
- John Augustein
|
| |
I stumbled onto your site and I think it is awesome!!
- Paul O'Connor Canada
|
| |
Thanks for the wonderful tips on using array formulas.
- Carol Maharaj [Litton]
|
| |
Thank you, thank you, thank you!!! I've looked high and low for a way to easily compare lists!!! And there it was on your page in simple English.
Great site; definitely bookmarked for me now!!!
- Tracey Peck [DigiScript, Inc.]
|
| |
Hey,
You probably receive thousands of that type of mail every day, but still ... I recently took on VBA for Excel on my own, so just wanted to tell you that your site is by far:
1. the most comprehensive
2. the most useful in terms of tips and tricks
3. the best laid-out and neat and ergonomical
4. the most professional-looking (well, not surprising...)
Way to go!
It definitely gave me new food for thought as far as career aspirations go.
- Vladimir Popov Australia
|
| |
Rodney,
I read your solution to charting dynamic data and found it very interesting. ...
Thanks,
- Paul Watson
|
| |
My boss came to me this morning and asked for a row of weighted averages. I had never done this before, so how happy I was to find your site immediately and within 10 minutes I had the whole spreadsheet ready for print-out. Thank you for being there and for being so clear and easy to understand.
- Mary Morrison
|
| |
I was looking for a way to find the used range in an Excel sheet. Your example worked perfectly.
- Steven Martino [American Financial Systems, Inc.]
|
| |
Hi Rodney,
First, I must really commend you for your site provides some of the most valuable tips to Excel fanatics like myself. Thank you for that!
...
Many many thanks!
- Ace Eagle
|
| |
Rodney,
I am a regular visitor of your website. I like if very much, My Excel capabilities have been growing as a result of that.
- Gerard Thijssen [KEMA T&D Consulting] The Netherlands
|
| |
Dear Rodney,
You are a blessing to the millions of people searching for Excel solutions, I enjoy your site very much. The presentation is great with least download problems.
Keep up the good work!!
...
Thank you once again for the great tips on EXCEL POWER.
Best Regards
- Vino Joseph [TotalFinaElf] Dubai
|
| |
Hi Rodney,
I visited your site and I am quite impressed ...
- Greg McDonald [Ingersoll-Rand] Huntersville, NC
|
| |
Your clear explanation is much appreciated! Do you have similar livesavers for Access?
- Jane Hunter
|
| |
Thank you for the Excel tip on preventing duplicate entries. ... a nice simple solution that will help me with some inventory control.
- Brian Fisher
|
| |
... I found your web page and what great information ...
- Gerri Johnson
|
| |
How about class modules for mere mortals?
Just a suggestion. Enjoy your tips.
Cheers,
- David Phares [Borland]
|
| |
Hi Rodney.
I appreciated the newsletter and all the highly useful information you hand out freely on the web site. I've gotten a lot of mileage out of it. I just received the November newsletter this a.m. and read the article about using the list/validation drop-downs. I have gotten a ton of use out of that feature.
- Curt Smith [Black & Veatch] Orlando, Florida
|
| |
I was looking at your site and see that it has a lot of very useful information ...
- Dean Sandvig [Kimberly-Clark Corporation]
|
| |
I use several named ranges in a workbook that I use for scheduling at work. These ranges change constantly due to new orders being added and old orders being closed. This required me to be diligent and continually make certain that the ranges were correct. If others made changes to the sheets, they would invariably become invalid. I have made every named range a dynamically named range now which will save me hours of work.
I have additionally put the last cell code to work in my modules with great success.
Great site with excellent code samples. Thank you for sharing!
- Mark Trevithick
|
| |
RE: Standard Deviation in Excel Spreadsheets
I was stuck looking for the correct formula (procedure) to duplicate the Excel StDev formula. We're migrating some things from Excel to VB that required it. Your document explained it quickly and completely.
Thanks a million,
- Mary Whittington [ADN]
|
| |
Excellent newsletter. Please keep it coming. I send referrals to my students.
...
- Kimberly Mills [Aries Training Associates]
|
| |
Hello:
I have been just recentyl introduced to this site and already have learned a
great deal. Keep up the good work.
...
- anonymous
|
| |
I stumbled on to your web site by accident. I needed to know how to calculate a weighted average. Your example was easy to use and was very helpful. Thank you for providing such helpful information. Keep up the good work.
- Mark Perez
|
| |
First of i am very thankful to you. I am very pleased to see your site. It helps the people to a great extent.
...
- Hashmat Kakajee
|
| |
First of all thanks for some great tips, I've found lots of handy things on the site.
...
- Raoul Federman [Heron Corporation] London, UK
|
| |
I have visited your site several times and I think it's very usefull for me, because I've learned a lot of things.
...
Saludos!!!
- Adrián Cerda Rodríguez [Frito Lay] Monterrey, México
|
| |
Thanks Rodney,
I do not know a better way but just wanted to write to say thank you. Your tip on cleaning up the ActiveSheet.UsedRange enabled me to shrink my "have a cup of tea while the spreadsheet opens" 13 GB spreadsheet in half.
Have a good day.
- John Slobodnik
|
| |
... I do want to thank you for the great resourceful website.
Best Regards,
- Yee-Bien "Aimee" Chuah [David Weekley Homes]
|
| |
Did a great job of explaining the drop down list. ...
- Bill Vidacovich
|
| |
Hello Rodney. I have picked up very useful tips from your website. Many thanks. ...
- Chuck Harkes
|
| |
...
I did look through your site and really like the information that you provide!
...
- Joe Witte [PG&E National Energy Group]
|
| |
Congratulations for the web site : design and content are equally outstanding.
Regards from beautiful Belgium,
- Hervé Hanuise [Affordable Solutions] Belgium
|
| |
Hi there - I am hoping that you may be able to assist me. I am sure you can
as I have often found that Beyond Tech is the best Excel resource out there.
- Matthew Maule
|
| |
Firstly, may I say congratulations on your site - it contains may useful tips. ...
- Ananda Gunasekera Australia
|
| |
Dear Mr. Powell,
Thank you very much for your kind help with my Excel VBA problem. I will
use your find final cell code. (I am pleased to say I at least had
figured out the end xlUp approach.) Also, thanks for the newsletter
subscription. I will definitely spread the word.
- John G. Scott [Predictive Systems, Inc.] Roswell, GA
|
| |
Is awesome
Thanks for the tip!
- Jason Cumberland [KPMG Consulting]
|
| |
Thanks for providing some great examples of Excel's advanced capabilities!!
|
| |
Thank you for your updates.
...
- Loretta Melnychuk [ExxonMobil]
|
| |
I love your site. Thank you.
Regards & Best Wishes,
- Roman Mesina [Windward Capital, LLC]
|
| |
Rodney,
Rodney, your help on adding time values was invaluable to me ...
...
Thanks
- Kris Wright
|
| |
Hi Rodney,
I would like to thank you for your quick response and very helpful information.
It's nice to get feedback from someone in the industry.
Thanks again - All the best,
- Patrick Murphy
|
| |
Ladies & Gentlemen,
Great site you have there.
...
- Russell Williams
|
| |
Rodney,
I love the web site, only found it today but made use of your dynamic named ranges immediately. Thanks VERY MUCH.
...
Keep up the good work.
- Doug Gaynor [PricewaterhouseCoopers BPO]
|
| |
Good morning Rodney,
Thank you for the tips they prove to be v. handy
...
- Karin Wightman
|
| |
Rodney,
Thanks for your Excel tips. Every month I learn at least one thing new.
...
- Scott Haralson [America West Airlines]
|
| |
Hi Rodney,
First off, I want to tell you how helpful your newsletter is. Every time it comes out, I seem to find a little tidbit that helps me in my VBA.
...
- Kenton Leo
|
| |
Gentlemen:
I had a problem trying to add time values over 24 hours. I consulted several people about the solution to this problem. I even bought a Complete Guide for Excel, without getting the answer.
It just took 1 minute to go over your site and found the solution.
Please accept my thanks for this wonderful service.
Yours very truly,
- Sergio A. Rodríguez M. Panamá, Republic of Panamá
|
| |
Hello:
I appreciate your tips on Excel. They have been very useful to me.
...
- Doug Gaynor [Carson Oil Company]
|
| |
Hi,
I just wanted to say thank you for your Excel tips. I appreciate the free help very much.
Sincerely,
- Steven Gravino
|
| |
... Keep up the great work.
Regards
- Alex
|
| |
Thanks for the quick response. This does work! ...
- Dr. Don Scavia
NOS Chief Scientist and Director, National Centers for Coastal Ocean Science
[National Oceanic and Atmospheric Administration (NOAA)]
Silver Spring, Maryland
|
| |
Thanks.
I think I got it.
- JR Wehrmeister
|
| |
Thank you for the updates.
- Michael Boyd [ATLIS Systems]
|
| |
Hello,
I get your news letter and enjoy seeing all the cool VB stuff. ...
- Peter McAlenney [MFG, Inc.]
|
| |
Thank you and I look forward to your mail. ...
- Dan Sasser [Universal Corporation]
|
| |
... love your work
- Kitch Morris
|
| |
Thanks for a good site!
Sirs,
I have been reading pages from your vba site. it's a good source of reference.
Regards,
- John Maclean
|
| |
Great article on a neat feature (dropdown listbox). ...
- Vernon Huff
|
| |
Dear Sir,
I have expanded my colleagues' and my knowledge enormously with the help of your tips.
Keep up the good work. Thanks from all of us.
- Abe Meir
|
| |
Thank you very much. ... This will be easy now.
- John Stec
|
| |
These tips are useful - the best one was on how to sum a range of cells containing #N/A
Many Thanks
- Norman Marshal [McKinsey & Company]
|
| |
Rodney
Thank you very much for your prompt reply . It's working for me now and (as you said) it's unbelievably fast.
Best Regards,
- Alon Othnay [Johnson & Johnson]
|
| |
Hi Rodney
Great code you make for getting data out of closed workbooks.
...
Thank you for making this all available to us.
- Ron de Bruin
|
| |
...
Thanks for the info. I'll show your website to my MBA decision support
modeling class this spring semester.
- Leon Lasden [UT Austin Business School, MSIS] co-author of the Excel Solver
|
| |
Dear Sir:
I have subscribed to your newsletter. It's very useful. I've read "SQL for...." and it's very easy for understanding. Thanks
...
- Nancy Godoy
|
| |
...
I enjoy your newsletters and look forward to more tips.
Thanks.
- Nick Feller [Feller Consulting] Englewood, Colorado
|
| |
Thank you for putting together such an information, extremely useful website for Excel and VBA. There is no time at work to go "beyond" the tasks that we use everyday and even though we know there must be a better way - we do not have the luxury of spending the time to figure that better way out. I will keep looking at the great information you are publishing and continue to look beyond the box.
- Pat Miltz
|
| |
Hi Guys
Love your useful excel info.
...
very much appreciated
- Amanda Askew Australia
|
| |
Hi Rodney. I appreciate the newsletter and all the highly useful information you hand out freely on the web site. I've gotten a lot of mileage out of it. I just received the November newsletter this a.m. and read the article about using the list/validation drop-downs. I have gotten a ton of use out of that feature.
...
Regards,
- Curt Smith [Black & Veatch] Orlando, Florida
|
| |
Information on the Beyond Technology site is superb! Compliments. ...
Greetings,
- Anonymous
|
| |
Greetings Beyond Technology;
Just thought it was time for me to say "Thank You" for your excellent work.
I must say I don't remember what I did that got me on your mailing list a year ago or so but I'm glad it happened. I'm not a killer-geek "power user" but I need Excel often enough and I depend on it.
You've provided some excellent learning material over the duration. I appreciate it.
Best Regards
- Kevin Meagher
|
| |
Hello Mr. Powell,
Thank you for your valuable Excel Tips. They are great!
...
Thank you for all of your help and a great newsletter.
- Claud Moore [Huntsman Corporation] Marysville, Michigan
|
| |
Excellent Page
- Marcos Oyola [PB International]
|
| |
Hi Rodney,
I admire your contributions and the entire site!
...
Thanks alot!
- Sam ElAssaad Santa Clara, California
|
| |
[One of the best sites I've come across]
Thanks so much for building a site that has more use and meaning with an easy layout and functionality!!
- Laurie Hare, B.Sc., MBA, QI
|
| |
Hi Rodney
First of all I would like to thank you for the real good excel tips! they are really useful.
...
Regard
- Subodh Gupta
|
| |
Rodney...
Like the useful VBA stuff on your site...
- R.J. Harrison
|
| |
I am new to VBA and medium skilled at MS Excel.
I have purchased a book recently to learn and increase my knowledge.
I have also visited many on-line sites to broaden my education on the issue.
I came across your site while browsing and I wanted to let you know it is awesome.
I learned more in the half hour I spent at your site than the "numerous" hours I have spent reading books and browsing other sites.
Not only did I add your URL to my Favorites, I put the shortcut on my Desktop
[Just to let you know, that is considered a great honor in my world :) ].
- Joe McFarland [TeleTech] Denver, Colorado
|
| |
Great to hear from you again! These tips are always a great help, Thank you.
- Timothy Furguson [K2 Corporation]
|
| |
Dear Rodney
First of all let me thank you for the great website you have, it's a great help for people like me who know very little about Excel.
...
Thanks
- Deepak Ahuja [KFS, Inc.]
|
| |
Hi!
Your SQL for Mere Mortals series has been very helpful! How long do I have to wait for parts 3, 4, 5? Is there any way I can get it in advance?
Thanks and keep up the great work!!
- Paul Plodzien [General Motors Corporation]
|
| |
I must admit, I hadn't used this much up 'til now. Your example {Select Case Structure} makes this an obvious choice.
Thanks and All the best
- Ron Anderson [Comet Group PLC] Hull, England
|
| |
Thankyou!!!
- Charmayne Paul
|
| |
Figured I'd try out Teoma after seeing some press from C|Net. Let me here, and I'm glad it did. Great resource!!
- Dave Aust [Clearwire Technologies]
|
| |
When searching the net for some help I found it right on this page and much more !! ... great
- Roger Van de Craen [FBFC International NV]
|
| |
Thank You.
- Kitt Langkilde [After Hours]
|
| |
This is a wonderful service. Are back issues available?
- James Greene [JimCo]
|
| |
Heard about this from my college algebra professor who loves Excel and uses it like a wiz.
- Joanne Worcester [Law Dept.]
|
| |
The bit labeled 'geeks only' is probably the most useful bit and something anyone looking to do something a bit more complex should have a look at - not just 'geeks'.
- Andrew Fraser [Arup]
|
| |
This is a very interesting site for me. The way you explain every subject is easy for everyone. It's very useful for me this site. Thanks!!!
- Adrian Cerda [Sabritas, S. de R.L. de C.V.]
|
| |
Thanks for your tips.
- Antonio Morales [M Najar, SA]
|
| |
Great Site
- Wade McDowell [Rural Telephone]
|
| |
In 2 minutes this site helped me solve a function problem I have been working on for weeks at work! Thanks!!
- Dorothy Griffin [Patrick Henry Community College]
|
| |
Great site. I found the answers to questions I had within 5 minutes. The quarters calculation is very handy.
- Hamish MacPherson [ANZDL]
|
| |
Chance find - very impressive - two invaluable tips.
- Greg Marsh [Global Freight Exchange]
|
| |
VERY USEFUL
- Vidyapathy Na [Akmit]
|
| |
I searched for help re: how to start using VBA (in Excel). This site has been VERY helpful. Thanks!
- Allan Pentecost [Intel]
|
| |
The YTD-offset function was very helpful, thanks
- Marco Plandsoen [Fenestrae B.V.]
|
| |
Love your site. Very clean and easy to navigate and the information is superb. Keep it up.
- Charlie Price [Guardian Inspection S.A. DE C.V.] Mexico
|
| |
Found you while surfing -- I think you're wonderful!!
- Carol Welch [The Container Store]
|
| |
I was on your site today an thought that it was great!! Well done! I am an avid user of Excel and know the formulas and functions pretty well.
Thanks,
- Peter Karaffa
|
| |
Thanks for such great tips.
Congratulations on this quality, well-structured, user-friendly site.
Regards,
- Al DePalma [W.R. Grace]
|
| |
Wow, this is great information.
Many thanks for having this available. Easy to read and understand
- Sheryl Goad
|
| |
The department I work in had used Lotus 1-2-3 for years. I became proficient at writing macros in Lotus and when we were given Excel I had my doubts, however I have found that Excel is as good if not better.
Your site has provided me with many answers that I could not find elsewhere, I appreciate it since I do most of the vba programming for my department.
- Bob Smith
|
| |
Sir,
Thank you so much for your tip on the above. I use pivot tables extensively for my reporting and I found your tip on using dynamic ranges for my pivot tables a lifesaver.
I requested for tips on updating my pivot tables dynamically but no one provided anything half as simple and easy...
Thank you and God bless.
- Omar Bafagih
|
| |
Hi there Web Master
I have just visited your site and I am quite impressed with its details and offerings.
- Nathan Johnson
|
| |
Hi Rodney,
I like your site. It's well done and helpful !
...
Thanks,
- Russ Reimann
|
| |
Thank you for the tips. I was able to put them to good use immediately.
- Elisabeth Snyder [New York Life]
|
| |
Sir,
Thank you so much for your tip on the above. I use pivot tables extensively for my reporting and I found your tip on using dynamic ranges for my pivot tables a lifesaver.
I requested for tips on updating my pivot tables dynamically but no one provided anything half as simple and easy...
Thank you and God bless.
- Omar BafagihUnited Arab Emrites
|
| |
Hi Rodney
Thanks for the tip on ...... Links - Locating Bogus "Ghost" References. Went into the Define Names menu, and there it was staring me in the face!
Man that has been bugging me for ages (and my boss every time I send her a copy my spreadsheet to review!).
Cool site and cool tips for a HOT day.
- Ross PetherickLondon, UK
|
| |
Dear Rodney,
First of all, your site has transformed me from saying "What's a spreadsheet?" to the office excel guru.
Thanks! I have found your tip on using the standard deviation function quite helpful, but I need to take it further.
...
Sincerely,
- Ben Taylor
|
| |
Hi Rodney,
I like your site. It's well done and helpful !
...
Thanks,
- Russ Riemann
|
| |
Have you given any thought to publishing your tips in a PDF?
Excellent tips....thanks much for helping us all.
- G. Hancock
|
| |
Your advices are great
Thanks
- Niko Osolnik
|
| |
Thanks !
- Jailson Castilo [V.I.]
|
| |
Thanks for the fast response and the help you and your site help out a lot!!!
- Aaron
|
| |
Thank you
- Tamas Becsak [Honeywell Kft]
|
| |
... These are wonderful ...
- Kara Mullaley [Corning Cable Systems]
|
| |
Very helpful.
- Christina Au [Ngai Hing Color Technology Co., Ltd.]
|
| |
Site is good!
- Badri Srinivasan [Meenakshi Computers Limited]
|
| |
Dear Rodney,
I came about your Web site by accident the other day and was intrigued by the
capabilities that were outlined as possible within Excel ...
- Colin Lishman
|
| |
Your pages on Tips, VBA, and Geeks are well done and very helpful. Thank You
- Daniel Belisle
|
| |
Great site - thank you
- Monty Wood [Amber Business Computers]
|
| |
I like your site very much. It's not cluttered like so many (i.e. MSN). ...
- Charlie White [ELI Inc]
|
| |
The online tips are great. I'm looking into VBA as a new hobby/career development interest.
Thank you.
- Curtis Childers [Agribuys]
|
| |
Thanks Rodney, for your clear, step-by-step explanation of the Standard Deviation formula process.
I did a search on the subject and found several discussions, but NONE as clear and unassuming as yours. Thanks for the help in time of need.
- Charlie Michigan
|
| |
Wow I wish I would've checked out this sight earlier, instead of sitting
around for an entire day trying to develop my own dynamic range.
...
In other words excellent website!
- Carman DecellesCanada
|
| |
You've got some really good ideas there.
- Murray Clark
|
| |
The tips were very helpful so far on a complicated project for one of my clients. Thank you.
- Tony Worley [Computer Consulting] McAllen, TX
|
| |
This site is exceptional. I am interested in developing applications for
consolidation of financial statements in the future and I'm positive with
your tips I'll achieve my goal.
- Peter Lawrence [Lawrence & Associates]
|
| |
More Excel spreadsheet power tips - they're great!! Thanks!
- Angela Abruzzese [Capital Cargo International]
|
| |
Very interesting
- Enzo Spinaci [Focus Group S.R.L.] Italy
|
| |
I'm subscribing! Just fabulous. Your instructions and visuals make
everything so understandable. Thanks so much!
- Penny Maggio [Defense Supply Center Richmond]
|
| |
Thanks - this is great.
- Mary Pidgeon [BAS Analytics]
|
| |
Great looking site. Fantastic examples. Goes to the top of my recommended sites for VBA.
- Lee Hibbert
|
| |
Many thanks for making available the code that prevents this
(stopping the epileptic fit inducing screen update).
Tried it straight away and with possible updating of 25 columns of
data for 108+ staff for a year it saved loads of time.
Super site, grateful appreciation!
- Malcolm Wilbraham [PPA]
|
| |
Thank you, thank you, thank you.
I found this website that listed you as the person behind this clever end of month calculation.
That @&%! end of month problem has been eluding me for 12 years (that's how long I have been using Excel).
Thanks again
- Robin Burns [Universal Studios]
|
| |
Rodney:
Thanks for the advice and taking the time to answer. I really appreciate it.
- Will Perry, CPA [Bridgestone/Firestone, Inc.]
|
| |
Thanks for your help, I really appreciate it.
- Chris Acimovic
|
| |
Have you stopped presses? This is the last issue my self and others have
received, You got me hooked and the cut me off I'm going into withdrawal
here. If possible could you please send me the issues I have missed and get
me back on the mailing list.
Thank you
- Tim Ferguson [K2 Sports Corporation]
|
| |
This site is excellent! Kudos to Mr. Powell!!!
- Ed Destura [Eman]
|
| |
Rodney,
Thank you very much for this wonderful site ...
- Muhammad Dawood
|
| |
I am thankful for the data that you were able to provide me. It is of great help.
Thank you
- Joya Richardson [Liberty University - Student]
|
| |
Thanks for the weighted average explanation and examples ... it was TONS of help!
- Paul Plodzien [General Motors Corporation]
|
| |
I like what I've seen on your site and look forward to spending many
fun-filled moments exploring what Excel truly has to offer.
As a user with limited Excel skills, I look upon your site as a chance
for me to catch up and pass my fellow workers' skill- and trick-wise.
Thanks and I shall give you feedback and ideas if you would like.
Thanks,
- Simon Lipert [Eraring Energy]
|
| |
Great site. I was actually looking for a solution to find the last row. Thanks for all the tips.
- Sam Varadarajan [Covansys]
|
| |
I can use this to help with my books. Thank you.
- Danny Wilson [Dan's Apple Farm]
|
| |
Thanks for the excellent tips that this site offers for Excel Users.
- Reg Vaz [Business Solutions]
|
| |
Thanks for creating a site that allows someone who knows their way around a spreadsheet to learn something new.
I am 16, and there's not much that people can stump me on.
I have recently finished computing a stock market watch heavily using the IF, CHOOSE, and COUNTIF commands, and it would have made my formula checkng a lot faster had I have known about the ctrl + ` command.
Thanks again
- Craig Arthur
|
| |
Thanks I enjoy your input.
- Walter Goeken [R Goeken Farms]
|
| |
Thank you in advance
- Ian Grant Pitman [Project Economics International]
|
| |
This site is much more helpful than Microsoft's own Excel help utility. Thanks!
- Paul Mayes
|
| |
At your site reference http://209.127.129.225/vba.shtml I read "SQL of Mere
Mortals (Part 1 of 5)". Are the other parts available for reading?
I am very impressed with the great articles available on your site.
Thanks,
- Susan Knowles [Andronico's Markets, Inc.]
|
| |
Last night I went to bet thinking about my NEW problem (how to make
the #cells in the range be variable). This morning I searched
around, found your site, found Dynamic Named Ranges, and solved my
problem (scheduling tennis matches for Friday nights). I am sure
your site will be a tremendous asset to my night job.
Thanks,
- Phil Martineau [FNFB Tennis] Beverly, MA
|
| |
This site is really helpful.
- Joju Joseph [Mecklai]
|
| |
Thanks a lot for the help - looking to learn much more about VBA for Excel
- Alan Stigall [Creative Designs]
|
| |
Hello,
Just a quick e-mail to say thank you for the tips - they are easy to follow,
and have saved me a lot of time since I started reading them. The explanation
of the standard deviation was very clear and helpful.
Regards,
- Grant Humphrey [Ernst & Young]
|
| |
Great site, learning a lot. Thanks
- Paul Anceau [The HouseCoat Company]
|
| |
Hi!
...
I like this site. Cheers. Thanks.
- Kamlesh (KAM) Trivedi [Omnicom Services]
|
| |
This is good stuff for us novice Excel users who desire to become upper echelon users ...
- Patrick Bowland [Engage Energy US LP]
|
| |
Fantastic site !!!
- Armando Valdes [CT Corporation]
|
| |
Dear Sir,
I am impressed with your web site and Excel tips.
- Jagdish Shah
|
| |
Nice web page.
- Rafal Kacprzak [BRE Leasing]
|
| |
Teriffic!
I receive and use your tips at work - they are extremely helpful - and would like to receive them at home also.
- Bob Rodgers [Phelps Dodge Corporation] Morenci, AZ
|
| |
Rodney,
You have an interesting web site - I perused it for longer than I should
this morning.
Just to say "nice job".
- Terry Fritts [Smart Business] Edmond, OK
|
| |
Thanks for spreading the knowledge!
- Clinton Lee [Ugly Duckling]
|
| |
This site rocks. I'm a starter and I found all the information cool.
Thanks again guys for such a wonderful site to learn VBA for Excel.
- Gerhard Groenewald [DeepBlue]
|
| |
nice page
- Martin King [Wirral Metropolitan College]
|
| |
Rodney,
Thank you very much for your help, this is exactly what I was hoping ot get.
I really appreciate it.
Thanks,
- Ron Alcatraz [CLA Networking, Inc.] Grand Prairie, TX
|
| |
Rodney
Stumbled upon your web site today and spent 2 hours there looking over your
tips etc. As a small business owner myself performing similar tasks as your
company, I was very impressed with the content of your site. I am looking
forward to receiving the Excel Solutions Letter.
Thanks.
- Bud Fulton, Business Manager [SAC Computer Solutions, Inc. ]
|
| |
I've enjoyed looking at your site and learned a couple of useful thing.
- Roo Davison [Terradigm, Inc]
|
| |
Love your website -- excellent real world examples ...
thanks,
- Mike Cooper
|
| |
Thank you
- David Lanman
|
| |
Great information on your site.
- Ron Petitt [Software & Services]
|
| |
THANK YOU!!! IT WORKED!!!
-----
Thank you for responding and so quickly.
...
Thank you!
- Donna Smith
|
| |
Dear Mr Rodney Powell:
Thank you very much for your kindness and efforts to teach others such wonderful issues.
God Bless You !!
Such a pity that persons like you are one per billion.
All the best.
Best Regards,
- João Resende [Portugal Telecom, SA] Portugal
|
| |
I've no words to express my recognition.
Y're the best.
Thank you VERY,VERY much.
All the best.
- João Resende [Portugal Telecom, SA] Portugal
|
| |
Rodney,
Going through my desk drawer(recepticle for everything needy or not)
I found a copy of email dated 11/27/97 to my old compuserve address
(102553,742) advertising the letter with a note that I subscribed 12/2/97.
My Company changed ISP's shortly there after and I don't think I ever got one issue.
Wow- How much I must have missed since then!!!
Glad you are still around I have become very interested in VBA this past year.
- Maryellen Wells [Plant Process Equipment, Inc.]
|
| |
Thanks..
- Eduardo Carrasco [APR]
|
| |
Rodney,
Thank you very much for such a prompt response and for the tip.
I read it carefully and I am going to implement the solution.
I am only slightly familiar with VBA but this is an excellent
starting point ...
...
Thanks again.
-----
I am an eager reader of your Excel tips and I find them most useful.
It is amazing in Excel how many ways you can have to reach your goal!
Best Regards,
- Janusz Poltorak [Owns Illinois IC.] Toledo, Ohio
|
| |
I like your website. Good information for an Excel hack like myself.
- Cliff Merritt [AMEC E&C]
|
| |
Thanks so much.
...
Next time you are near Newport Beach, breakfast, lunch or drink after work is on me.
Thanks again.
- Tom Sippl [Pacific Life Insurance Company]
|
| |
I would like to start receiving your tips, someone forwarded me
this address and you have some really cool stuff. Please advise
how to start receiving this information.
Thanks
- Kay DeRoche [Stewart & Stevenson]
|
| |
Hello Rodney:
Your site is looking good -- very good! I like presentation of your
examples and services. Nice picture! Good client references.
...
My only complaint is that your $89 per hour fee is too low. You are worth more!
- John Lacher, CPA and Microsoft MVP - Excel [Excel Help Page] Worthington OH
|
| |
Dear Rodney,
Thank you for your prompt answer.
I will be investigating the textbox solution while I wait for the
newsletter with the VBA alternatives for writing reports.
Best Regards,
- Mauricio Fulco [Societe Europeene des Satellites]
|
| |
You seem to have some useful solutions, so I'd like to see more.
- Eugene Larkin [U.S. Air Force]
|
| |
Mr. Powell,
A well written (and accurate) discussion of Std Deviation -- a subject
normally difficult to explain to "mere mortals". Your Excel tips are always
informative and a pleasure to read. I particularly enjoyed the Charting
Dynamic Data tip. Thank you!
... goes on to offer an excellent Excel tip
- Ken Futamura [AT&T Labs]
|
| |
Thanks!
- Amy Hawbaker [Survey Sampling, Inc. (SSI)]
|
| |
Thanks - This is very helpful!
- Lou Cioletti [U.S. National Aeronautics and Space Administration (NASA)]
|
| |
Rodney, great job on the website and enjoying the tips...keep them coming.
- George Willis [Fayez Sarofim & Company] Houston, TX
|
| |
Thank you for a wonderful newsletter.
- Wayne Noble [M-Web]
|
| |
Thanks Rodney,
This looks like some excellent information. I'm going to spread it around a bit.
- Dede Burum [Booz Allen & Hamilton]
|
| |
Please keep up your very good work.
- Edgardo Noriega [Edgar Inc]
|
| |
Thank you for the newsletter the tips are great!
- Gabe Cote [Aqua Measure]
|
| |
Many Many thanks for your newsletter. I learn the most from it.
...
- Don Guillett [SalesAid Software] Granite Shoals, TX
|
| |
Dear MR RODNEY POWELL,
Thank you very much for such great newsletter, do you have any other
newsletter which i can subcribe to, as i am great fan of excel, so much
so that i only dream about excel, it is my passion.
...
Thank you once again for such great newsletter.
- Govardhan Bhatia [Panasonic] United Arab Emirates
|
| |
Hello Rodney,
... your newsletters are really very helpful - thank you !
- Stephen Ashley
|
| |
Rodney,
Thank you, kindly. I will find many uses for this!
- John Brizek
|
| |
Your dynamic range name is very helpful - thanks.
-----
Thank you for your help, you can't imagine the time and number of
spreadsheets you just saved me. In my world, your "invention" here places
you ahead of Edison's lightbulb.
Regards,
- Steven Schweitzer [Delaware Management Holdings, Inc.]
|
| |
Thanks for helping me. This page is very interesting.
- Franz Cardenas [FraMa Sowtwares Ltd]
|
| |
Hi there Rodney,
I found your web page after searching for some help and it is really well
put together. I thought that I was bit of a whizz at Excel but not, you guys
really know some clever stuff!
- Philip Smith [ATC Lasham] Hampshire, UK
|
| |
Very useful tips and tricks!
- Nagnus Olofsson
|
| |
I'm delighted!
- Jal Nouda
|
| |
Hi Rodney,
Yea! it works. It looks like algebra formula with cobal programming.
My brain just panics and I can't think it thorough.
I thank you, the Financial Director thanks you. Have a great day.
- Brenda Fradin [Arizona Society of CPAs]
|
| |
Thank you so much. What an easy answer. Actually the formula you sent was
the one i was using in the beginning. Once I changed the answer cell,
everything worked out fine!!!
thanks again!
BTW: I used to live near Spring, Texas, in Humble (Atascosita neighborhood).
Loved it there & enjoyed visiting all the quaint shops in Spring!
- Fran Danner [TV Guide, Inc.] Oklahoma
|
| |
Thank you for this mavelous resource.
- Susan Melifonwu [U.S. Patent and Trademark Office]
|
| |
This is a fabulous resource.
I have just found it this moring and I am amazed to find so much useful information and examples.
Thanks ...
- Bob Mungovan [Computer Sciences Corporation (CSC)]
|
| |
Really interesting procedures - and they work!
- Joan McCudden [Marsh Management Services Ltd] Dublin, Ireland
|
| |
My boss at work showed me his Letter file. He said I might want to subscribe since
I'm always taking home work with me. Thanks! for a great and helpful letter!
- Debi Caldeira [K2 Corporation]
|
| |
I am excited about it.
- Tersam Heer [Fairway]
|
| |
It's very generous of you to provide this information.
It seems you have a successful business, and I hope it will continue for you.
- Jimmy Day [Digital Photography]
|
| |
Rodney
Your monthly newsletter is extremely beneficial and insightful.
I thoroughly enjoy reading it.
- Brad Firsich [Franks Industries, Inc.]
|
| |
Rodney,
Loved the newsletter (I just signed up). ... goes on to offer an excellent Excel tip
- Ashley Williams [Continental Airlines] Houston, Texas
|
| |
Hi Rodney,
...
Brilliant website by the way - it's my Excel bible-on-the-web!
All the best,
- Karen Alston [CPM International] United Kingdom
|
| |
Hi there
Great homepage!
... goes on to offer an excellent Excel tip
Kind regards
- Jan Vogt Hansen [Maersk Contractors] Denmark
|
| |
Hello,
I've had a look at the offset method approach for naming dynamic ranges. Very interesting.
...
Thanks and well done for the newsletter.
- Rosemarie O'Neill [Ramesys] Nottingham
|
| |
Thanks, I do like your work and effort.
- Carlos Gonzales [GSA Computer Enterprises, Inc.]
|
| |
I found your website very helpful. I am particularly interested in the VBA language.
- Deborah Esegbona [Ese's House Ltd]
|
| |
I found this site and I think it is great !!!
- Leigh Toth [HMS Host]
|
| |
I appreciate this. It is quick, to the point, and provides avenue to
further information.
GREAT JOB.
- Jim Brunick [Lockheed Martin Aeronautics Company]
|
| |
Rodney,
I found this very helpful.
Thanks
- Rich Guard [Teradyne, Inc.]
|
| |
First of all - thank you for a useful information source - I have used
several of your tips to make my work easier.
Thanks
- Matt Lausten [Tucker Alan Inc.]
|
| |
Keep up the good work!
- Daniel Ward [Dominion Virginia Power]
|
| |
... Great newsletter, keep it up!!
Best Regards
- Tim Key [Air Logistics, Inc.]
|
| |
Cool! Thanks!
- Cindy Prestidge [Hewlett-Packard Company]
|
| |
Dear Sir,
Thank you very much for your tips. I am a Mathematical Engineer and also an
instructor teaching Microsoft Office Programs. Therefore, tips that you sent
are useful for me.
Yours Sincerely,
- Emine Sever [Erdemir Iron and Steel Works Cooperation]
|
| |
Rodney,
... I want to thank you very much and I look forward to receiving
additional mailings.
Best regards,
- Maurice Hevey [Convergent Cosmetics, Inc.]
|
| |
Thanks
- Randy A. Shively
|
| |
Thanks!
- Roy Long [U.S. Department of Energy (DOE)]
|
| |
Thanks for the tip ...
- Oliver Karp [Interviewing Service of America (ISA)]
|
| |
Rodney,
I've been using your Web site WWW.BEYONDTECHNOLOGY.COM and it's really
been helping me out with some of the things that I knew Excel could do, but
wasn't sure where to begin.
Your article on Printing Full Path in Header/Footer caught my attention,
particularly because I save files in many different subdir. and sometimes
forget where they are. Printing the path in the footer is the perfect
solution ...
- Pam Trbojevic [PNC Bank Corp.]
|
| |
Rodney,
Thank you, it worked.
- Paul Scovill [Catholic Youth Council]
|
| |
Rodney
Thanks for the EXCEL Solutions Letter ...
- Joe Knofczynski [U.S. Army]
|
| |
Hi Rodney,
I don't know how I got on the list for the Excel Newsletter but I am glad I
did. It is nicely done and practical.
- Robert W. Meyer, D.Sc. [Numerical Algorithms Group]
|
| |
Thank you very much for the letter ...
- Luis Alberto Román [Mirasol S.A.]
|
| |
...
Thanks a lot.
Sincerly
- Jefferson Hoyos [El País S.A.]
|
| |
Thank you for the information. This will be very helpful to me.
I hope to hear from you again. If I can return the favor,
please do not hesitate to call on me.
- Larry Gardner [Cummins]
|
| |
Thank U
- Vishwanathan Ns [Weizmann Ltd.] Fort, Mumbai
|
| |
Thanks
This may be very helpful.
Thanks a lot.
- Larry Belk [Union Tank Car Company]
|
| |
Rodney,
Thanks for including me on the mailing list for the Excel Solutions Newsletter.
...
- Steve Abbott [Duke Energy]
|
| |
This is cool - thanks.
- Vu Nguyen [MidAmerican Energy Company]
|
| |
Thanks and very nicely navigated Web site.
- Alan Villiers [Harry S. Truman Memorial Veterans Hospital] Columbia, Missouri
|
| |
Hi Rodney Powell,
I liked your site very much. I like it that it has excellent contents and
Excel Macros that have many uses, work well and are written in short concise
codes. Keep the good work.
- M. Ali Khan [Oil Gas and Geothermal Resources]
|
| |
Thanks and I really enjoy the newsletter.
- Gary Smith [City of Sierra Vista, Arizona]
|
| |
On my first visit to your site you answered a nagging Excel question: how to get
rid of phantom links. Also, your review of dynamic named ranges was excellent.
This is a very powerful tool that too few people know about. Great advice and
really nice web site.
- Bruce Blake [Repsol YPF]
|
| |
I've used several of your tips and procedures and have saved enormous amounts of time. Thanks.
- Dennis Butler [ATR Distributing]
|
| |
Keep up the great work and thank you.
- Robert Westin [Major Dynamics]
|
| |
I have been browsing your Web site and thank you for making this such an interesting site.
I am convinced that it will help me greatly in my learning curve for VBA.
...
Thanks again!
- Larry Egab
|
| |
Thanks, great site.
- Dave Hawley [OzGrid Business Applications] Australia
|
| |
Thanks for the VBA samples! They saved me a lot of time.
- Ian Goodsell [Compuware]
|
| |
Found you on a random search of the Web. Excellent tutorial - thank you.
- Ewen Sim [NW Regional Action Team]
|
| |
Thank you for the service.
- Paul Shaw [PCD Training]
|
| |
Your newsletter is awesome!!
- Scott Senffner [Central Enterprises]
|
| |
Hi - I'm just a new visitor, but from what I've seen it looks like a great site.
...
Thanks for this - it is really good of you to reply and so quickly.
I am really grateful for your help.
- Peter Talent [Klaussner Furniture UK Ltd.]
|
| |
I quite enjoyed your Geek corner and I am not ashamed of it.
In fact, I think you can do very nice things with this huge tool box.
- Hans-Göran Branzell [Westinghouse]
|
| |
Hi Rodney,
|
![Microsoft Office : Excel - Visual Basic for Applications [ VBA ] Software](img/1ptrans.gif){kind=small}
