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 do you add a username or author to a worksheet - Guide
Automatically run a macro when opening a worksheet - Guide
Excel vba copy worksheet to another workbook without opening ✓ - Excel Forum
Vba copy data from one workbook to another - 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

How to specify macro for current active sheet

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

Automatically transfer data from one sheet to another

Macro-Copy data from one workbook to another

Comparing Two Excel Sheets and copying like data to third sheet

Similar discussions

Subscribe To Our Newsletter!