Extract data on one spreadsheet to another based on criteria

[AndyJ]

I have a list of data on one worksheet called raw_data coming from an
external HR database

example below:

Month Site Hire Date Name Employee ID
January Bedfont 01/01/2007 Andrew 000000001
January Bedfont 05/01/2007 Harry 000000002
January Hams Hall 31/01/2007 Simon 000000003
January Colworth 31/01/2007 Jenner 000000004
January Colworth 31/01/2007 Harry 000000005
February Leeds 09/02/2007 Simon 000000006
February Colworth 10/02/2007 Mavis 000000007
February Colworth 11/02/2007 Harry 000000008
February Hams Hall 12/02/2007 Jenner 000000009
March Colworth 13/03/2007 Harry 000000010
March Colworth 14/03/2007 Simon 000000011
March Leeds 15/03/2007 Mavis 000000012
March Colworth 16/03/2007 Harry 000000013
March Colworth 17/03/2007 Simon 000000014
March Leeds 18/03/2007 Susan 000000015

I would like to extract from the list and display on another worksheet
called Jan in cells a1 to e1 and below employees that match the month and the
site of Bedfont, I would then like to repeat the exercise a few cells along
for Hams Hall etc.

Then repeat the exercise for month of February.

From this I can then have a separate table which would count the number of
starters by location and month, and attach a hyperlink to it so that the HR
team can see a listing of how many starters in each month, and use this
information to prepare for inductions and other such HR related matters.

Any help much appreciated on how to achieve this.

Regards

Andrew

 

[CLR]

Take a look at the Data > Filter > AutoFilter feature........it should do
the filtering you want, then just copy and paste........

Vaya con Dios,
Chuck, CABGx3

 

[Sandy Mann]

If you just want numbers of starts per month then a Pivot Table will do all
that you want at once.

Data > Pivot Table Report and follow the steps of the Wizard.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[AndyJ]

If you just want numbers of starts per month then a Pivot Table will do all
that you want at once.

Data > Pivot Table Report and follow the steps of the Wizard.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk



Spreadsheet is already using pivot tables to give me the results I need but was hoping to come away form that option and also not to use autofilter - I unfortunately have staff at other locations who have very basic excel knowledge so have to present the data as simply as possible so that when they open the spreadsheet they can just see the results without having to manipulate the data in any way.
Regards

Andy

 

[Sandy Mann]

Spreadsheet is already using pivot tables to give me the results I need
but was hoping to come away form that option and also not to use
autofilter - I >unfortunately have staff at other locations who have very
basic excel knowledge so have to present the data as simply as possible so
that when they open >the spreadsheet they can just see the results without
having to manipulate the data in any way.

When I was at work I wrote a spreadsheet for people who had very basic
knowledge. I put in place holding hidden entries as place holders so that
the Pivot table would not alter if there was not full data entered, set the
range bigger than ever would be used and wrote a Macro to refresh the Pivot
Table.

The staff then just had to add data and then click on a button to get the
updated result.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

My wife says that I expect people tpo know what I am thinking without me
telling them.......


I forgot to add that I hid the sheet with the pivot table and had a Results
sheet for the staff in which the cells were linked to the Pivot table cells.
The Table in the Staff sheet therefore was set out and formatted to look
*user friendly* and the staff did not feel intimidated by it.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk