Asset Management

Hi

I need to management Asset Management (New Assets, Asset Movement, Asset Disposal). Previously I had three seperate spreadsheets to do this.

I extracte the common field names between the three sheets and now I want to macro to copy selected rows from one sheet to another with the formatting to either capture (New Asset, Asset Movement, Asset Disposal).

The spreadshet I am using to capture the form is called "Capture". I have three check boxes as well. When the user clicks on either one of the checkboxes, I want relevant row from "Input" to copy and therafter user will capture the relevant information.

I have attached the spreadsheet that I require help with.

Thanks