Matthew has attended:
Excel Intermediate course
Extract information
Can I extract different categories from a main list on to separate worksheets?
RE: Extract information
Hi Matthew,
Thank you for the forum question.
You can use lookup & reference function to extract the data.
I have found a useful YouTube video, where you can see it done using Vlookup and Index Match functions.
https://www.youtube.com/watch?v=NaBakFrIZkA
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Extract information
Hi
This was useful for unique references however what I would like is to extract all of a certain category in to a separate sheet, for example 'Sales' on to Sheet1 and 'Admin' on to Sheet2.
Is there any way?
Thanks
RE: Extract information
Hi Matthew,
Yes lookup and reference functions need a unique identifier.
If it is something you need to do from time to time you can use the advanced filter and extract the result to another location
https://www.youtube.com/watch?v=_KGqJLXJvgY
If you want an automated process you will need to code Excel.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
