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.

Copy worksheet to another workbook
Transfer data from one excel worksheet to another automatically - Guide
Vba copy data from one workbook to another - Guide
Add worksheet vba - Guide
Hyperlink in excel to another worksheet - Guide
Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as named ranges. ✓ - Excel Forum

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)

Automatically transfer data from one sheet to another

Create Multiple Workbooks With Template At Once

How to specify macro for current active sheet

VBA Code to Copy Worksheet multiple times and rename based on list

Similar discussions

Subscribe To Our Newsletter!