Data collection Sheet help

[aeancxcs]

Hello everyone,

I am newbie to VBA. Could anyone enlighten me how to program my data collection sheet? I have attached my sample excel file. Basically, once submit button is pressed in “data entry” sheet, record sheet will create an entry per row per employee, and if data is zero, no entry is created. I know I can use excel data entry form, but data entry form treats employee as a variable and there would be a drop down selection list for each employee. That’s not what I need. We want to list every employee on the data entry sheet. How do I do this? Any help is appreciated.

Thanks!

[sintek]

Hi aeancxcs

Welcome to the Forum...Here's one way...

Please Login or Register  to view this content.

Edit....OR

Please Login or Register  to view this content.

[aeancxcs]

Thanks Sintek!

That's works! After i click to execute, the rows selected are shown in data entry sheet. Can we make selection indication disappear?

[sintek]

Can we make selection indication disappear?

see red part in post2

[aeancxcs]

great! thanks.

[sintek]

Glad I could help...Thanks for rep +
Pls mark thread as solved...

[aeancxcs]

Sinteck, I am almost done with my data collection sheet. Only one thing left. How do I reset the data entry form after I click submit? For now, logged values are still there and can be confusing.

[bakerman2]

Add this at the end of the code.

Please Login or Register  to view this content.