VBA copy and paste table if cell value

Hi friends

I need some help creating a VBA and i am kinda new on it.

We have for kind of service ( A - B - C -D ). for each kind there is defrint parts to order
In sheet 1 i have a table with all the details and in (C12) i select the type of service
In sheet 2 i have created 4 tables for each service with the parts i need for them
what am trying to do is when i select a type of service on sheet 1 for example A the vba will cope the table from sheet 2 and inclode it in sheet 1

for give more details i have attached the file

SERVICE LIST.xls

thanks in advance

guys any help??

guys any thing ?? any help

Hey brdstyle,

Try this out.
You must have the same cell settings for both your sheets
Let me know what yoy think.

Regrads,
Willy

Zeiler

thx alot thats work great

again thanks