Good morning dear Helpers,
I asked precedently on this forum to synchronize in mirror tables from several sheets and the response was great and very efficient.
I then tried from the result to change the ranges of the VBA code by group names so that if "Team" users add a rows in one of the tables, it automatically adds it to the main one, and vice versa.
It didn't work, it doesn't reconize the range.
For exemple, if I need to addor even delete a row or a column, it would auto-do the same in the linked table...
Erro 1004...
Edit :
Why would a row or column be needed/deleted?
I'm working on a budget divided into several departments.
Rows represent team members (wuth different salaries), and sometimes we need to add or remove some.
I first put an automatism (with a button) which automatically hide the empty lines but then it's difficult to add them (or with another button)...
Where in the table would the row or column be added/deleted?
Anywhere beetween the first and the last of each block...
Would it be acceptable to have buttons on the worksheet
(Add / Delete)?
Yes indeed. Tut I didn't find a clear solution with an effect on both sheets.
Thank you very very much for your help and your time !
Tdy