Excel 2007 : To enter series of data onto same cell of multiple sheets

I need help,

I have 115 sheet in a wookbook. The sheets named WCC#1, WCC#2,.......... WCC#115. I need to enter Authorization number in to same cell of all these sheets. The authorization number is 1 to 115 or 100 to 215 etc. Also the WCC#1, WCC#2,.... WCC#115 needs to be entered onto same cell of the sheets. Entering them one by one take a lot of time. Is there any way to do it easier.

Thanks

Thank you very much. It works so well.

I wonder if you can help me to improve the macro. There are WCC#1 to WCC#200 ws in a workbook. I would like to enter 1 to 100 onto WCC#1 to WCC#100, 50 to 100 onto WCC#101 to WCC#150 and 33 to 83 onto WCC#151 to WCC#200. There is no problem with entering WCC#1 to WCC#200 tab names onto same cell of itself. If you can help me on it, I, indeed, would appreciate.

Thanks again.

Originally Posted by teylyn

Hello,

the fastest solution would probably be to run a macro. Something like

Please Login or Register  to view this content.

Right-click the sheet tab and click "View Code".
In the VBA edito window, click Insert > Module
Paste the code below into the big code window.
Adjust the cell references to your needs. I am using A1 for the number and B1 for the WCC#1
Put your cursor anywhere in the code and hit F5 to run the macro.

If you need more help installing and running the macro, please pipe up.

cheers,

Deleted - misread request