Copy to formated letter

[samitnair]

Hi I am looking for a vb for copying data into a formatted letter......I have posted the two sheets for better understanding......

Sheet 1: LETTER (Destination sheet)

Sheet 2: CFORM (Sheet with data)

Now with reference to the pic if i enter a customer name as ABC in sheet Letter ....i need the vb to copy C3:H3,C5:H5 and C7:H7 from sheet CFORM and paste it in sheet letter B14:G16.....But if you observe B16 in sheet "letter" therz already a line entered so i suggest the vb must insert row and paste the value so that the format of the text is maintained.....Hope u got my idea and will help me

 

[samitnair]

Guys is it not possible.....

 

[samitnair]

I found the below mentioned thread a bit appropriate but i don't know how to modify it to serve my purpose.

http://www.mrexcel.com/forum/showthread.php?t=2010

http://www.ozgrid.com/forum/showthread.php?t=144603&page=1

 

[samitnair]

Hi I made some efforts to find individual vb's to achieve my target and i even tried to modify the same but i get errors above my knowledge....

VB to Sort

http://www.mrexcel.com/forum/showthread.php?t=75294

VB to compare two sheets

http://www.mrexcel.com/forum/showthread.php?t=330477

VB to find copy and paste

http://en.allexperts.com/q/Excel-1059/EXCEL-VBA-FIND-COPY-1.htm

Please help me...can any VB gurus help me in compiling the 3 into one or create a new VB which suits my requirement

Regards
sam