Good afternoon all.
I have a spreadsheet with 5 tabs of various names all with a table in.
They have various details in the tables all with a common key (TempID). I have some code that I found from some nice person on youtube which when I type into cell Bx it populates cell Ax with the next consecutive number from the cell above and the table automatically expands a row as per normal.
The tables are all exactly the same number of rows, all with the same start point in the top left (A1).
My question is... when I add my new record to the first sheet and the new row is added, is it possible to code an addition to the rest of the tables. i.e. AddNewRow to table2, table3, table4 etc.
Or am I just dreaming? I have searched and not found anything about adding rows across tables in a workbook automatically.
Thanks for any comments and suggestions.
I have a spreadsheet with 5 tabs of various names all with a table in.
They have various details in the tables all with a common key (TempID). I have some code that I found from some nice person on youtube which when I type into cell Bx it populates cell Ax with the next consecutive number from the cell above and the table automatically expands a row as per normal.
The tables are all exactly the same number of rows, all with the same start point in the top left (A1).
My question is... when I add my new record to the first sheet and the new row is added, is it possible to code an addition to the rest of the tables. i.e. AddNewRow to table2, table3, table4 etc.
Or am I just dreaming? I have searched and not found anything about adding rows across tables in a workbook automatically.
Thanks for any comments and suggestions.