Tracking numbers (shipment tracking numbers) database. Roll card, bordero, freight card. Excel VBA

Types of sheets. Program for creating freight cards in Excel VBA.

This program is an Excel file programmed in VBA.

The Excel file contains two types of sheets.

The first type is sheets with freight card forms. The user can create as many of these sheets as they need. These are, for example, the tables “Addressee_1”, “Addressee_2” and others.

The second type are the sheets needed to run the VBA code. These are the “Database” sheet, the “Restore Freight card” sheet, the “Restored Freight card” sheet.

In the “Database” sheet, the program saves all the tracking numbers entered with details of the addressee, date and time of recording.

In the “Restored Freight card” sheet, an input mask is called up in which the required freight card is restored by entering the recipient and date.

The “Restored Freight card” sheet contains the restored freight card.

Freight card form. Program for creating freight cards in Excel VBA.

Each sheet with a freight card form is named after the name of the addressee for whom it was created.

The consignee's name is indicated at the top of the freight card form.

35 Tracking numbers are only entered in the range B5:B39.

Each tracking number entered in this area is entered by the program into the “Database” sheet with details of the recipient, date and time of recording.

At the bottom of the freight card form is the current date, the driver's name and the recipient's signature.

Database. Program for creating freight cards in Excel VBA.

In the “Database” sheet, column “A” contains the entered tracking numbers, column “B” contains the recipient names and column “C” contains the date and time of the entry.

Using Excel's search function makes it easier to search the database.

In the “Replace” search function options, the “Compare all cell contents” option should be disabled.

Restore freight card. Program for creating freight cards in Excel VBA.

In the “Restore Freight card” sheet, an input mask is called up in which the desired freight card is restored to the “Restored Freight card” sheet by entering the recipient and date.

Clear all sheets. Program for creating freight cards in Excel VBA.

When you start the program, you will be asked if you want to clear all registered tracking numbers on your freight cards. The database is not deleted.