Attached is a file with a VBA Module (CreateNewDataSheets
) that needs modified. The code will create a new worksheet for each city group within "HandHeld Info
." It also creates a Table of Contents. The workbook only contains the first City created.
This city cotains a mockup of how the individual data should be formatted and a Barcode is also added (Column G). The Font for the barcode is 3 of 9 Barcode
. Currently, no barcode is inserted when the code runs.
This how all of the City Pages should look after the code is run. I would also like for the barcode formula to actually be added to the barcode cells.