• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 189
  • Last Modified:

Add a new row by clicking a cell.

Add a new row by pressing a button.  Here is a video description http://screencast.com/t/5y1liKJoZTw and the link to the actual page https://docs.google.com/spreadsheets/d/17tR99ldMbQKWXZVXIL7efJJzunq26-xtVu1wGNyadOE/edit#gid=0
0
frugalmule
Asked:
frugalmule
  • 3
  • 3
1 Solution
 
Glenn RayExcel VBA DeveloperCommented:
You would need a drawing object with a script to do this.  Unfortunately, you can't record macros with Google Sheets.  Instead you have to use Google Apps Script to develop such applications.

-Glenn

Reference:
https://developers.google.com/apps-script/
0
 
frugalmuleAuthor Commented:
I'm ok with that approach.  What do I insert and where?
0
 
Glenn RayExcel VBA DeveloperCommented:
I'm sorry, I'm a dead-end here. I've not developed any Apps Scripts.  :-(

Check the online help in GoogleDocs/sheets..type "Record macro" and see the short article about Apps Scripts.  There are some free beginner courses online that may help.

-Glenn
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
frugalmuleAuthor Commented:
thanks
0
 
Glenn RayExcel VBA DeveloperCommented:
Sorry that I couldn't provide more-direct assistance.  I'll probably start developing Apps Scripts in the next year as more folks use Google Sheets.
0
 
frugalmuleAuthor Commented:
Yeah, I wish I knew as well.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now