I am creating a workbook for asset history where each asset has its own worksheet. This is continually updated as assets are utilized.<o
></o>
For of data entry I would like to have a single input table where usage and values on multiple assets can be entered. I am looking for a VBA code that will copy the header data along with the values associated with the specific asset to its specific page. <o></o>
The worksheet name will be the asset id
<tbody>
</tbody>
></o>For of data entry I would like to have a single input table where usage and values on multiple assets can be entered. I am looking for a VBA code that will copy the header data along with the values associated with the specific asset to its specific page. <o
></o>The worksheet name will be the asset id
| Job # | 12AB | Date | Dec | Location | There | |
| Operator | Jack | Operator 2 | John | Client | Him | |
| Asset ID | Usage 1 | Usage 2 | Value 1 | Value 2 | Val 3 | Comments |
| 12345 | ||||||
| 23456 | ||||||
| 34567 |
<tbody>
</tbody>
