Hi,
As I understand from your Excel file, you want to make the process easier to manage and more friendly to use.
Here is what I propose:
I will create an Access database with the below functionality (based on the data you have provided):
1.
I will create table called 'Automobile' containing records for (Car Name, Purchase Price).
"2009 Ford Focus","1998 Lexus GS400","2004 Highlander","2002 Honda Odyssey"
"5000","4500","5800","2500"
2.
I will create another table called "Orders" with (BuyerID, Auction Fees, Repairs, Miscellaneous, Marketing, Fuel, Total, Sales Price, Profit (Loss), Purchase Date, Sold Date, Loan Duration)
The "Totals" and averages will be created by queries so that they can be used in reports.
Other functionality can be discussed/implemented once the basics have been ascertained and done.
Thanks for reading,
James Harrod