So i have 4 different tables with a set amount of columns each (2 with 2 columns and 2 with 3 columns. all are named differently). The thing is that if i get a new item i need to enter its itemnumber in those 4 tables in the respective row.
Is there a way with a macro to fill the cells of my choosing with the value i want them all added in?
What i picture is a radio button for each table. is it possible?
After i have chose in what columns i want this calue to be copied to, the value should then be deleted and be ready for a new value to be added.
The tables are not all equally full, so adding the value in a new row of a table cant be the answer. So basicly it needs to write in the next free cell in the column and if there isnt a free cell it needs to create a new row for the table. If that makes any sense..?
Is there a way with a macro to fill the cells of my choosing with the value i want them all added in?
What i picture is a radio button for each table. is it possible?
After i have chose in what columns i want this calue to be copied to, the value should then be deleted and be ready for a new value to be added.
The tables are not all equally full, so adding the value in a new row of a table cant be the answer. So basicly it needs to write in the next free cell in the column and if there isnt a free cell it needs to create a new row for the table. If that makes any sense..?