98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Consolidating sheets
Consolidating sheets
Resolved · Urgent Priority · Version 2003
Jatinder has attended:
Excel Intermediate course
Excel Advanced course
Consolidating sheets
Hello,
I have 15 worksheets which have 4 column headings.
name, product, address1, and postcode.
all 15 sheets are set in the same way. .
how can i consolidate them into one?
it doesnt matter as such wot order cos i can organise them through filters.
Thanks
RE: Consolidating sheets
Hello Jatinder
Thank you for your post.
What is your aim in consolidating this data? Do you need to be able to provide any particular summary figures at all?
Amanda
RE: Consolidating sheets
i need all the data in one.
The 15 sheets are different product types.
i need them all in one sheet so a collegue of mine can start another piece of work.
there will be 50,000 rows all together and its just easier to have it all in one and use filters as appose to keep flicking through the sheets.
RE: Consolidating sheets
Hi Jatinder
Thanks for clarifying.
The actual Consolidate feature (Data - Consolidate) is designed to create a summary of numerical data; as is say, a pivot table for example.
Since you are wanting to put text-based information all into one sheet you will need to cut or copy and paste all data into one sheet.
Starting from the top left of your data, if you use Ctrl+Shift+right arrow and Ctrl+Shift+Down arrow to select the data first this might save time in terms of selecting the data to copy or cut it.
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Removing the Ribbon from view in Excel 2010At times when you want to view the whole spreadsheet, try double clicking on the ''Home'' tab on the ribbon which will hide the ribbon from view. |