Hi
I need help on this topic. thanks in advance.
I have a master list ( sheet 1 ) and there are close to 45-50 sheets. There is an "add" button on the sheets 2 and it pulls up userform and it can be used to update value on the row. Now the thing is if there is a value assigned say egg ( as in my case, its menu costing ) which has a cost of 6 now on the master list. what macros can i use say for instant the value for egg should not have been 6 but 8. And since the entire sheet ( 45-50 in all ) is filled by the value of 6 as per master list, how can i make sure that if i just update the value of egg to 8 in the master list, all the corresponding sheets where the value of egg is update as 6 automatically gets updated as 8.
am attaching the excel sheet
Bookmarks