Copy worksheet from one workbook to another workbook in MS Office Excel

Closed

SrinivasNittala - Updated on Dec 28, 2018 at 08:27 AM
Blocked Profile - Dec 28, 2018 at 10:16 AM

Hello,

In the Move/ Copy dialogue box, the destination workbook is not visible to copy the worksheet from the source file.

To copy a worksheet from one workbook to another, begin by opening
Transfer data from one excel worksheet to another automatically - Guide
How to copy data from one excel workbook to another using macro - Guide
How do you add a username or author to a worksheet - Guide
Automatically run a macro when opening a worksheet - Guide

1 reply

Answer 1 / 1

Blocked Profile
Dec 28, 2018 at 10:16 AM

Check for its existance with:

Function sheetexist(whatsheet)
On Error GoTo NotExists

ThisWorkbook.Worksheets(whatsheet).Select
sheetexist = True
Exit Function

NotExists:
sheetexist = False

End Function

Similar discussions

Copy Worksheet to another Workbook (unopened)

copy a row from one worksheet to another, based on criteria

Comparing Two Excel Sheets and copying like data to third sheet

How to specify macro for current active sheet

Create multiple copies of excel based on a single template

Macro to compare 2 sheets and copy differences

Similar discussions

Subscribe To Our Newsletter!