Fuel consumption control - Microsoft Community
i have sheet input information vehicles:
| date | car registration | owner | kms | liters | fuel price | discount | final fuel price | € |
| 24-abr | 12-ab-34 | aaa | 0,000 | - € | ||||
| 26-mai | 12-ab-34 | aaa | 0,000 | - € | ||||
| 27-jun | 12-ab-34 | aaa | 10 428 | 55,48 | 1,254 | 0,120 | 1,134 | 62,91 € |
| 3-jul | 12-ab-34 | aaa | 11 110 | 55,64 | 1,259 | 0,120 | 1,139 | 63,37 € |
| 3-jul | 25-fg-25 | bbb | 102 238 | 38,73 | 1,259 | 0,105 | 1,154 | 44,69 € |
| 11-jul | 25-fg-25 | bbb | 103 007 | 48,87 | 1,269 | 0,105 | 1,164 | 56,88 € |
then, there several sheets each vehicle (fuel consumption), objective each line inserted above should appear in these sheets, according vehicle. question: how can that? if formula date retrieved, can rest.
excel 2016 pro plus power query (aka & transform)
create new table each vehicle.
no formulas, no vba macro.
http://www.mediafire.com/file/312h94fkp3bk214/08_16_17.xlsx
Office / Excel / Windows 10 / Office 2016
Comments
Post a Comment