help on vba code to fill range with formula to all splited files

[breadwinner]

Dear expert

i want help on vba code make changes on my code as to copy the range of sheet with formula and paste with desired workbook

i have set of macro code split data as depends upon unique value of column A:A list of partner name

while split as workbook along with desire sheet(dashboard) move to value workbook. along those perform i want apply formula to desire range

at present i get only dashboard only but not formula's i want move range along with formula to this range a1:i21 to splited workbook sheet dashboard

i want make change on code to be fill the formulas into desire range a1:i21

Please Login or Register  to view this content.

find the attachment MASTER & result expect file

[breadwinner]

any experts help on me?????

[venkatpvc]

if i understand you correctly, try this and tell me is this what you looking for?

Please Login or Register  to view this content.

[breadwinner]

Thanks venkat sir Really works amazing !!! Thanks for being time spend for me