View Image

Use Worksheet option: -User start the MS excels Tool and blank workbook page will be open. User click on Insert Worksheet option from at bottom left corner of the excel window. *Tool has functionality to write and select content option which you want to transfer in worksheet. *Using Ctr+ Click key user can select that sheet that you want input the content in. *Navigate to home will button in toolbar and choose across worksheets option of the menu. *After selecting a new windows window becomes and gives option to select one of this. *Now finally your content will convert into sheets. Create a group of multiple worksheets: -To use of this method firstly creates a workgroup following these steps. *Drag the mouse at any sheet and right click and user Select All Sheet option. * That feature creates a workgroup in workbook. *After that you can insert data in any sheets, which will appear in all worksheets. *Copy and paste Worksheets: -In this method you need only one worksheet, all the information can be shared into multiple sheets to the following some steps. *Put your data in worksheet and arrange according to your need. *Click on the right side of the worksheet and select the option moved or copy. * Create a copy in move or copy windows for checking the checkbox. *Now new excel sheet in created and sheet contain all information of as previous one. Send Data using VBA macro to any worksheet: -In a MS excel user can enter same text data into many sheets without using of copying and paste option. VBA macro is advance technology to use copy and paste the text into the other worksheets. *Create a sheet1 new worksheet in window and enter the data. *Using an insert button option creates another worksheet and press F11 button new windows will be pop up. *Click on the VBA project option, choose insert option and click module button. *User Input the code into module windows and after pressing F5 button same content will show on another worksheet.