How to copy and paste values from worksheet to another sheet

[roobsrobs]

Hi,

Good day!

Please help to create a vba code to copy input values from On-call Log form sheet to On-Call Logs sheet. Please see attached file.

Thanks in advance!

[Logit]

.

Please Login or Register  to view this content.

[roobsrobs]

Thank you! Exactly what I need!

[sintek]

Are you going to manually populate the number formats and formula's for the cells each time...

Please Login or Register  to view this content.

Edit...Not to worry...Just notice that Logit upload had been converted (Columns changed around and All columns preset to formats)

[Logit]

.
You are welcome.

[roobsrobs]

Done! Thank you!