1
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.
Regards
Bhupendra
HR (Payroll)
Noida
From India, Delhi
REPEAT THIS EXERCISE FOR ALL THE SHEET.
Regards
Bhupendra
HR (Payroll)
Noida
From India, Delhi
Dear Sir
You are telling about different Excel sheets into one workbook.
But my question is how we can merge the data of different excels into one excel sheet.
# Suppose two salary sheets for the month of Jan\'14 and Feb\'14 in two different Excels but want the data in one excel like the salary sheet of Feb\'14 below salary sheet of Jan\'14 in one excel.
Regards
Neha
HR (Payroll)
Noida
From India, Delhi
You are telling about different Excel sheets into one workbook.
But my question is how we can merge the data of different excels into one excel sheet.
# Suppose two salary sheets for the month of Jan\'14 and Feb\'14 in two different Excels but want the data in one excel like the salary sheet of Feb\'14 below salary sheet of Jan\'14 in one excel.
Regards
Neha
HR (Payroll)
Noida
From India, Delhi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Template Sheets.zip