I have scoured the forums, and have come across a few options that are close to what I'm looking for. But, I'm beginning to think that its probably not possible.
I have a sheet that has multiple tables on it. Id like a button on each table that says "Add New Row". When you click on this, it will copy all of the formulas and drop-downs, and create a new blank row. The one thing that I know will be an issue with this is that as a new row is created for Table 1 (at the top), everything below it will shift down...including the buttons associated with the other tables.
Here is an example of what my sheet looks like, and where I was thinking the button placement would be:
Thanks so much ahead of time for looking at this. If it's not possible, I totally understand. Honestly, the default method of Inserting a new row isnt that cumbersome. But I figured that adding a button would be pretty awesome.
and, as menthoned, some of the cells have formulas, and others are drop-down lists. Thus, formulas would need to be copied to the new row.
-Bobby
I have a sheet that has multiple tables on it. Id like a button on each table that says "Add New Row". When you click on this, it will copy all of the formulas and drop-downs, and create a new blank row. The one thing that I know will be an issue with this is that as a new row is created for Table 1 (at the top), everything below it will shift down...including the buttons associated with the other tables.
Here is an example of what my sheet looks like, and where I was thinking the button placement would be:
Thanks so much ahead of time for looking at this. If it's not possible, I totally understand. Honestly, the default method of Inserting a new row isnt that cumbersome. But I figured that adding a button would be pretty awesome.
and, as menthoned, some of the cells have formulas, and others are drop-down lists. Thus, formulas would need to be copied to the new row.
-Bobby