How to write a macro in google sheets?

Question

Macros

There is a table with a tabular specification. The table is formed (currency, quantity) through If, and the data range is obtained.

The task is this. A person enters the table, selects the desired data set, and then he just needs to download the generated table (or this range) in a separate .xlxs file.

I made this method
1st macro - generates a new sheet, inserts data there and brings them into a beautiful view
2nd macro - must save this sheet in a separate xlsx file
3rd macro - must delete the created sheet so as not to produce entities

1 th written.
The second one has problems.
3rd - while I'm worried about the active sheet, but I think this can be solved. But what to do with the preservation - I'll never know.

Answer 1

File - Publish to the Internet , select the desired sheet and the desired format . You can download the file from the link provided.