New to VBA, relatively adept with most other parts of excel.
I have got a macro that takes the data from 2 sub worksheets and copies that across to a master list at the click of a button, but I'm really needing the reverse. I'm needing a macro to copy data inputted into the master list into 2 separate worksheets in same workbook according to what age a person is.
In a nutshell the master list is the database of all youths that attend sports training. The sub worksheets need to be populated by age ie U12s on one and U14s (or anyone with an age older than 12) on the other . These sub sheets will then be the ones printed to form the base of the termly registers.
I am aware I could just use the filter buttons on the master list to separate out those rows required, but a couple of less IT literate people will be in the main using the information so it needs to be foolproof and as easy to use as possible, hence the requirement to input into the master and then press one button for that info to be magically split per age category.
Thanks in advance