I am making a spreadsheet for sales receipts.
1.)? I want to be able to type in receipts at random by date.? I want to be able before saving the sheet have the item numbers remain the same which is in a column but I want the “Dates” which are in rows going across with the?information to arrange themselves in “Date Order.
2.)? I want to take any receipt and break it up by categories.? (For example food, electronics, tools, garden etc.)? Then have the amount in the category like food I want it to total it all and at the same time calculate the total tax in another column.? So when I type Food, amount and tax it will calculate total in another column.
3.)? The column that will be calculating tax will need to be able to do three (3) different tax rates.? For example T1 it will calculate $4.00 at a 7.25% tax rate and place it in a third column as a total amount T2 would be 8.0% and T3 would be 8.25% tax rate.?
?
?So when I am finish it should show for the whole year the total of food, total tax for food and for the the other categories like electronics, tools, garden etc.
?
4.)? Some when I am typing I forget to type in upper case.? Is there a way of highlighting and have the lower case change to Upper Case without having to retype?