Update From Form to Log Sheet

[mdasifiqbal]

Dear Members

I have attached a format, of form data that is fed in the cells of form after update populates in the Log sheet under the same heading and the form get refreshed for another set of data, can any one help me with this

Regards

Md Asif Iqbal

[JBeaucaire]

For things like this I prefer an onscreen indicator as to whether the current data has been transferred or not. So I added that in B10. As long as B10 doesn't say "YES", the macro will run. This is the formula in B10:
=IF(ISNUMBER(MATCH(B3, Log!B:B, 0)), "Yes", "No")

The macro:

Please Login or Register  to view this content.