I want to unite the macro to which data is moved to file and to file of Excel how should I do though want to m [...]…