Code to attach to button to autmatically import a template sheet

[adamgm]

Is this possible?
I have a workbook in which I would like to be able to import a new sheet of each month... not sure how to do this.

[Logit]

.
Paste this code into a routine module:

Please Login or Register  to view this content.

[adamgm]

Thanks very much. Instead of a selection, can I specify the exact sheet within the code, instead?

[Logit]

Please Login or Register  to view this content.

[adamgm]

Awesome!
Last question... what if I always wanted to put the sheet before or after another specific sheet?

[Indi_Ra]

Awesome!
Last question... what if I always wanted to put the sheet before or after another specific sheet?

Hi,
This is to put sheet before:

Please Login or Register  to view this content.

and this is for after:

Please Login or Register  to view this content.

[adamgm]

Hi,
This is to put sheet before:

Please Login or Register  to view this content.

and this is for after:

Please Login or Register  to view this content.

I was having trouble with the exact syntax, but I get it now, I had to edit within the brackets for the sheet name.

[Logit]

Thanks for the Add Rep