I have an Excel document containing forms. I am required to populate the first worksheet with data and the other worksheets would have values taking reference from the first worksheet.
I am taking reference from the following sample code:
I managed to write the value to the first worksheet. However these values are not reflected in the other worksheets. It is only updated if i click the cell.
Any advice is greatly appreciated.