VBA for copy record to sellected 2 sheet & clear entry sheet for new record

[santosh226001]

Hello Friends
I' making a excel record entry sheet… (file enclosed). I wanna 1 VBA for my project When Entry sheet I press Y for Yes in Cell (I 21) then follwing process work through vba

1. Row 24 Copy to (record sheet)
2. Row 26 to 35 copy to Work Sheet (but between 26 to 35 copy only those rows where record show.. if row is blank don't copy that row)

Friends I wanna 1 more help for my entry sheet I wanna when in ENTRY Sheet Work Entry (YES/NO) COLUM when we choose no no then automatically clear all data from between colum B to I ( actually if it include in VBA when we press yes record move above 2 condition & in entry sheet Work Entry (Yes/No) colum all row show NO & between Colum B to I show Blank for new entry space..)

Friends if u ppl help me then I will really very grate full to u..

my file enclosed