I have created a workbook for asset history where each asset has its own worksheet which needs to be continually updated as assets are utilized.
For of data entry I would like to have a single input table where usage and data on multiple assets can be entered at one time . I am looking for a method send the data including header data to the specific asset worksheet
The worksheet name will be the asset id
Input Table.PNG
Bookmarks