+ Reply to Thread
Page 4 of 5 FirstFirst ... 2 3 4 5 LastLast
Results 46 to 60 of 61

Call in the Cavalry - 2017

  1. #46
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2010 (Win 7 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    7,020

    Re: Call in the Cavalry - 2017

    Thanks, Glenn.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  2. #47
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2010.. mostly
    Posts
    12,548

    Re: Call in the Cavalry - 2017

    Mmm. Wish I hadn't volunteered...
    Glenn



  3. #48
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    37,529

    Re: Call in the Cavalry - 2017

    Would some kind person with Excel 2003 look in on https://www.excelforum.com/excel-for...a-request.html and tell me if they have a problem with the xls file attached to post https://www.excelforum.com/excel-for...l#post4639381?
    Entia non sunt multiplicanda sine necessitate

  4. #49
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    4,176

    Re: Call in the Cavalry - 2017

    I think it is impossible with formula without helper. Do you think so?

    https://www.excelforum.com/excel-for...lculation.html
    Quang PT

  5. #50
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    7,866

    Re: Call in the Cavalry - 2017

    As usual, pivot tables and chart questions quickly go beyond my level of expertise https://www.excelforum.com/excel-pro...vot-chart.html
    the OP wants to change the name of the data series in the pivot chart. It appears to me that these names are linked through to the source data so that you cannot change them to something other than the text in the source data. Anyone who knows differently?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

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

    Re: Call in the Cavalry - 2017

    I've corrected the code found here, but the OP is still getting errors I can't duplicate nor resolve. Any ideas?
    _________________
    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!)

  7. #52
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    San Antonio, TX
    MS-Off Ver
    Excel 2007
    Posts
    7,176

    Re: Call in the Cavalry - 2017

    I don't usually get involved with the Commercial Service and this thread is probably why.

    https://www.excelforum.com/commercia...o-another.html

    Anybody have some ideas why this runs fine for me, but the OP says they get errors!!
    HTH
    Regards, Jeff

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

    Re: Call in the Cavalry - 2017

    hey Jeffrey

    replace the debug line with .showalldata and it should be good to go in excel 2011. for whatever reason none of the files in that thread can be opened in excel 2016 without the code being stripped out
    Josie

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

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

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by jeffreybrown View Post
    I don't usually get involved with the Commercial Service and this thread is probably why.

    https://www.excelforum.com/commercia...o-another.html

    Anybody have some ideas why this runs fine for me, but the OP says they get errors!!
    I get the errors too, running 2016 desktop
    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

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

    Re: Call in the Cavalry - 2017

    Hope this comes out, I set it to show formulas - this is on Extracted Raw Data sheet...
    C
    D
    1
    Custom SKU Manufacturer SKU
    2
    HDN.J.CH.3.1
    =#REF!A5
    3
    HDN.J.CH.3.2
    =#REF!A6
    4
    =#REF!A7
    5
    =#REF!A8
    6
    =#REF!A9
    7
    =#REF!A10
    8
    =#REF!A11
    9
    HLV.L.BH.4.1
    =#REF!A12

  11. #56
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    San Antonio, TX
    MS-Off Ver
    Excel 2007
    Posts
    7,176

    Re: Call in the Cavalry - 2017

    @Josie, thanks for the help...it seems to have moved the thread along further.

    @Ford, those actually are not the errors I was referring to. I was referring to the code not running as the OP pointed out. What you noted, those errors were there from the very beginning and not what the OP was seeking. The OP was seeking VBA code to move data.

  12. #57
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    San Antonio, TX
    MS-Off Ver
    Excel 2007
    Posts
    7,176

    Re: Call in the Cavalry - 2017

    Somebody care to take a crack at this...

  13. #58
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    MS 2007, 2010
    Posts
    12,022

    Re: Call in the Cavalry - 2017

    Can't see a Formula solution here without a lot of helper columns. I'm thinking VBA but I could be wrong.

    https://www.excelforum.com/excel-for...-criteria.html
    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

  14. #59
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    2,792

    Re: Call in the Cavalry - 2017

    Although posted in the access section, the OP is looking for Excel VBA help from what I can tell....

    He wants to scrape some web data by populating a field and hitting search, which is easy enough, but after that I'm not sure, specifically the captcha that is part of the page... anybody able to help him?

    https://www.excelforum.com/access-ta...l-details.html
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  15. #60
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2013 Win7
    Posts
    6,057

    Re: Call in the Cavalry - 2017

    You can't do it, that's what captchas are designed to prevent you doing

+ Reply to Thread
Page 4 of 5 FirstFirst ... 2 3 4 5 LastLast

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