Google Sheet Macros

• There are no specific macros in google sheet.
• Every auto data validation or auto data retrieve is done by script.
• An running that script.
• There are only two types of macros
• Push Button.
• Drop Down.
• In Below, I used script to represent buttons and drop down.

Button:

• Draw a button.
• Insert > Drawing > Drawing Window > Shapes.

• Insert "Button" on a sheet.
• Write a script to make button function.
• Tools > Script > Editor box.
• Write desire script .
• Click on button, open assign script.
• Assign function name of script in dialog box.

Drop Down List:

• Make ready the sheet from where you want the information.

• Need to create Data Validation.
• Data > Data Validation > Pop Up Cell.
• Select Desire Cell Range of Drop down.
• Select the the Place of Drop down values.

• To automatically validate and invalidate drop down in next cell, used script.
• Open Script and write desired output functionality.

• To retrieve third column by selected names, I used Vlookup.