May be I am missing something (suggestions are most welcome) but to achieve these I am going with the new workbook approach.
Steps:
1> Login to Discoverer Desktop
2> Open all the workbooks you want to merge
3> Now click the 'Restore Down' button (with Double square symbol ) of the last opened workbook.
> You can see all the opened workbooks in the same window.
4> select the 1st worksheet of the 1st workbook and drop into the vacant space of the window with 'Control' button pressed.
Note: Without 'Ctrl' it will completely move the sheet from workbook, with 'Ctrl' it will just copy the sheet from the workbook
> So 'Ctrl' button pressed and left click on the worksheet and drag to the vacant area.
>> It will create a new workbook with that worksheet, do the same drag and drop for other worksheets from all the workbooks to the new workbook.
>> Save the new workbook with the name as required.
>> At the end, share this workbook to the respective users.
Related Post: Renaming Discoverer Workbooks
Steps:
1> Login to Discoverer Desktop
2> Open all the workbooks you want to merge
3> Now click the 'Restore Down' button (with Double square symbol ) of the last opened workbook.
> You can see all the opened workbooks in the same window.
4> select the 1st worksheet of the 1st workbook and drop into the vacant space of the window with 'Control' button pressed.
Note: Without 'Ctrl' it will completely move the sheet from workbook, with 'Ctrl' it will just copy the sheet from the workbook
> So 'Ctrl' button pressed and left click on the worksheet and drag to the vacant area.
>> It will create a new workbook with that worksheet, do the same drag and drop for other worksheets from all the workbooks to the new workbook.
>> Save the new workbook with the name as required.
>> At the end, share this workbook to the respective users.
Related Post: Renaming Discoverer Workbooks
ReplyDeleteYour blog is very nice and provide me informative content thanks for sharing for more information about Copy Worksheet