+ Reply to Thread
Results 1 to 14 of 14

Fetch Data automatically in a single cell

  1. #1
    Registered User
    Join Date
    04-17-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    22

    Fetch Data automatically in a single cell

    hello forum members.
    i have truck running data in km book sheet and outward book sheet as attached. i created a pivot table with sorted data in sheet8. next to pivot table i want to fetch data of column 1 in km book sheet after filtering and sorting data based on vehicle number and km the vehicle ran. i did one myself manually but its too complex to do. i also recorded macro for reference what to filter. after filtering i just entered data in cell i wanted to. but i want a vba code for this. how will i be able to know where my trucks operated between the two kilometeres in pivot data table. PLease help...
    Attached Files Attached Files

  2. #2
    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 2007 2003
    Posts
    12,647

    Re: Fetch Data automatically in a single cell

    File appears to require a Password...
    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.

  3. #3
    Registered User
    Join Date
    04-17-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Fetch Data automatically in a single cell

    Quote Originally Posted by jaslake View Post
    File appears to require a Password...
    oooopsss.....i am sorry...here is file with no password or the password is crushergrit
    Attached Files Attached Files

  4. #4
    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 2007 2003
    Posts
    12,647

    Re: Fetch Data automatically in a single cell

    Your Code is password protected...the password you provided seems not to unlock the Code.

    You'll need to reference the Cross Posts...see Forum Rules. You'll probably get no further help until you've done so.
    Last edited by jaslake; 10-26-2013 at 04:18 PM.

  5. #5
    Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016
    Posts
    301

  6. #6
    Registered User
    Join Date
    04-17-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Fetch Data automatically in a single cell

    Sorry I didnt read the rules...I didnt mention the cross post links and I am sorry for that...as already another forum expert has mentioned my cross posts I request you to solve my problem. Also the vba code is unlockvba! and workbook code is crushergrit. As I have extracted the workbook data, the codes remained intact and I forgot to remove them. Kindly proceed.

  7. #7
    Registered User
    Join Date
    04-17-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Fetch Data automatically in a single cell

    Once again I am sorry. Please help me

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    15,685

    Re: Fetch Data automatically in a single cell

    You should read the link below so you understand why all the excitement about cross-posting. Since you have hit at least 5 sites, people may be reluctant to respond as explained in the link.

    http://www.excelfox.com/forum/f25/me...1172/#post5326

  9. #9
    Registered User
    Join Date
    04-17-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Fetch Data automatically in a single cell

    yes i understand and i am saying sorry for that.....PLease help me solve my querry....

  10. #10
    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 2007 2003
    Posts
    12,647

    Re: Fetch Data automatically in a single cell

    You'll need to do this on this Site and probably on the other Sites to which you've posted this query...so...get it done...Post a Reference to all your Cross Postings...no additional help will be forthcoming until you do...get er done.

  11. #11

  12. #12
    Registered User
    Join Date
    04-17-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Fetch Data automatically in a single cell

    now please help me.....the matters a little urgent...

  13. #13
    Registered User
    Join Date
    04-17-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Fetch Data automatically in a single cell

    please reply......are you getting my querry?????????????
    ???????
    Anyone??????

  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 2007 2003
    Posts
    12,647

    Re: Fetch Data automatically in a single cell

    Hi krishna2221

    In your sample Pivot Table how did you determine this...precisly what steps did you follow??

    10/22/2013 121452 121577 A/Dust/51A/Dust/53 <-------

+ Reply to Thread

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