Copy Each Table In A Sheet To Other Sheet

[Peter Quill]

Hello Everybody,

I have a sheet (name : source) that fill with several small table, kindly help me how to copy each table to other sheets (name : template) and print it, and clear the table before next table copied to template, till the last table. Thank you for your help.

Regards.

 

[Gasman]

I tend to record a Macro and then amend to suit.
If that does not work I then use Google

Sometimes that even brings up a video, if words are not enough.
Actually lots of videos on Access on Youtube.

However the first method usually works for me.