I will enter data in a row I select that row when I click the macro button the row should sit on next sheet first row and should increment daily
E.g.
name, service_no, load, deposit, section
When the details are entered in the first sheet and submit button clicked the load sheet will have to...