Copy and paste data in all workshhet

[hkbhansali]

Hi,

I have workbook with 20 or more worksheet with master sheet

I have data in my master sheet range "F2:H150".

I want copy that data and paste into all worksheet in same range "F2:H150".

Thanks

[D13L]

I think this code should work.

Please Login or Register  to view this content.

[hkbhansali]

Hi D13L,
Works perfect.

Thanks for help..

[hkbhansali]

Hi D13l

I have reopen post.

in above code after paste data can I Deselect the all work sheets and return to Master Sheet?

(After copying and pasting a cell (or cells) the original cell that I copied remains selected (with the dotted lines around it)

[D13L]

Yes just add "Sheets("MasterSheet").Activate" just before end sub.

here is the modified code:

Please Login or Register  to view this content.

[D13L]

Sorry I read your post too fast and didn't realize that you want to deselect on every sheet.

Here is the updated code:

Please Login or Register  to view this content.

[hkbhansali]

Hi D13L

Yes it's works fine....

Thanks