Home » Forums » Open Source Learning Center » Question and Answer

Copy all the sheets from Source excel to Destination Excel with same sheet names and data

Submitted by ontedhusatish on 7 November, 2012 - 13:08

Hi,

I have an excel sheet provided by X . I want copy all the sheets which contains the data from X to Y which is having VBA code.Can you please help me to help me out.

‹ VBA EXCEL With AIX Server Patch Checking( Newbie Lv 0 knowledge) Hiding a sheet forever from end users ›
»
Almir's picture

Copy all the sheets from Source excel to Destination Excel with

Submitted by Almir on 7 November, 2012 - 14:24.

First, open both X and Y files. In X file Select all sheets, right-click, Move or Copy, choose "Y file" as destination file, check "create copy" check box, click OK button.

»