Extract information

Resolved · Low Priority · Version 2016

Mon 13 May 2019, 16:18 Delegate Matthew said...

Matthew has attended:
Excel Intermediate course

Extract information

Can I extract different categories from a main list on to separate worksheets?

Mon 13 May 2019, 18:57 Trainer Jens said...

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

Tue 14 May 2019, 17:26 Delegate Matthew said...

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

Tue 14 May 2019, 18:52 Trainer Jens said...

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

Tue 21 May 2019: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips