Hello,

Is there any VB formula to transfer data from Main to shee1,sheet2 and etc?
Im doing some program and i want to keep separate the information from main
sheet to the particular sheets. I can use link option but i need to filter
according to age.

I've attached the example.

Name Age Location Status Sex Code

I want the information stored in seperate sheet when enter the age. When
enter age 11, it should go to sheet 1. When enter age 12, it should go to
sheet 2 and the rest.