hello everybody,

im kinda new to the VBA thing,
can someone help me, i want to copy information from one sheet to another with a condition.


for example.


if i type X in sheet 1 in C8

i want to paste C9:C12 in another sheet say example sheet X

and if i type Y in sheet 1 in c8

i want to paste C9:C12 in another sheet say example sheet Y

how can i do when inputing the data in SHEET X or Y it inputs it at the buttom or after an input


very thankfull for your help