Fetch Data automatically in a single cell

Excel Help for Fetch Data Automatically In A Single Cell in Automating Data Analysis Tasks

Find Excel Solutions


Search Forums:
Recent Activity:
Auto-timing Not Working Properly
"runtime Error 13" And "runtime Error -2147483640" Excel 2011 Mac
Portfolio Performance Monitoring And Valuation
Importing Data From Pdf Files
Help Required From Administrator
Can't Get It To Give Me The Report I Want




Follow Business Spreadsheets On:
 
Forum TopicReply Login

Fetch Data Automatically In A Single Cell

Rate this:
(3/5 from 1 vote)
Confused 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...
 krishna
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Oops
Rate this:
(3/5 from 1 vote)
It is difficult to know exactly the requirement from your detail; however it seems that you need to reference data from a separate workbook based on results of a pivot table filter.

In the this case, a referencing function may work using MATCH and INDEX or LOOKUP functions.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Fetch Data automatically in a single cell in the

 

Find Excel templates
and add-ins in the
Excel Business Solutions Directory
   
  © 2014 Business Spreadsheets. All Rights Reserved. Legal |