+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 28 of 28

It's the small adjustments that will kill you

  1. #16
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    41,417

    Re: It's the small adjustments that will kill you

    And me, too, also, as well

    Some probably boil down to the fact that if you dont even know what tools exist, how would you know what to ask for?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think some-1 helped you

    Regards
    Ford

  2. #17
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    2010, 2013, 2016
    Posts
    10,927

    Re: It's the small adjustments that will kill you

    I'm not talking about the symptom of someone who doesn't know the tool needed to solve a problem. That is actually the kind of question I love.

    The problem is more when people don't really clearly understand the problem they are trying to solve in the first place, so they really don't even know what to ask. The description of the problem is so scattered that it's hard to even figure out what they need. Here is a made-up example, but I have seen questions that are incredibly similar to this:

    I have three sheets and the names on the first sheet have to match the numbers on the third sheet. But the names on the second sheet are in a different order. How do I get the numbers I need?

  3. #18
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York, USA
    MS-Off Ver
    Office 2016
    Posts
    196

    Re: It's the small adjustments that will kill you

    Quote Originally Posted by 6StringJazzer View Post
    Here is a made-up example, but I have seen questions that are incredibly similar to this:

    I have three sheets and the names on the first sheet have to match the numbers on the third sheet. But the names on the second sheet are in a different order. How do I get the numbers I need?
    Lol: https://www.excelforum.com/excel-for...ml#post4617010

    I don't know how you answered that one with nothing to go on.

  4. #19
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    41,417

    Re: It's the small adjustments that will kill you

    Quote Originally Posted by Raphaelp View Post
    Lol: https://www.excelforum.com/excel-for...ml#post4617010

    I don't know how you answered that one with nothing to go on.
    It's all done with mirrors and crystal balls

  5. #20
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013.. mostly
    Posts
    15,322

    Re: It's the small adjustments that will kill you

    Quote Originally Posted by FDibbins View Post
    And me, too, also, as well

    Some probably boil down to the fact that if you dont even know what tools exist, how would you know what to ask for?
    Indeed. i never saw the point of PRODUCT, until yesterday (never having had the need to find out how to use it)

    https://www.excelforum.com/excel-for...ml#post4618181

    So thanks, MrS....
    Glenn



  6. #21
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,426

    Re: It's the small adjustments that will kill you

    Quote Originally Posted by FDibbins View Post
    It's all done with mirrors and crystal balls
    I guess the years of, and level of, experience of some Member is such that in some cases they can recognise a project and guess what is wanted even when virtually no details are given. This ability makes the rest of convinced that they can mind read.
    But an OP that badly prepares his question and gets and just takes a working solution on a plate really cheats himself of a great chance to learn...
    Quote Originally Posted by FDibbins View Post
    .....probably boil down to the fact that if you dont even know what tools exist, ..
    I wish someone had rammed VBA down my throat when I started with Excel, I probably would have saved a year’s worth of time. An Excel spreadsheet is just a very restricted version of some VBA codes, at least in the way it is used by many people.
    Last edited by Doc.AElstein; 03-31-2017 at 02:47 AM.
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  7. #22
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    41,417

    Re: It's the small adjustments that will kill you

    Very true Alan. "In the land of the blind, the 1-eyed man is king"

  8. #23
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    1,640
    Hi !

    Sometimes it's really hard to answer and stay cool :

    few days ago on a local forum I've been warned my code does not work on rainy days !

    So I had no word to answer except expecting sunny days ‼

  9. #24
    @dministrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010
    Posts
    32,893

    Re: It's the small adjustments that will kill you

    RE: the main topic, this is an ideal example of "Feature creep" and it is undoubtedly ushered in by the "...one more thing" introduction.

    My common answer when the new thing is truly a new feature is often, "That seems like a new idea for a new thread. Let's mark this one solved."
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  10. #25
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,426

    Re: It's the small adjustments that will kill you

    Or
    _....." That sounds like a great idea for a new thread !! - ( Let's mark this one Solved x ) " ..........
    Last edited by Doc.AElstein; 03-31-2017 at 11:59 AM.

  11. #26
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    2010, 2013, 2016
    Posts
    10,927

    Re: It's the small adjustments that will kill you

    Quote Originally Posted by Raphaelp View Post
    Lol: https://www.excelforum.com/excel-for...ml#post4617010

    I don't know how you answered that one with nothing to go on.
    Hey, I was awesome in that thread

  12. #27
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,426

    small adjustments to kill your strings ( who is yous" ) :-nub of a song in there :)

    Quote Originally Posted by Awesome View Post
    Hey, I was Awesome in that thread
    ...Lol
    _.......(Edit: who is Hey ... )



    Us.. Yous.. Wot?
    Nub of a Song: who is yous "who made yous" _Who_Is_Yous yeh..... awesome? ....wot you think?? I can play it .... The drums.. ( and sing it ) Can you Guitar it .. awesome, ..hey - ( need to cut out a string or two or three ? ) ?? Let's cover it :-) !
    Last edited by Doc.AElstein; 03-31-2017 at 06:31 PM. Reason: Or Some stuff

  13. #28
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - 2013
    Posts
    6,726

    Re: It's the small adjustments that will kill you

    Quote Originally Posted by 6StringJazzer View Post
    Hey, I was awesome in that thread
    Yes you were. I was afraid to post that here until you said it.
    Dave

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1