How to create invoices in Excel?

Question

excel

Hello, can you please tell me if it is possible to create an account cell in Excel? There are several fuel cards from which drivers refuel daily, and so, is it possible to create such a field as a card, and in the refueling field, simply indicate the number of liters and make a drop-down list with the choice of the card from which to write off.

Answer 1

There are no fields in Excel, there are tables consisting of cells, to be precise.
That is, if you convert your question into Excel terms, you have a table in which you have n rows and columns, in the cells of which, for each row, the card identifier and the amount of refueling are entered.
Choosing a card through a drop-down menu in the table is done through data validation, where you specify the range in which the cards are listed (for example - F2:F4).
The result will be something like this: