Hi excel expert,

I have travel form like this  in cell A1:Purpose

A2:Reason

A3:Date of departure

B3:Vehicle

C3:Province

A5:Date of arrival

B5:Budget

C5:District

I want to use macro to run if every i input data in Cell B1,B2,A4,B4,C4,A6,B6,C6 it will copy to rows C8:J8 downward....

I hope this clear for your help

Sorry for no having file.

Regards,