Question about Microsoft Office Standard for PC
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...
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
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
The default Excel
file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets
(.xlm files in Excel 4.0).
Uses the same basic
XML format as the Excel Workbook, but can store VBA macro code. Users saving
an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in
Excel 4.0) are prompted to use this file format.
The default file
format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro
sheets (.xlm files in Excel 4.0).
Can contain a
VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0).
Workbooks created from this template inherit the VBAProject part or Excel 4.0
macro sheets that exist in the template.
program that runs additional code. Excel add-ins use the Open XML file format
to store data, and they support using VBA projects and Excel 4.0 macro
Feb 21, 2011 | Computers & Internet
Sep 06, 2009 | Computers & Internet
Apr 15, 2009 | Microsoft Computers & Internet
Oct 09, 2007 | Microsoft Office Standard for PC
188 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: