Coding for copy and paste cell to other sheets

Hi Guys

Effectively, I have a timetabling workbook, which at the moment, I am copying and pasting the same information across all sheets.

However, I wanted to add a button, which when a cell on the master sheet is amended, the content is copied and pasted to all other sheets in the same cell reference, ie, Master sheet, cell D1 = "money", on all other visible sheets (20 visible sheets, I have 2 hidden sheets with the lists for dropdowns), D1, if blank, shows Money. If there is already content in the cell, I do not want it over written.



Any help will be gratefully received!

Hi

Thanks for this - it works a treat. But as always, there is another question! Is there a way of using the code to copy from D6:Q48? I thought it was a simple as changing the cell references - but I get the following error: Type mismatch. I thought it would be too easy! what I want to do is use the code to copy the "current cell" if blank. I was thinking that if the cell is populated on the master sheet, and then the user pressed a button, the code would populate that cell value across all sheets?

Thanks

adapted to the range:

Please Login or Register  to view this content.

Thanks for this - works a treat!!! Much appreciated!