Copying tabs (which mach the name of tabs in cuurent workbook) from another workbook

[stevoDE]

Hi

I have started writing a macro with the code as follows:

Please Login or Register  to view this content.

Let's say sheets 1-3 in the Template workbook have been renamed Jan-17, Feb-17 & Mar-17. What I want to do is copy from the 'File' workbook the macro has opened the tabs which match the names of these tabs (i.e. Jan-17 etc.) and paste in to a cell (let's say A4) of the respective tabs of the Template workbook. This is a template so the names the tabs will change whenever the macro is run.

I hope this makes sense.

Thanks in advance

[Norie]

Will each worksheet in the template workbook always have a corresponding worksheet in the other file?

[stevoDE]

It will indeed.

[stevoDE]

*edit * Not all, only the first 3 sheets.

[Norie]

Perhaps something like this.

Please Login or Register  to view this content.

[stevoDE]

Is that going to work off the back of my edited post information Norie? I'm guessing not as there won't a corresponding sheet for the other tabs after sheet3.

[Norie]

No, didn't see the edit.

Try this.

Please Login or Register  to view this content.

[stevoDE]

Thanks Norie. That seems to work.

Another couple of questions if you don't mind. Does the variables wsDst and wsSrc do/mean something specific as I get an error when I replace those variables with my own? I notice there is no use of paste or destination:=? If I wanted to only paste the values and formats, how would I amend the code here?

[Norie]

The names of the variables aren't really relevant but I tend to try and use something that's kind of descriptive, eg wsDst- destination worksheet, wsSrc - source worksheet.

In the code it's a straight copy which only requires one argument, destination, so being lazy I've ommitted the Destination:= part.

If you wanted to copy and then paste values/formats/whatever it would look something like this.

Please Login or Register  to view this content.