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".


[URL="https://drive.google.com/open?id=1xEuUBqXFMxtVWO5MjBURaXMOCTHCV0oh"]

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post

[craig_youngman]

Thanks! Wondered how to upload file!

[xladept]

double post see next post

[xladept]

It's a start:

Please Login or Register  to view this content.

BTW - You'll need to correct the name of the second tab.

[craig_youngman]

Thank you - I'll give it a try! Help is much appreciated!