Question about Microsoft Office Standard for PC

1 Answer

Consolidate few sheets under 1 excel


I have 8 to 10 excel work sheet which I need to consolidate together & preapare 1 master file for tht I have to open each n every file 8 to 10 times n copy all the data n paste in master file.To avoid all this mannual work is there any way to do this automate.
Is it possible to do Record Macro...


Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 265 Answers
Re: consolidate few sheets under 1 excel

What version of Excel are you working with. Newer versions allow you to have multiple spreadsheets grouped together into what is called a, "Workbook." To view the sheets separately, you simply click on the tabs at the bottom of the workbook. The easiest way I know of to join spreadsheets together into a single workbook is to open all of them at the same time, then choose, "View / Arrange All," and they'll be small, but you can grab each one by its tab and drag it to the workbook you want them in. Then you save the workbook (give it a new name like, "Accounting Roll-UP," or, "Consolidated Books," or whatever best describes it) making sure to close all the (now empty) spreadsheets without saving your changes to them (or else you'll lose your 'back-up' data). Voila! You open one file, and all your spreadsheets are available with the click of a mouse.

Posted on Dec 18, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

Merging problem

Use the Help function in excel and search for "Consolidate". This will show you how to consolidate data from multiple worksheets into one worksheet.

Feb 19, 2009 | Microsoft Excel for PC

1 Answer

Minimize Data Entry

I will suggest you to create small application in .net for ths which will add some value and process your data;If you want to use Excel only make a master sheet with details and use it in other excel sheets

Jan 02, 2009 | Microsoft Excel for PC

1 Answer

Excel 2003 / 2007 vba code

A similiar thing happened to me once and I used the format
"Sheets("Lab Work Order Master").Copy(,ActiveSheet)" instead of
"Sheets("Lab Work Order Master").Copy After:=ActiveSheet"

You may also want to try using a sheet index instead of "ActiveSheet" to refer to your sheet.
P.S. Don't forget to rate me. Wish you the best.

Oct 17, 2008 | Microsoft Office Standard for PC

4 Answers

How to Export trial Balance from Tally 9.2 version to Excel sheet

you select the trial balace--and press Alt+E or click export---then the export details screen came,

Language: Default(all language)
Format: Excel (spreadsheet)
Output file name: trial bal.xls (any name you select)

Excel (spreadsheet) formating: yes
other details you select and accept the screen. then minimise or close the Tally, you open the tally file name at my computer. at the time you can see the file trialbal.

Mar 20, 2008 | Business & Productivity Software

2 Answers

How to Crack Excell sheet's Password

Mar 03, 2008 | Business & Productivity Software

1 Answer

Hi friends

Have all worksheets open including the one that is to be the tally sheet.
On the tally sheet, select a cell that you want to link to one of the other sheets and press the equals signto begin the cell formula. Without pressing the enter key, click on the cell in the other worksheet that you want to show up in your tally sheet.
Press enter to complete. This will link that cell in the two worksheets together as long as the spreadsheets remain stored in the same places.

Dec 24, 2007 | Microsoft Excel for PC

1 Answer

Consolidate few sheets under 1 excel

It is actually very simple on the new worksheet in the first row just type:
in cell - A1: =[Book1]Sheet1!A1
in cell - B1: =[Book1]Sheet1!B1
in cell - C1: =[Book1]Sheet1!C1

Where Book1 is the worksheet(filename) and Sheet1 is the sheet with the data, just drag down the results with the magic square and continue to do so on all of your data worksheets.

Let me know if you need more help

and Please use our community and not emails

Good luck


Dec 18, 2007 | Microsoft Excel for PC

1 Answer


There is an easier way. in your workbook with the worksheets to consolidate, insert a new blank sheet. from the DATA menu, select consolidate. click ADD and go to the first sheet, select the required information (best to select all headings aswell). Continue this procedure for each sheet. at the bottom of the Consolidate dialog box, check all three options for links. and click OK. This should now give you a consolidation of all your sheets.

Hope this solves your problem

Oct 09, 2007 | Microsoft Office Standard for PC

4 Answers

Forgot password

Try this link It should help you unlock the Excel file and break the password. Good luck

Sep 02, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

179 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18257 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides