I want a spreadshhet that imports a txt file and populate a database that feeds some pivot tables.
There are some things to be considered:
The report consists in two parts: the first part, vehicles sold (counts as 1 sale). The second, vehicles returned (wich counts as -1 sale). The second part uses diffrent colums scheme, so it have to be modifie...
Skills: excel vba, microsoft excel, microsoft excel powerpivot