VBA copying data from one sheet to another

[hassankal]

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

[hassankal]

please find the attached sheet if it may help


the condition is the use selected data from cell C8

for example PAPAKAR the data will be copied to PAPAkar Sheet

[nigelog]

This will head you in the right direction

Copy into the worksheet module by right click on tab > view code

Please Login or Register  to view this content.