Merging multiple worksheets (selective cells)

[Guest]

Hi Experts ,

I had created 4 input screens (worksheet type i.e A, B,C,D) , which populate
different required information into 3 "database" - another excel worksheets,
all residing in the same workbook.

Fields In Worksheet A
CIF, Client NAME, Investment Amt, Reward Pts

Fields In Worksheet B
CIF, Client NAME, Referred Member, Total AUA, Reward Pts

Fields In Worksheet C
CIF, Client NAME, Total AUA, Reward Pts

Fields In Worksheet D
CIF, Client NAME, Redemption, Reward Pts

I would want to design a macro to combine selected fields from the 4
worksheets to compute the Total Reward Pts that the client has achieved.

i.e I only want to copy CIF, Client Name , Reward Pts from all the 4
worksheets

Any advise ?

 

[Ron de Bruin]

Hi Soultek

Start here
http://www.rondebruin.nl/copy2.htm