Build VB for excel sheet
Budget: $10 – $30 USD
1-Add the Button on this sheet called"Generate".
2-when I click on "Generate" create sheet 2.
3-Check the models and models number "in sheet 1.
4-Unmerge all data in the columns [Div., Main Item, Sub Item].
5-Fill in unmerged cells with their value "Copy the valus in cell in Div., Main Item, Sub Item and paste it on the blanked cells till the down new values and recurring this step to replace all unmerged cells to have a value that in the merged cell".
6-Duplicate the rows that started on a row with considiring the model number.
7-Add model-related amounts into Amount column in sheet2.
2-when I click on "Generate" create sheet 2.
3-Check the models and models number "in sheet 1.
4-Unmerge all data in the columns [Div., Main Item, Sub Item].
5-Fill in unmerged cells with their value "Copy the valus in cell in Div., Main Item, Sub Item and paste it on the blanked cells till the down new values and recurring this step to replace all unmerged cells to have a value that in the merged cell".
6-Duplicate the rows that started on a row with considiring the model number.
7-Add model-related amounts into Amount column in sheet2.