clarksonneo
06-14-2011, 09:44 AM
Hi,
In my workbook, there are 10 worksheets.
The name of a worksheet is Master.
The names of the rest of the worksheets are sheet 1, sheet 2, sheet 3, .... , sheet 9.
I want a macro that will type "a" in cell A1 on worksheet sheet 1 to sheet 9.
I understand the macro.
The difficult thing is here.
On the master worksheet, on column a, I will type the name of the worksheet which I want to exclude them from typing "a" in cell A1 as mentioned above.
For example, if I type sheet 1, sheet 2 ... sheet 5 in column a on the master sheet(1 cell per name), then "a" will only typed in cell A1 on sheet 6 to sheet 9.
could you please write me the macro?
thanks
In my workbook, there are 10 worksheets.
The name of a worksheet is Master.
The names of the rest of the worksheets are sheet 1, sheet 2, sheet 3, .... , sheet 9.
I want a macro that will type "a" in cell A1 on worksheet sheet 1 to sheet 9.
I understand the macro.
The difficult thing is here.
On the master worksheet, on column a, I will type the name of the worksheet which I want to exclude them from typing "a" in cell A1 as mentioned above.
For example, if I type sheet 1, sheet 2 ... sheet 5 in column a on the master sheet(1 cell per name), then "a" will only typed in cell A1 on sheet 6 to sheet 9.
could you please write me the macro?
thanks