Macro that will copy from one cell across all sheets except for three sheets.

[glide2131]

Hello, I need a macro that will copy data from one cell (A1) in a worksheet (named "Input") and paste that same data in every (B2) cell across all sheets in the workbook except for three specific sheets (named Input, Sheet2, and Sheet3).
Thanks

[djbomaha]

Hi glide 2131,

Try this:

Please Login or Register  to view this content.

Hope it helps!

Daniel

[glide2131]

That worked wonderfully. Thank you.

[glide2131]

I encountered one problem. I put a formula in cell A1 and it did not copy over to B2. Is there any way to make sure formulas copy over as well?

[djbomaha]

Yeah,

Change the following line in the code I posted above from:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

It worked when I tried it, so let me know if it works out.