First open a blank workbook (let suppose name is TEMP) then open the excel file whose sheet you want to merge in to one file (let suppose name is XYZ). Then from the bottom of workbook select the sheet you want to merge (let suppose name is SHEET1) right click in to sheet name and select the option MOVE OR COPY. A new little window will appear from the “To Book” option select the workbook in which you want to merge (i.e. TEMP) then tick on “Create a copy” option. Then click OK.
REPEAT THIS EXERCISE FOR ALL THE SHEET.
I am Herewith posting Advanced Excel details.
Please find the attachment.
1. Save as “Microsoft Office Excel Add In” file.
2. Open Excel > Tools > Add Ins..
3. Click on “Num To Word” Press Ok.
4. Now you can use this function from: Excel > Insert > Function > User Defined.
Note: This function will not work in other PCs where it is not installed.
This example demonstrates how to create a summary sheet of data from a number of sheets. Relevant data should be in the same position on each sheet.
Here is another way to highlight data status using traffic lighting.
This technique also uses conditional formatting as its basis, but unlike the previous traffic lighting example.
A traffic light image is overlaid on top of conditionally formatted cells to give an immediately familiar visual effect.