+ Reply to Thread
Results 1 to 20 of 20

Tip: to get more responce on a question

  1. #1
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Tip: to get more responce on a question

    See the questions which get answers without and with an excel file.

    You will see, that if you add an decent file with your question, (without confidentional information) you get quicker and better help.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,832

    Re: Tip: to get more responce on a question

    I couldn't agree more. Not every question needs a sample workbook but, in my opinion, it generally make the requirements clearer. And the answer is more likely to be what the OP is looking for.

    I've seen threads that drag on and on but, as soon as a workbook is provided, the solution is forthcoming.

    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Tip: to get more responce on a question

    I also agree with including a workbook example but not a picture of a workbook.

    It would also be good to include ALL the requirements to solve the problem instead of continually adding details after solutions to the stated problem are posted.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,162

    Re: Tip: to get more responce on a question

    Yes, i agree and also the OP should upload a file which matches the original file with regard to format. Otherwise, double work for us and them.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

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

    Re: Tip: to get more responce on a question

    I have been working on a solution for a member, and the file they send, while very clear in its detail, was a long way off from the real file. As a result, I spent ages (hours) creating the formulas (looking back at them afterwards, I couldnt figure out how I did them lol), but when the OP applied them to their real data, it didnt work any more.

    So, the moral of the story, when posting a sample workbook, keep it as close as possible to the real file!! it will save both of us a LOT of extra work
    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 someone helped you

    Regards
    Ford

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,193

    Re: Tip: to get more responce on a question

    Yes, yes, we all agree, although it won't change anything. Learn to live with it, as with all other disrespectful ways of posting of other regular members

    One can always add a member to one's " Ignore list" if he feels like it

  7. #7
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Tip: to get more responce on a question

    Quote Originally Posted by FDibbins View Post
    I have been working on a solution for a member, and the file they send, while very clear in its detail, was a long way off from the real file. As a result, I spent ages (hours) creating the formulas (looking back at them afterwards, I couldnt figure out how I did them lol), but when the OP applied them to their real data, it didnt work any more.

    So, the moral of the story, when posting a sample workbook, keep it as close as possible to the real file!! it will save both of us a LOT of extra work
    Sorry , I forgot to mention that you can't use formulas, b/c my staff keep changing them...
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

  8. #8
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Tip: to get more responce on a question

    providing "Expected output" in the attached sheet, is also help, if OP/Reader was unable to gotit properly..
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  9. #9
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Tip: to get more responce on a question

    This took the solution from a possible two posts to 16 posts before satisfaction:

    Thanks. The code works fine, but just realized the actual worksheets ref are in different columns.
    I tried to attached the workbooks, but seems like it's not allowed to do so in reply.
    I amend the code as following:
    -
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  10. #10
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Tip: to get more responce on a question

    Related...

    Seems a lot of folks like to post files in their replies to the OP without any explanation. For example, their reply to the OP will be something like this...

    See the attached file

    File.xlsx
    I don't download and look at these files. So, I may come along later and post a reply that uses the exact same suggestion that's in the sample file.

    When this happens don't think that I copied your solution. I don't do that. I pretty much know what I'm doing and don't need to "steal" someone elses suggestion just to make a post.

    I don't care about post counts or rep points!
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  11. #11
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Tip: to get more responce on a question

    In addition...

    If you included some explanation along with a sample file then I can see what your suggestion is and if it's the same thing I would do then I wouldn't post a reply in that thread.

  12. #12
    Forum Guru tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Tip: to get more responce on a question

    Quote Originally Posted by Tony Valko View Post
    Seems a lot of folks like to post files in their replies to the OP without any explanation.
    This bugs me too. If you took the time to post a solution with an example workbook, you should take the time to explain what is in the file.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  13. #13
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Tip: to get more responce on a question

    Quote Originally Posted by tigeravatar View Post
    Quote Originally Posted by Tony Valko View Post

    Seems a lot of folks like to post files in their replies to the OP without any explanation.
    This bugs me too. If you took the time to post a solution with an example workbook, you should take the time to explain what is in the file.
    I must admit to occasionally being guilty of this - often if it's late at night, or I'm on a quick break at work - though more often than not I'll either explain how I did what I did, or ask the OP to let me know if an explanation is required. I firmly believe that the best way to equip an OP to deal with a similar scenario in the future is to explain the answer, although the lack of response to a detailed explanation sometimes dampens the will go to the trouble of explaining in subsequent threads.
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

  14. #14
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Tip: to get more responce on a question

    This is my canned reply to Threads that (in my opinion) require a sample file. Also, typically, when I post a solution, I'll show the Code in the Thread so others that are viewing the Thread can see what I've recommended. I don't do so when the Code is, in my estimation, too long. I appreciate it when other responders do the same...I'll look at their solution...if it makes sense to me, I'll pass on responding to that Thread. If I have a different approach I'll post to the Thread.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" worksheet that demonstrates what you wish the output to be.

    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the "Add Files"... button to locate your file for uploading.
    6. This will open a new window File Upload...Click "Select Files"
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the "Upload Files" button and wait until the file has uploaded.
    10. Click the "Done" Button.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  15. #15
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Tip: to get more responce on a question

    I usually just post my code but if the OP is inexperienced, I may post the file - for, say an event procedure. But, all in all, it's just a matter of caprice

  16. #16
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Tip: to get more responce on a question

    I usually won't attach a file unless what is being asked is really complicated or, If after I've already made a suggestion, the OP replies back with "it doesn't work".

    Then I feel obliged to prove to them that it does indeed work!
    Last edited by Tony Valko; 07-16-2013 at 07:27 PM. Reason: I don't know how to spell

  17. #17
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Tip: to get more responce on a question

    @ Tony

    Been there - done that.

  18. #18
    Registered User
    Join Date
    03-21-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Tip: to get more responce on a question

    I couldn't agree more. When I search for excel questions on google, alot of hits come up for this site. However, when I click the thread and read the questions, 80% of the time I am confused as what is being said. Much easier to attach an excel workbook so that it may be easily visualised

  19. #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
    51,306

    Re: Tip: to get more responce on a question

    More often than not, I will post the formula, tell them (no, not where to put it) where it goes (almost the same but not quite), and unless its really involved and would take me a week to explain it, I sometimes explain how it works/what it does. If there are more than 2-3 ...it doesnt work, where do I put it" etc, then I will include the file

  20. #20
    Registered User
    Join Date
    03-11-2014
    Location
    Rotterdam, Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Tip: to get more responce on a question

    The new thread (containing clear workbooks) is: http://www.excelforum.com/excel-gene...ml#post3618277

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Question regarding conditional format question that covers two range criteria
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2013, 12:32 PM
  2. Replies: 3
    Last Post: 06-17-2011, 08:09 AM
  3. Two question, numeric code question and subtraction of two columns?
    By mgsweden78 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2008, 02:50 AM
  4. Slow responce to functions
    By Al in forum Excel General
    Replies: 1
    Last Post: 08-18-2006, 08:55 AM

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