My Problem is:
The Worksheet "Stock" is just for viewing data and no inputs are to be done.
Structure of my excel file.
Upon clicking Add Button, VBA Form opens up. This form adds the data to the next sequence sr. no. row.
It also duplicates worksheet "Blankformat" and renames it to the Sr. No. generated by it in the previous step.
So couple of worksheets names 1,2,3,4,5..... will be generated.
I want to built-in the same VBA Form the ability to assign formula to the "Stock" cells and pull the data from Worksheets 1,2,3,4,5,...
Cell(4,2), Cell(4,3), Cell(4,4), Cell(4,5) etc of WS("Stock") to be assigned formula =C2, =C3, as so on. of WS 1
Appreciate help in this case.