copy rows to another worksheet based on cell value

[craig_youngman]

I need to copy rows from one worksheet within a workbook to another based on values within one of the cells. The spreadsheet is an assessment data tracker I'm working on for my school but I'd like it to automatically filter the whole set of data based on specific values e.g. one page will contain the data for pupil premium children vs non-pupil premium children, another for boys vs girls from the whole data set on the master data sheet.


My question is whether this is best achieved by VBA macro, VLOOKUP or some kind of automatic filter. As my experience in VBA/macros is limited the solution would need to be something I can do easily. Any help would be greatly appreciated!


In the example file I would need to copy rows 14,16,18,20 & 22 fully to sheet2 "Pupil Premium".




https://drive.google.com/open?id=1xEuUBqXFMxtVWO5MjBURaXMOCTHCV0oh

 

[SteveO59L]

try posting a sample of your data, and what you would like to do with it

 

[craig_youngman]

 

[craig_youngman]

https://drive.google.com/file/d/1XB4z94rJ5WmoDFxXSGDLyRqMoKEqXvdY/view?usp=sharing

 

[craig_youngman]

https://drive.google.com/file/d/1XB4z94rJ5WmoDFxXSGDLyRqMoKEqXvdY/view?usp=sharing

Based on this example, I would need rows 14,14,18,20 & 22 to copy to sheet 2 "Pupil premium" as they have PP value in column number 7 (G). The data would need to populate the same table on sheet 2, filling up with no blank rows. I'm not sure if that is any clearer!

 

[Bengo]

A few Pivot tables sounds more like the solution? All looking to source data just filtered differently

(P.S is that you Craig? B Perry)

 

[craig_youngman]

Crikey, it is Ben... small world! When did you become an excel guru?!!!

 

[Bengo]

Crikey, it is Ben... small world! When did you become an excel guru?!!!

Ha knew it was you! Comes with the territory being an accountant! Excel is our best friend! I'll send you a message and you can email your model if you want and I'll have a go!