Spreadsheet: 97413d1296596873-connectcode-asset-tracking-spreadsheet-1-0-assettracking-editied
Sheet: About&Help

About ConnectCode
ConnectCode is founded with the goal of providing comprehensive, high quality and cost-effective automation tools and software for everyone. Our team consists of personnels that have deep interest in spreadsheets and spreadsheet Add-ins.
If you require other types of barcodes, please check out our site at http://www.barcoderesource.com
Help
ConnectCode Asset Tracking Spreadsheet is designed to help you track your assets easily with barcodes. This template allows you to setup asset or inventory records in the AssetData worksheet. Afterwhich, you will be able to Generate the Serial Numbers as barcodes. The most widely used Code 39 barcodes will be generated. The barcodes can then be printed on commonly used labels like those from Avery(TM) or other brands on an inkjet or laser printer. Subsequently, paste the barcodes on the items you will like to track. When you need to retrieve more information on an item, simply scan the barcode on the item(using an off the shelf barcode scanner or key in the Serial number). With this, you will be able to track your assets and inventories efficiently. All the source codes and fonts for the barcode are provided for further customization. However, please kindly note that this About worksheet and the License text file included in the installation should always be retained.
TrackAsset
 | Enter Serial Number |  |  | Use a barcode scanner to scan the Serial Number or key in the Serial Number through the Combo Box.
 |  |  |  | The detailed information of the record will be retrieved and displayed.
 | Manage Records |  |  | Launch the Data->Form command to manage the records in the AssetData worksheet.
 |  |  |  | Alternatively, manage the records by updating the AssetData worksheet directly.
 | [NAME] |  |  | Generate the Serial Numbers in the AssetData worksheet as Code 39 barcodes on a A4 (3 x 10 labels) sized paper.
AssetData |  |  |  | This worksheet contains all the asset records information.
Barcodes on A4 (3 x 10) |  |  |  | Print this worksheet after generating the barcodes in the TrackAsset worksheet.
Explanation
1) The purpose of this template is to help you track your assets more easily by generating their serial numbers as barcodes on a printable page.  2) To work with it, you first customize / modify the records in the AssetData worksheet for all your trackable assets. You can also do this by clicking the Manage Records button. 3) When you have finished defining the records, you click the Generate Barcodes on A4 button to create a printable page of barcodes containing all the serial numbers of your assets. 4) You can then print the barcodes on a laser or inkjet printer with an A4-sized paper, and stick these barcodes on your assets.  5) When you need to retrieve the information of a particular asset, you can set the keyboard focus on the Enter Serial Number (or Scan Barcode) field, and point your scanner at the barcode that is sticked onto a particular asset. 6) When a barcode is scanned, its serial number will be automatically used to retrieve the information of that asset.