hello friends..........
today i am facing a problem..........
i am upload a Test file.........
In this file I have generate 10 Master sheets i.e. Master (2), Master (3), Master (4), Master (5)…………….. Master (11) it may be 10 or may be 1000
I Want a code which will copy the data of Col D8 from Data Sheet and paste it in Master (2)’s D5 col….....
For example:- when i click on Commandbutton3 which is exist in Summary sheet
it will Copy the Data from Data Sheet’s Col-D8 and paste it in Master (2)’s D5 col.
Copy the Data from Data Sheet’s Col-D9 and paste it in Master (3)’s D5 col.
Copy the Data from Data Sheet’s Col-D10 and paste it in Master (4)’s D5 col
It will repeat these steps until found Last Master (…….) sheet but do not make any changes the Master sheet because this is Master Sheet and it should be blank
That’s it
Bookmarks