Hi Anyone,
I need som help on my problem. I have 4 tables (To Order/Ordered/Received/Payed) with some fruit for example. On the left side of each row there is a changeable list for the condition of the item in that row. Each row in each table has to have the option to be manually filled inn. So this means no formula's in the cells. For that i suppose i have to work with VBA on the "Worksheet_SelectionChange".
This is what i want:
1) I fill in a new fruit in the table "To Order" (i set the condition for that fruit to "To Order")
2) If i ordered that fruit, instead of copy/paste, i just want to change the condition of that fruit to "Ordered" and then that item has to move automaticly to the first blanco line in the table "Ordered". (and disappear in the table "To Order".
3) If i received that fruit, instead of copy/paste, i just want to ........... (i think you see what i mean, from one table to another just by changing the condition)
I must have the option to manually fill in a row in each table.
Hopefully someone can see a solution..
(here an example)
I need som help on my problem. I have 4 tables (To Order/Ordered/Received/Payed) with some fruit for example. On the left side of each row there is a changeable list for the condition of the item in that row. Each row in each table has to have the option to be manually filled inn. So this means no formula's in the cells. For that i suppose i have to work with VBA on the "Worksheet_SelectionChange".
This is what i want:
1) I fill in a new fruit in the table "To Order" (i set the condition for that fruit to "To Order")
2) If i ordered that fruit, instead of copy/paste, i just want to change the condition of that fruit to "Ordered" and then that item has to move automaticly to the first blanco line in the table "Ordered". (and disappear in the table "To Order".
3) If i received that fruit, instead of copy/paste, i just want to ........... (i think you see what i mean, from one table to another just by changing the condition)
I must have the option to manually fill in a row in each table.
Hopefully someone can see a solution..
(here an example)