Fetch Data automatically in a single cell

krishna2221

New member
Joined
Oct 26, 2013
Messages
1
Reaction score
0
Points
0
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...
 

Attachments

  • excel filter problem.xlsm
    365.4 KB · Views: 17
Cross-post:
Fetch Data automatically in a single cell
yDGGLvxF30tKs+p7Df9AAAAAElFTkSuQmCC

http://www.mrexcel.com/forum/excel-questions/735274-fetch-data-automatically-single-cell.html
Fetch Data automatically in a single cell
yDGGLvxF30tKs+p7Df9AAAAAElFTkSuQmCC
 
Back
Top