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 automatically transfer data between sheets in Excel - Guide
Vba copy data from one workbook to another - Guide
Excel vba add worksheet - Guide
Run macro on opening workbook - Guide

1 response

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)

How to specify macro for current active sheet

Copy range data in a column to new column.

Macro-Copy data from one workbook to another

Similar discussions

Subscribe To Our Newsletter!