+ Reply to Thread
Page 1 of 3 1 2 3 LastLast
Results 1 to 200 of 458

Call in the Cavalry - 2013

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

    Call in the Cavalry - 2013

    can any1 help with the mess this poor OP has?

    http://www.excelforum.com/excel-form...hing-rows.html
    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

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

    Re: Call in the cavalry -- need help solving this thread

    i really gotta start learning VBA. can anyone help with this?
    http://www.excelforum.com/excel-form...ther-cell.html

  3. #3
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Call in the cavalry -- need help solving this thread

    Wonder if anyone has any handy code that searches non-Excel files without opening them for a string (http://www.excelforum.com/excel-prog...78#post3064278). snb has posted alternatives for FileSearch, but this still requires opening/ closing the files to read their contents.
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

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

    Re: Call in the cavalry -- need help solving this thread

    I saw a similar question answered a little while back, but my searches havnt found it on the forum...

    http://www.excelforum.com/excel-gene...el-2003-a.html

  5. #5
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Call in the cavalry -- need help solving this thread

    You're right, I remember that thread (I may have posted some VB code to do the job), but there was an answer that involved some hang-over from the days of Excel 4 macros.

    Unfortunately, I can't find it either. Sorry

  6. #6
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Call in the cavalry -- need help solving this thread

    Quote Originally Posted by Andrew-R View Post
    but there was an answer that involved some hang-over from the days of Excel 4 macros.
    Try googling GET.CELL(48

    I posted a link in that question
    Audere est facere

  7. #7
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Call in the cavalry -- need help solving this thread

    Thanks, DLL.

    I taught myself macros in Excel 4 when I first started getting into Excel, but (oh god) that was nearly 20 years ago now, and I've managed to forget everything I ever knew

    All I actually remember about the 'old' religion is:

    1. It took me ages to work out from skimming the manuals that you had to use named ranges to initialise variable, and

    2. There were some neat ways of doing common things, like working out the last used row on a sheet, that VBA didn't do so well (although I forget what the neat ways were)

  8. #8
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,084

    Re: Call in the cavalry -- need help solving this thread

    Ok I give up. Anybody have a smart VBA routine to solve this matrix.

    http://www.excelforum.com/excel-gene...g-entries.html

    I went with a worksheet change event to fill in both cells with the same value, but being the table is 25 X 25 this would require many IF constructs.
    HTH
    Regards, Jeff

  9. #9
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the cavalry -- need help solving this thread

    This OP in this thread is looking for some advice (see posts #4 and 5) on dealing with 20k rows of "semi-duplicate" name/address strings.
    _________________
    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. #10
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Call in the cavalry -- need help solving this thread

    Anyone with some "HYPERLINK" formula knowledge, I think I dove FAR too deep on this one: http://www.excelforum.com/excel-formulas-and-functions/889302-return-hyperlink-that-already-exist-in-sheet-if-statement-is-true.html?p=3073713#post3073713
    Any help VERY welcome !
    Last edited by JosephP; 01-09-2013 at 06:13 AM. Reason: correct link
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  11. #11
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: Call in the cavalry -- need help solving this thread

    I have no idea how to take this one to the next step. Need someone with MAC, Excel and Outlook experience to help this OP.

    http://www.excelforum.com/excel-gene...read-only.html

    Alan

  12. #12
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,084

    Re: Call in the cavalry -- need help solving this thread

    Anybody have a solution to conditional format a cell with VBA based on the time the value was entered?

    Was thinking this would work in the intermediate window, ?Format(time,".00"), as this produced .86

    Please Login or Register  to view this content.
    http://www.excelforum.com/excel-form...with-time.html

  13. #13
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,581

    Re: Call in the cavalry -- need help solving this thread

    Jeff

    Couldn't you use Hour?
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  14. #14
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Call in the cavalry -- need help solving this thread

    If anyone can help here:http://www.excelforum.com/excel-form...30#post3076730

    it would be GREATLY appreciated

  15. #15
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,517

    Re: Call in the cavalry -- need help solving this thread

    Hello Calvary,

    Can someone help me see the light
    @ http://www.excelforum.com/showthread...=1#post3078057

    Im not seeing how these are to be grouped.

    Edit also OP gives example of how they need to be grouped in Post#3
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  16. #16
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Call in the cavalry -- need help solving this thread

    I'm not able to simulate the OPs' problem here
    http://www.excelforum.com/excel-form...in-a-cell.html
    Posts #15/16 explain the problem, could someone with 2007, or later please have a look. The OP is using 2011.

    Thanks.

  17. #17
    Registered User
    Join Date
    11-06-2012
    Location
    Norfolk, VA
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Call in the cavalry -- need help solving this thread

    This is an excel problem that started out as a good thread but never came to a conclusion from a few weeks back.

    http://www.excelforum.com/excel-form...html?p=3052752

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

    Re: Call in the cavalry -- need help solving this thread

    rgrov004 this is not the place to "bump" a thread that hasnt been responded to. you need to type something (like bump) into the thread to bring it back to the top of the list again

  19. #19
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Call in the cavalry -- need help solving this thread

    I think the solution for this one http://www.excelforum.com/excel-form...73#post3085173 is going to require more VBA skills than I currently have..

  20. #20
    Registered User
    Join Date
    08-17-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Call in the cavalry -- need help solving this thread

    Cavalry? I posted the following that I thought was do-able http://www.excelforum.com/excel-form...golf-team.html But maybe it wasn't as easy as I thought, or maybe I'm not being clear enough in my question.

    Maybe I'm just new to the whole thread thing and I'm violating some rule I don't know about. Any help is greatly appreciated.

  21. #21
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Call in the cavalry -- need help solving this thread

    @ tahoeast this is a subforum for members to call for assistance with a problem ..not to bump yours!
    having said that...anyone have ideas here
    http://www.excelforum.com/excel-form...golf-team.html
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  22. #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
    50,903

    Re: Call in the cavalry -- need help solving this thread

    can any-one offer any suggestions to this OP?
    http://www.excelforum.com/excel-gene...95#post3084995

    File size growing and cant figure out why

  23. #23
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the cavalry -- need help solving this thread

    Someone please look in this thread and relieve me from this one

    http://www.excelforum.com/excel-form...are-met-2.html


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  24. #24
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the cavalry -- need help solving this thread

    One more help required with this thread also....

    http://www.excelforum.com/excel-prog...ng-a-list.html

    I believe OP needs something like this to find the relevant row.....

    Please Login or Register  to view this content.

  25. #25
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,084

    Re: Call in the cavalry -- need help solving this thread

    Anybody have some ideas about what would work here?

    http://www.excelforum.com/excel-form...f-formula.html

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

    Re: Call in the cavalry -- need help solving this thread

    I thought I had this, but it seems not....
    http://www.excelforum.com/excel-gene...html?p=3087099

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

    Re: Call in the cavalry -- need help solving this thread


  28. #28
    Valued Forum Contributor
    Join Date
    08-13-2012
    Location
    Gardony, Hungary
    MS-Off Ver
    Excel 2003
    Posts
    558

    Re: Call in the cavalry -- need help solving this thread

    Can anyone shed some light on this problem?
    http://www.excelforum.com/excel-prog...too-large.html

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

    Re: Call in the cavalry -- need help solving this thread

    Can someone please assist this user - http://www.excelforum.com/excel-prog...-in-cell.html?
    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]

  30. #30
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Call in the cavalry -- need help solving this thread

    This guy is having problems down loading the attachment in post #11 here Counting number of records in a given date range.

    Seems to be getting #NAME! errors, but I can't see why, both post#11 and #20 download okay at my end ...

    Could someome try opening them and see if they get the errors, or shed some light on why they might be occurring?

    Thanks.

  31. #31
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: Call in the cavalry -- need help solving this thread

    Anyone fancy having a look here: http://www.excelforum.com/excel-prog...35#post3096535

    The code works fine on my computer and I can't really see why it wouldn't work on a mac, but it doesn't.

  32. #32
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,084

    Re: Call in the cavalry -- need help solving this thread

    Seems to be a little out of my comfort zone...

    http://www.excelforum.com/excel-form...time-card.html

  33. #33
    Registered User
    Join Date
    10-04-2012
    Location
    US
    MS-Off Ver
    Word, Excel, Access all 2007 & 2010. Outlook 2010
    Posts
    56

    Re: Call in the cavalry -- need help solving this thread

    [QUOTE=jeffreybrown;3096555]Seems to be a little out of my comfort zone...

    Hi there Jeff,

    I'm really new here but I understand completely what the OP needs. What I am not sure about is that the forum rules are being followed. This is a straight forward calc, I'd probably do it in VBA just because that's what I like best but it would take some effort; wouldn't it be logical to help the OP fix what he's done so far? If he did anything to try to complete this it is not in his worksheet or post. I'm looking to you for moderation on this as I am new. I'm always happy to help but this is the sort of thing I get paid to do; it just wouldn't seem fair if the OP gets paid for what I do too...

    Regards,
    K

    Never-mind! I re-read the OP and I think I may have been able to help, we'll see. Always room for others to see something I may not have. Laterz.
    Last edited by kcarley; 01-25-2013 at 12:49 PM. Reason: Retraction of my first thoughts... sorry.

  34. #34
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,842

    Re: Call in the cavalry -- need help solving this thread

    Quote Originally Posted by kcarley View Post
    I'm always happy to help but this is the sort of thing I get paid to do; it just wouldn't seem fair if the OP gets paid for what I do too...
    Ahhh, the great conundrum. Actually, it's not that difficult to figure out... if those of us who have VOLUNTEERED hours and hours of our own time to help others decided not to do so, the site would have little to no value, and would likely cease to exist.

    Personally, I choose to help however I can knowing that:
    1. I won't receive a single cent for the advice I share
    2. Sometimes I won't even receive the courtesy of a 'Thank You' from the OP

    I just enjoy helping other people solve their Excel problems. My real job pays the bills. But the decision is indeed an individual one. Choose wisely.

    - Moo

  35. #35
    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
    32,503

    Re: Call in the cavalry -- need help solving this thread

    I agree totally with everything that Moo has said. If it troubles your conscience, or your pocket, forget about it.

    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


  36. #36
    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: Call in the cavalry -- need help solving this thread

    @Moo

    Hear, Hear!!!!
    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.

  37. #37
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,084

    Re: Call in the cavalry -- need help solving this thread

    I'm thinking a macro for this problem here...

    Any takers?

    http://www.excelforum.com/excel-char...n-one-row.html

  38. #38
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Call in the cavalry -- need help solving this thread

    Anyone good with ODBC? Trying to use ThisWorkbook.Path in this thread but not working for the OP. He thinks it might be a Windows permission issue but I don't have enough background knowledge to confirm or refute this theory.

    Thanks.

    abousetta

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

    Re: Call in the cavalry -- need help solving this thread

    Need a lil help here - http://www.excelforum.com/excel-prog...pc-cell-3.html.

    The code in post 33 works uptil the Save as part. I am not sure how to loop each workbook to be emailed. I have never worked on that part of it.

    So first the macro will create each file and save them in a folder. Then each one needs to be emailed out. The first part works, need help with the 2nd part.

    You could even add the emailing part after each workbook is created (but i dont know how to do that).

    Thanks much.

  40. #40
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: Call in the cavalry -- need help solving this thread

    I have no idea if what the OP is requesting is even possible. If you think you have a viable solution, then please jump into the pool.

    http://www.excelforum.com/excel-prog...tatements.html

    I was thinking Select Case would work, but how many permutations and combinations would not be effective.

    Alan

  41. #41
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the cavalry -- need help solving this thread

    OP is awaiting for any suggestion for the below thread.

    http://www.excelforum.com/excel-form...ical-test.html

    But I believe having the conditions and formula's in separate cells is something more complicated than editing the single cell IF function

  42. #42
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: Call in the cavalry -- need help solving this thread

    Here is a thread that has me shaking my head.

    http://www.excelforum.com/excel-gene...urns-zero.html

    OP wants a solution that does not use VBA and further wants a solution that doesn't use formulas. Wonder how that will happen. Magic?

    Or am I just tired and don't understand the real issue.

  43. #43
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Call in the cavalry -- need help solving this thread


  44. #44
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the cavalry -- need help solving this thread

    Repeat after me: "Color is not data"

  45. #45
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,501

    Re: Call in the cavalry -- need help solving this thread

    ChemistB
    My 2¢

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

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

  46. #46
    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: Call in the cavalry -- need help solving this thread

    @JB

    I'm color blind and am not big on colors either

  47. #47
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,084

    Re: Call in the cavalry -- need help solving this thread

    I don't have any idea how to create a formula solution here, any help would be appreciated...

    http://www.excelforum.com/excel-gene...-question.html

  48. #48
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,084

    Re: Call in the cavalry -- need help solving this thread

    I've lost the steam for this one and evidently I'm missing something...

    http://www.excelforum.com/excel-prog...47#post3109847

  49. #49
    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
    32,503

    Re: Call in the cavalry -- need help solving this thread

    Anyone got expertise using Solver willing to have a look at this:

    Budget Quantity Formula

    Or any other approach? oeldere suggested Solver and that sounds reasonable but I wouldn't know how to set it up.


    Thanks, TMS

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

    Re: Call in the cavalry -- need help solving this thread

    These date formats always elude me. The macro works but doesnt give the right output all because of the date formats. How do i correct it?

    http://www.excelforum.com/excel-prog...age-box-2.html

  51. #51
    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: Call in the cavalry -- need help solving this thread

    @arlu

    Thread marked as SOLVED.

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

    Re: Call in the cavalry -- need help solving this thread

    Yeah Zbor and Benishiryo assisted us with it. Thank you.

  53. #53
    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
    32,503

    Re: Call in the cavalry -- need help solving this thread

    Anyone have a look at this. Thought it would be simple ... but, seemingly, it's not.

    http://www.excelforum.com/excel-prog...sql-query.html


    Thanks, TMS

  54. #54
    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
    32,503

    Re: Call in the cavalry -- need help solving this thread

    Anyone care to pass comment or judgement on this:

    Shared workbook does not display drop down list

    Thanks, TMS

  55. #55
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,842

    Re: Call in the cavalry -- need help solving this thread

    Hopefully someone can come up with a VBA solution to the OP's newest request here: http://www.excelforum.com/showthread...=1#post3115113

    Thanks,
    Moo

  56. #56
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Call in the cavalry -- need help solving this thread

    ...and another VBA request - I have a formula suggestion that works - anybody care to produce a better approach with VBA?

  57. #57
    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
    32,503

    Re: Call in the cavalry -- need help solving this thread

    @DLL: code provided and accepted.

    Regards, TMS

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

    Re: Call in the cavalry -- need help solving this thread

    any-one got time to look at the file on post #29? over cell A2 there is an object which I am unable to grab/click on. The OP says it was a calendar drop-down they had there that doesnt work now.

    can a) anybody help to remove the object, and b) suggest a way for the OP to have a drop-down calendar in/over A2?

    Thanks
    Ford

    edit: LOL rookie mistake...

    http://www.excelforum.com/excel-form...n-choices.html
    Last edited by FDibbins; 02-08-2013 at 03:09 PM.

  59. #59
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Call in the Cavalry - 2013 onwards

    @Ford
    which thread are you talking about?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  60. #60
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Call in the Cavalry - 2013 onwards

    tahoeast you're right this thread is for members to call for help solving someone else's thread when stuck, not to bump your own problem
    er where did it go?

  61. #61
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2013 onwards

    EXCEL truncates CSV files if a "dash" is in the first character of any line in the file. This thread is a new puzzle. Any ideas?

  62. #62
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Call in the Cavalry - 2013 onwards


  63. #63
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,084

    Re: Call in the Cavalry - 2013 onwards

    Anybody have any thoughts on this...

    http://www.excelforum.com/excel-gene...18#post3118718

  64. #64
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,404

    Re: Call in the Cavalry - 2013 onwards


  65. #65
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: Call in the Cavalry - 2013 onwards

    I've exhausted my VBA knowledge with this OP. Needs a tweak to the formula. Are you able to assist.

    http://www.excelforum.com/excel-prog...iple-rows.html

  66. #66
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Call in the Cavalry - 2013 onwards

    any one fancy some merged cells code
    http://www.excelforum.com/excel-prog...olorindex.html

  67. #67
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: Call in the Cavalry - 2013 onwards

    Nope, merged cells are dirty

  68. #68
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,501

    Re: Call in the cavalry -- need help solving this thread

    Not sure why this is giving the OP issues with Refresh

    http://www.excelforum.com/excel-form...two-cells.html

  69. #69
    Valued Forum Contributor
    Join Date
    08-13-2012
    Location
    Gardony, Hungary
    MS-Off Ver
    Excel 2003
    Posts
    558

    Re: Call in the Cavalry - 2013 onwards

    I'm really curious what the right method is for this one.
    http://www.excelforum.com/excel-prog...-formulas.html

  70. #70
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2013 onwards

    I may be missing the simplicity of the OP's question in this thread, I don't seem to be giving him usable answers. Anyone want to review this?

  71. #71
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,067

    Re: Call in the Cavalry - 2013 onwards

    Can anyone make any sense of what the OP wants in this thread? :

    http://www.excelforum.com/excel-form...ifference.html

    Thanks,

    Pete

  72. #72
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,501

    Re: Call in the Cavalry - VBA Challenge

    The OP wants the formula bar to open up wide enough to show all the lines in his cell (assuming maybe a max of 10 lines) automatically.

    http://www.excelforum.com/excel-gene...ll-2010-a.html

  73. #73
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,501

    Re: Call in the Cavalry - VBA Challenge

    Feeling brain dead on this one. Should be relatively easy

    http://www.excelforum.com/excel-form...e-entries.html

  74. #74
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Call in the Cavalry - VBA Challenge

    any idea why enter doesn't work on =hyperlink() in excel 2010?
    http://www.excelforum.com/excel-form...e-missing.html

  75. #75
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,084

    Re: Call in the Cavalry - 2013 onwards

    I agree with abousetta, sounds like this could be a tricky formula which I'm sure one of you has a fix...

    http://www.excelforum.com/excel-gene...xt-values.html

  76. #76
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2013 onwards

    This OP is looking for assistance with a formula-based data validation back door, rather than the standard DV methods I have offered. Any other ideas?

  77. #77
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,501

    Re: Call in the Cavalry - 2013 onwards

    Any way to return multiple matches with this?

    http://www.excelforum.com/excel-form...ring-text.html

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

    Re: Call in the Cavalry - 2013 onwards

    Not able to understand the OP's requirements here -
    http://www.excelforum.com/excel-prog...and-paste.html

  79. #79
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Call in the Cavalry - 2013 onwards

    Anyone able to help this OP? :http://www.excelforum.com/excel-form...48#post3133648
    I just can not get what they want

  80. #80
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    Any one have any suggestion for the below link.

    http://www.excelforum.com/excel-form...el-2003-a.html

    I am unable to find the root cause of this error, since I don't get any error

  81. #81
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Call in the Cavalry - 2013 onwards


  82. #82
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,084

    Re: Call in the Cavalry - 2013 onwards

    Anybody have a better solution than adding these SUMIFS together?

    http://www.excelforum.com/excel-form...12#post3136212

  83. #83
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,581

    Re: Call in the Cavalry - 2013 onwards

    I'm really lost on what the OP wants here.

    I think I might have missed the point entirely, not unusual.

  84. #84
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Call in the Cavalry - 2013 onwards

    another one i'm just to weary to look further
    http://www.excelforum.com/excel-form...nd-column.html

  85. #85
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Call in the Cavalry - 2013 onwards

    some vba skills needed here,i thought it was just a defined named range but.......
    http://www.excelforum.com/excel-prog...med-range.html

  86. #86
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,084

    Re: Call in the Cavalry - 2013 onwards

    It seems I missed this one after the title change, but now simply too busy...

    Anybody have some spare time to offer...

  87. #87
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2013 onwards

    Any ideas here?

    The OP is trying to save a CSV file but use the delimiter as a semicolon, which he says he has setup already in his computer's Regional settings. The SaveAS CSV with Local:=True is supposed to make that work, but in his case it still isn't. Your additional thoughts are welcomed on it.

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

    Re: Call in the Cavalry - 2013 onwards

    I thought this was something i could do - but when attempted - i was lost - please help -
    http://www.excelforum.com/excel-prog...tive-cell.html

  89. #89
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Call in the Cavalry - 2013 onwards

    I have to say that i give up...

    Can someone explain to our friend here how to drag-copy down a formula from a cell??

    http://www.excelforum.com/excel-new-...ir-length.html
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

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

    Re: Call in the Cavalry - 2013 onwards

    I provided a solution for this thread: http://www.excelforum.com/excel-prog...11#post3149811

    But apparently there is some sort of .txt file versioning issue? I'm not sure what's causing it or how to fix it. Would appreciate it if somebody could take a look or offer an alternative solution that doesn't run into the problem.
    Hope that helps,
    ~tigeravatar

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

  91. #91
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,084

    Re: Call in the Cavalry - 2013 onwards

    I'm drawing a complete blank on this chart thread

  92. #92
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: Call in the Cavalry - 2013 onwards

    What started out as a simple request has evolved into something that is over my head. I am not even sure what the OP is doing here. If you are up for a bit of a challenge, then jump in with both feet.

    http://www.excelforum.com/excel-form...ells-data.html

    Thanks

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

    Re: Call in the Cavalry - 2013 onwards


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

    Re: Call in the Cavalry - 2013 onwards

    Can someone plz help here with a pdf renaming issue - http://www.excelforum.com/excel-prog...pdf-files.html

  95. #95
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2013 onwards

    I'm not asking for anyone to jump into the thread (though you're certainly welcome to), but can anyone help me decipher what this guy is talking about?

  96. #96
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2013 onwards

    Anyone ever used images in data validation? I've never played with that nor if it's possible to do that with dependency.
    http://www.excelforum.com/excel-prog...down-list.html

  97. #97
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Call in the Cavalry - 2013 onwards

    Can anyone help here?
    I have never heard of this happening, and have been completely unsuccessful in recreating the problem

  98. #98
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    I have tried to write code in several methods to group the data but unable to achieve it and finally I am posting it here....

    http://www.excelforum.com/excel-prog...mpty-cell.html

    myself also awaiting to see the code

  99. #99
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    The below thread is about one of the user of a shared workbook needs to know if any change happens in that shared workbook by way of messagbox notification.

    I just share what I thought to achieve it.

    1) On WorkOpen EACH SHEETS used cells count needs to be stored in a Module ARRAY Variable (Two Dimensional Array Like WsCelCnt(SheetName,UsedCellsCount)
    2) Timer Needs To Be set For each 10 seconds and which will run for that user alone by verifying the username
    Please Login or Register  to view this content.
    3) On every 10 seconds the shared workbook of that USER ALONE needs to be saved and LOOPING needs to go on every sheet and get the count of each sheets used cells count
    4) compare BOTH the ARRAY VARIABLES (Module Level Array Variable and Procedure Level Array Variable) and if both doesn't match then show a message to THAT USER ALONE (application.UserName).

    I am not having that much of proficiency in vba and doing all those things may take a day for me. So thought to post it here and may be even simple solution may be there which I am not aware

    http://www.excelforum.com/excel-prog...lls-excel.html

    Thanks for looking it

  100. #100
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,084

    Re: Call in the Cavalry - 2013 onwards

    I'm losing the battle on this one

    Any help would be appreciated...

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

    Re: Call in the cavalry -- need help solving this thread-prior to 2013

    Can any-one help with this? I cant even make out what the OP wants?

    http://www.excelforum.com/excel-form...n-the-row.html

  102. #102
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Call in the Cavalry - 2013 onwards

    I don't do pivot tables - anyone want to jump in on the last query here?

  103. #103
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Call in the Cavalry - 2013 onwards

    Anyone able to help OP here :http://www.excelforum.com/excel-form...16#post3183916 ?
    I tried my (VERY) limited VBA on it and kept getting wrong answer..

  104. #104
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,501

    Re: Call in the cavalry -- need help solving this thread

    Anyone want to give this one a try? OP just threw a curve and my brain is fried.

    http://www.excelforum.com/excel-form...l-summing.html

  105. #105
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,570

    Re: Call in the Cavalry - 2013 onwards

    I frequently miss to answer threads cause once you take a look at it in the CP it does not register as new post anymore and I forget all about it.

    This should be a fun array formula for anyone who is a bit sharper than me, I'm out of ideas and it's way overdue. I hope it's not to late for OP.

    http://www.excelforum.com/excel-form...d-columns.html
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  106. #106
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,501

    Re: Call in the Cavalry - 2013 onwards

    A permutation solution needed here

    http://www.excelforum.com/excel-gene...ique-rows.html

  107. #107
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: Call in the Cavalry - 2013 onwards

    I got the OP on the right track, but the next VBA issue is beyond me.

    http://www.excelforum.com/excel-prog...-commands.html

  108. #108
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: Call in the Cavalry - 2013 onwards

    Look at this thread as the solution I offered the OP was not appealing to him, although it is perhaps the quickest and easiest in my mind. But that may be because I am comfortable with databases which is not the case with many excel users. Perhaps you have something else that is more in line with what he is looking for.

    http://www.excelforum.com/excel-prog...ent-files.html

  109. #109
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2013 onwards

    This thread is about web connect refreshes that "won't". Any insight is welcome.

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

    Re: Call in the cavalry -- need help solving this thread-prior to 2013

    HI, Im trying to get a hyperlink to another sheet to work, referencing a formula in another cell (could become part of the H/L though), cant seem to figure it out

    http://www.excelforum.com/excel-gene...condition.html

    Im trying to use a reference from A2&A4&A6 for the hyperlink, and giving the sheet name/s the same as the results of the D/D

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

    Re: Call in the Cavalry - 2013 onwards

    Am just not getting what the OP is saying - maybe someone can help - http://www.excelforum.com/excel-gene...ng-series.html

  112. #112
    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
    32,503

    Re: Call in the Cavalry - 2013 onwards

    Can anyone offer their thoughts on an approach for this:

    formula to auto update cells below when inserting a new row

    Thanks, TMS

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

    Re: Call in the Cavalry - 2013 onwards

    hmm can anyone figure out what this OP wants?

    duh a link would help...

    http://www.excelforum.com/excel-prog...30#post3200830
    Last edited by FDibbins; 04-17-2013 at 11:00 AM.

  114. #114
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Call in the Cavalry - 2013 onwards

    Quote Originally Posted by FDibbins View Post
    hmm can anyone figure out what this OP wants?
    Link?! .

  115. #115
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    OP wants only VBA solution for the below thread, but I don't know the need to go for vba. I hope someone can fix it

    http://www.excelforum.com/excel-prog...nd-button.html

  116. #116
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,501

    Re: Call in the cavalry -- need help solving this thread

    Can't wrap my head around this date problem

    http://www.excelforum.com/excel-form...ndar-year.html

  117. #117
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    I am unable to fix the root cause of this error
    http://www.excelforum.com/excel-gene...el-2010-a.html

  118. #118
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards


  119. #119
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    Another one which I am unable to fix
    http://www.excelforum.com/excel-gene...-not-dele.html

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

    Re: Call in the Cavalry - 2013 onwards

    Can any-one shed any light on this 1?

    http://www.excelforum.com/excel-gene...paste-etc.html

  121. #121
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    Is there any best method is there for creating Dependent Drop List (3 Levels) when the categories are huge
    http://www.excelforum.com/excel-gene...down-list.html

  122. #122
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,501

    Re: Call in the Cavalry - 2013 onwards

    Need a VBA solution that looks at numerical values and digit by digit converts them to a alpha character (in reverse order) based on binary.

    http://www.excelforum.com/excel-form...ary-value.html

  123. #123
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    Anyone Please correct me if I am wrong

    http://www.excelforum.com/excel-gene...ing-cells.html

  124. #124
    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
    32,503

    Re: Call in the Cavalry - 2013 onwards

    @Sixthsense: No, you wouldn't use Sheet Protection. You'd just use the Selection Change event to manage which cells the user could access. If a selected cell has data in it, you'd bounce it somewhere else.

    Tested, briefly, in a non-shared workbook:

    Please Login or Register  to view this content.

    Regards, TMS

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

    Re: Call in the Cavalry - 2013 onwards

    Dont know how i missed this one but i really dont have the time to work it out. Can someone please pitch in - http://www.excelforum.com/excel-prog...fic-info.html?

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

    Re: Call in the Cavalry - 2013 onwards

    I suggested data validation for this thread, but it doesn't look like that what the user is going for. Anybody up for a macro work-around/solution?

  127. #127
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    I am not getting any idea how to achieve this one Any suggestions???

    http://www.excelforum.com/excel-form...t-of-debt.html

  128. #128
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Call in the Cavalry - 2013 onwards

    anyone good at counting parenthesis?
    http://www.excelforum.com/excel-form...f-formula.html

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

    Re: Call in the Cavalry - 2013 onwards

    umm holy...cr^&*()_ Martin!!

  130. #130
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    I am unable to fix which setting causing sheet tabs not showing in display, any suggestions

    http://www.excelforum.com/excel-gene...-in-excel.html

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

    Re: Call in the Cavalry - 2013 onwards

    I don't think the OP is listening to me anymore, anybody have a different solution?
    http://www.excelforum.com/excel-form...html?p=3230851

  132. #132
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    OP wants to have a Multi Select Combo Box like Pivot Table Drop Down selection. Any suggestions?

    http://www.excelforum.com/excel-prog...tion-list.html

  133. #133
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    Not getting any idea for this one Any Suggestions?

    http://www.excelforum.com/excel-form...ange-list.html

  134. #134
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: Call in the Cavalry - 2013 onwards

    I have looked over this OPs issue and cannot find anything wrong with his methodology in using the Countifs function. It does not return the results when employed in Column D on the Summary sheet for Accounts Labor and Tax. Very strange. Maybe someone will see something glaring. I could not.

    http://www.excelforum.com/excel-form...9-countif.html

  135. #135
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Call in the cavalry -- need help solving this thread-prior to 2013

    OP wants users to be able to copy values, but not formating...not sure how to do this my self....
    http://www.excelforum.com/excel-form...84#post3236084

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

    Re: Call in the Cavalry - 2013 onwards

    http://www.excelforum.com/excel-prog...40#post3233240

    DV in AP4:AR4 to turn red if all empty, or if more than 1 cell is filled. works fine except there if there are 2 and you delete 1 (leaving 1) they dont all turn white until you enter something - anything - somwhere else??

  137. #137
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Call in the Cavalry - 2013 onwards


  138. #138
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,417

    Re: Call in the Cavalry - 2013 onwards

    - i.s.z -
    CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
    Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
    All good ideas are courtesy resources from this forum as well as others around the web.
    - e.o.m -

  139. #139
    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
    32,503

    Re: Call in the Cavalry - 2013 onwards

    Anyone got any thoughts on this:

    Having a problem stepping through VBA and setting breakpoints at same time


    I'm all out of guesses.

    Thanks TMS

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

    Re: Call in the Cavalry - 2013 onwards

    I'm kind of lost on this one, would appreciate it if somebody took a look here:
    Statistically significantly higher than average

  141. #141
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    I thought I can (If the data structure is constant), After seeing the data structure I decided to post here for help

    http://www.excelforum.com/excel-form...o-another.html

  142. #142
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    Seems to be a Challenge, Anyone can provide single cell formula?
    http://www.excelforum.com/excel-form...html?p=3244372

  143. #143
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2013 onwards

    Anyone good with forms want to take a peek here?

  144. #144
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    Any suggestions, how to make this code to run faster
    http://www.excelforum.com/excel-prog...un-faster.html

  145. #145
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2013 onwards

    Can't quite get this one... need an array formula.

    a) Start dates in column A
    b) end dates in column B, if any
    c) sequential list of dates in column C

    Goal in column D, based on the date in column C, find the oldest order that was still open on that day and list how many days it's been open up to the col C date.

  146. #146
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Call in the Cavalry - 2013 onwards

    Question regarding capturing download URL when the response is not immediate from the server (http://www.excelforum.com/excel-prog...54#post3247754). Can anyone assist the OP?

    abousetta

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

    Re: Call in the Cavalry - 2013 onwards

    Can someone help the OP here http://www.excelforum.com/excel-prog...tionality.html ?

    Thanks

  148. #148
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    OP is not ready to change the data structure and wanted to stick with junk approach, anyone is interested to take us this challenge?

    http://www.excelforum.com/excel-form...la-lookup.html

  149. #149
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    Anyone please take this formula challenge, seems to be simple but I am not getting any idea

    http://www.excelforum.com/excel-form...s-a-table.html

  150. #150
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    I don't know any abc about chart anyone please take care of this thread please...

    http://www.excelforum.com/excel-prog...-data-set.html

  151. #151
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,501

    Re: Call in the Cavalry - 2013 onwards

    For anyone who's brain is still working, complex array formula (or come up with a better way)

    http://www.excelforum.com/excel-form...-formulas.html

  152. #152
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    I don't know how I can help further...

    http://www.excelforum.com/excel-form...sion-wise.html

  153. #153
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: Call in the Cavalry - 2013 onwards

    Is there a viable solution for this OP?. Do you know of one? Probably a complex VBA solution, I'm guessing. Out of my range of knowledge.

    http://www.excelforum.com/excel-prog...ted-cells.html

    Alan

  154. #154
    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
    32,503

    Re: Call in the Cavalry - 2013 onwards

    For my own peace of mind, would someone care to take a look at this thread and explain what has happened ...

    HELP ME Wierd display, can't change sheet

    I have provided a "get out of jail card" for the OP in that I have copied all the sheets and code to a new workbook.

    If you download the example, you will find that the display in Excel is exactly as described in the OP. However, you can open other workbooks, or create new workbooks, and they behave normally.

    I have never seen anything like this and everything I have tried, other than creating the copy, has failed.

    I would be intrigued to see a solution to this issue.

    Regards, TMS

  155. #155
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Call in the Cavalry - 2013 onwards

    Anybody with a scanner and know vba what to help the OP debug the code. It works fine, but once he scans another item, it triggers a worksheet_change event and bypasses the need for the OP to intervene (http://www.excelforum.com/excel-prog...88#post3255588).

    Thanks.

    abousetta

  156. #156
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Call in the Cavalry - 2013 onwards

    http://www.excelforum.com/excel-prog...html?p=3256083

    Not a clue what to do on this one. Seems to work ok with my setup (2003/XP) but looking on google it seems that the method no longer works for (2007/Windows 7). Could do with someone with newer software to take a look at it.

  157. #157
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,581

    Re: Call in the Cavalry - 2013 onwards

    Can someone take a look at this?

    http://www.excelforum.com/excel-prog...dropdowns.html

    The only way I can think of doing it is with some massive, crazy unworkable formula.

    I've got a feeling I'm missing something though.
    Last edited by Norie; 05-28-2013 at 06:59 AM.

  158. #158
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Call in the Cavalry - 2013 onwards

    Norie - your link goes to the subscription page...

  159. #159
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,581

    Re: Call in the Cavalry - 2013 onwards

    Fixed it.

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

    Re: Call in the Cavalry - 2013 onwards

    I think I have resolved this 1, But Im still stumped on whats causing the problem.

    http://www.excelforum.com/excel-gene...-is-a-sum.html

  161. #161
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    Any suggestions about how to get certain fields of website using web query through VBA?

    http://www.excelforum.com/excel-prog...-from-web.html

  162. #162
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,442

    Re: Call in the Cavalry - 2013 onwards

    Hi,

    I need someone who still is using Excel 2003 and has the Calendar control on their system. This OP has a very elaborate Userform (with tabs and groups of controls). He wants to sum the values in a bunch of the text boxes on his userform. I simply can't open his .xls without the calendar control and I'm not good enough at Tabs on a Userform to be much help.

    See his thread at http://www.excelforum.com/excel-prog...much-code.html

    He is still on me for an answer.....
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  163. #163
    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: Call in the Cavalry - 2013 onwards

    @MarvinP

    The OP has posted an .xlsm File...not Excel 2003????

  164. #164
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,442

    Re: Call in the Cavalry - 2013 onwards

    I still don't have the Calendar control or some add-in that is needed to work on his Userform.

  165. #165
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Call in the Cavalry - 2013 onwards

    Can anyone with Office 2007 try the attachment (http://www.excelforum.com/excel-prog...=1#post3273149) .

    what you should see is in this image (http://www.excelforum.com/attachment...5&d=1370788367).

  166. #166
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

    Re: Call in the Cavalry - 2013 onwards

    Works fine for me in Excel 2007.

    Abousetta, when you post code that changes the Excel environment, you should also post code to restore it.

    Please Login or Register  to view this content.
    Or make the code toggle it:

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  167. #167
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Call in the Cavalry - 2013 onwards

    Thanks shg. I honestly didn't know that the style could be reversed. The MSDN page on Windows Styles (http://msdn.microsoft.com/en-us/libr...=vs.85%29.aspx) states that "After the window has been created, these styles cannot be modified, except as noted". I took that to mean that once I remove the border, I can't put it back without redrawing the window.

    Now that I know better, I will update the code. Also I will investigate "Xor" as I have never seen that before.

    Thanks again for sharing.

    abousetta

  168. #168
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Call in the Cavalry - 2013 onwards

    Me again...

    Follow up to post #165, the solution works fine in some versions of Windows but not XP. Does anyone know how to remove the three uppermost buttons (minimize, resize, close) in Windows XP? The thread is located here (http://www.excelforum.com/showthread...=1#post3273423) and what you should see is in this image (http://www.excelforum.com/attachment...5&d=1370788367).

    Thanks.

    abousetta

  169. #169
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,442

    Re: Call in the Cavalry - 2013 onwards


  170. #170
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Call in the Cavalry - 2013 onwards

    Thanks MP. I was able to remove the minimize button, but not the other two. XP seems to be a species of its own kind.

  171. #171
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Call in the Cavalry - 2013 onwards

    With Windows XP, I found that I have to hide the ribbon in order to hide the three buttons. I don't know the logic but I left an example for the OP. Hopefully it will resolve her issues.

  172. #172
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    I am unable to understand the OP's requirement of this thread

    http://www.excelforum.com/excel-gene...ping-data.html

  173. #173
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Call in the Cavalry - 2013 onwards

    Another one which I am unable to fix

    http://www.excelforum.com/excel-gene...t-too-big.html

  174. #174
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Call in the Cavalry - 2013 onwards

    I have no clue what this user wants now so please check this thread out if you want to take a gander at it. I came up with an original solution but now the requirements have changed and I don't understand them anymore.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---