Macro for data entry....

[jaysakle]

Dear Experts,

Greetings!

I am trying to develop a macro for data entry.

My logic is that, data entered in the 'table' which on first sheet should automatically transfer in second sheet which is 'Master list" when I press the submit button and after pressing the 'submit button' table on the first sheet shall become blank for next entry.

The data is name of the students and marks obtained in the respective subjects.

How i can develop. Kindly guide. I have attached 'Book 7" for your kind reference.

Regards.

[Naveed Raza]

Hi Jay

try this attached file

Hope this Will Help

[Naveed Raza]

Hi Jay

Try this attached File

Hope this will work

[jaysakle]

Dear Naveed,

Thank you very much for the help.

Unfortunately the code not working properly

[jaysakle]

Dear Naveed,

I tried a lot.....still the code not responding....!

Regards.....

[Naveed Raza]

Ok let me check

[Naveed Raza]

Now try this attached file

[adyteo]

Book 7.xlsmtry the attached file

[jaysakle]

Dear Naveed,

The code is working nicely and satisfactorily....

Thank you very much for the great help.....

Regards...

[Naveed Raza]

Glad i could help you

If the suggestion helps you, then Click * to Add Reputation