+ Reply to Thread
Results 1 to 14 of 14

Fetch Data automatically in a single cell

  1. 10-26-2013, 12:18 PM #1
    krishna2221
    krishna2221 is offline
    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
    Reply With QuoteRegister To Reply
  2. 10-26-2013, 01:40 PM #2
    jaslake
    jaslake is offline
    Forum Expert 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: 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.
    Reply With QuoteRegister To Reply
  3. 10-26-2013, 01:46 PM #3
    krishna2221
    krishna2221 is offline
    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
    Reply With QuoteRegister To Reply
  4. 10-26-2013, 04:10 PM #4
    jaslake
    jaslake is offline
    Forum Expert 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: 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.
    Reply With QuoteRegister To Reply
  5. 10-26-2013, 04:10 PM #5
    rollis13
    rollis13 is offline
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    917

    Re: Fetch Data automatically in a single cell

    Cross-post:
    http://www.vbaexpress.com/forum/show...-a-single-cell
    http://www.excelguru.ca/forums/showt...-a-single-cell
    http://www.mrexcel.com/forum/excel-q...ngle-cell.html
    Reply With QuoteRegister To Reply
  6. 10-26-2013, 06:55 PM #6
    krishna2221
    krishna2221 is offline
    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.
    Reply With QuoteRegister To Reply
  7. 10-26-2013, 06:58 PM #7
    krishna2221
    krishna2221 is offline
    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
    Reply With QuoteRegister To Reply
  8. 10-26-2013, 07:05 PM #8
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    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
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  9. 10-26-2013, 07:30 PM #9
    krishna2221
    krishna2221 is offline
    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....
    Reply With QuoteRegister To Reply
  10. 10-26-2013, 09:24 PM #10
    jaslake
    jaslake is offline
    Forum Expert 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: 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.
    Reply With QuoteRegister To Reply
  11. 10-26-2013, 09:48 PM #11
    krishna2221
    krishna2221 is offline
    Registered User
    Join Date
    04-17-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Fetch Data automatically in a single cell

    cross post reference
    http://www.vbaexpress.com/forum/show...-a-single-cell
    http://www.techsupportforum.com/foru...ll-737930.html
    http://www.thecodecage.com/forumz/mi...ngle-cell.html
    http://www.excelguru.ca/forums/showt...-a-single-cell
    http://www.mrexcel.com/forum/excel-q...ngle-cell.html
    http://www.excelforum.com/excel-prog...ngle-cell.html

    ok... did it as you said...please help me solving my querry
    Reply With QuoteRegister To Reply
  12. 10-26-2013, 09:49 PM #12
    krishna2221
    krishna2221 is offline
    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...
    Reply With QuoteRegister To Reply
  13. 10-27-2013, 02:08 AM #13
    krishna2221
    krishna2221 is offline
    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??????
    Reply With QuoteRegister To Reply
  14. 10-27-2013, 10:42 AM #14
    jaslake
    jaslake is offline
    Forum Expert 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: 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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Single function to fetch previous month
    By kartik1254 in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 06-04-2013, 01:12 AM
  2. How to Auto Fetch row data upon drop down selection in a cell.
    By ankit-jain in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-07-2013, 06:27 PM
  3. [SOLVED] Line chart to automatically update its data range based on changes in a single cell value
    By jjin in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-01-2013, 02:53 AM
  4. fetch data from oracle to excel and send the data which has same cell name to diff sheets
    By PhAnT0M in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-29-2012, 08:06 AM
  5. Fetch Unique values from a single column
    By Sherlyn Rachel in forum Excel General
    Replies: 3
    Last Post: 03-23-2011, 08:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1