Macro for copy and past of sheets for xcel file

March 14, 2015 at 02:13:30
Specs: Windows 7
I have many excel files with 4 sheets in it (say sheet 1, Sheet 2..sheet 4). I want to copy and pase sheet 3 of every excel files to a new excel sheet so that the new excel sheet contains the sheet 3 of every excel files. could any one help me in finding a macro for it or any other shortcuts??

See More: Macro for copy and past of sheets for xcel file

Report •

#1
March 14, 2015 at 03:46:59
re: I want to copy and pase sheet 3 of every excel files to a new excel sheet so that the new excel sheet contains the sheet 3 of every excel files.

A sheet is a single sheet within a workbook. A workbook is a file that can contain one or more sheets.

You said that you want a new Excel sheet. Do you want to create one big sheet with all of the data from the other Sheet 3's in that sheet or do you want to create a new Workbook containing all of the Sheet 3's as separate sheets?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question