Sleeper: Creation macros

[venkatbittu]

Hi,

i like to create macros i.e sheet1 name named as data and apart from that i have inserted 4000 sheets named as per serial no ( 1,2,3) , if i paste primary id from data sheet to 1( sheet name which i have renamed ) .. Once i paste primary ID in sheet 1 details has to display

[SamT]

Sheets("sheet1").Activate