Hi

I have created a macro which will format the data as per my requirement and it is working fine. Now I want to make some modifications to it please help.

After running my macro, I will use the formatted data to do some tasks and later I will export the entire data to a master file manually by copying and pasting to a master file which is in another loction, Now I want to insert a button which will export the data to a master file automatically.

What I am looking for -
After my macro formats the raw data my macro should insert a export button which will export the data in the sheet to master file when I click it.

Export button should be automatically inserted on a file whenever i run my macro on any sheet. Please help