How to add extra row to three different sheets with one macro?

[ncgarcez]

Hi everyone,

Couldn't find a question and answer with what I need, and couldn't improvise with similar ones, so I'm posting my problem below.

I currently have a spreadsheet with three tabs. Each sheet contains a different table, but all have in common is their location. First sheet contains address information, second and third sheet have different information regarding same location was first tab. Each location is assigned a number. So instead of repeating address on second and third sheet, only the location number would show up as reference. I'm uploading a simplified example of what the spreadsheet would look like.

I'm just trying to add a button with a macro that would add a new row to the table in all sheets, adding a number to the location. If someone could help it would be great!

Thank you!

 

[vw412]

Is this the scenario you want to do?

Add new location to tab 1 to the end of the table giving it the next sequentional location number. Add a new row in Tab 2 and Tab 3 at the end of of each table placing the new location number into each.

 

[ncgarcez]

Is this the scenario you want to do?

Add new location to tab 1 to the end of the table giving it the next sequentional location number. Add a new row in Tab 2 and Tab 3 at the end of of each table placing the new location number into each.

Hi, yes. Exactly that.