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

**stevoDE** · 06-27-2017, 10:27 AM

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** · 06-27-2017, 10:34 AM

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

**stevoDE** · 06-27-2017, 10:35 AM

It will indeed.

**stevoDE** · 06-27-2017, 10:36 AM

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

**Norie** · 06-27-2017, 10:39 AM

Perhaps something like this.

Please Login or Register  to view this content.

**stevoDE** · 06-27-2017, 10:51 AM

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** · 06-27-2017, 10:53 AM

No, didn't see the edit.

Try this.

Please Login or Register  to view this content.

**stevoDE** · 06-27-2017, 11:24 AM

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** · 06-27-2017, 11:45 AM

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.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Copying tabs to new workbook with Macro

Creating new workbook using a template and copying tabs

[SOLVED] VBA code to merge multiple sheet with multiple tabs into one workbook in different tabs

Linking One Workbook with Multiple Tabs to Master Workbook Formula

[SOLVED] Extract data from a workbook with multiple tabs, into a workbook with corresponding tabs

Problem copying multiple tabs to a new workbook

Select sheet tabs in workbook & save to separate workbook files

Bookmarks

Bookmarks

Posting Permissions