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
