help for short existing long coding in VBA

I m using following code to load data for editing from 2 master sheet.. my code is working as per my requiremetn but this code is too long coding.. i wanna use short to this code pls help

Please Login or Register  to view this content.

thanks in advance

Santosh