Replicating a Master template

[jhong]

Hi Everyone,

Need some help. I have this workbook which sheets is approximately
close to 50 sheets. We have Account names that approximately close to
300. Everytime a new account is added I need to update all the sheets,
aside I need to make sure also that the first account name starts in
row 9. If i have a master template name as "Original", how can I
create a code that will update all the succeeding sheets within this
workbook. Please help.


Thanks in advance!

Jerome

 

[jhong]

Hi Everyone,

Need some help. I have this workbook which sheets is approximately
close to 50 sheets. We have Account names that approximately close to
300. Everytime a new account is added I need to update all the sheets,
aside I need to make sure also that the first account name starts in
row 9. If i have a master template name as "Original", how can I
create a code that will update all the succeeding sheets within this
workbook. Please help.

Thanks in advance!

Jerome

Btw, just to add, each formula from each sheet is different so just
cant copy the master sheet and paste it to all the remaining sheets.
Thanks!

 

[Tim Williams]

Why do you need to update all of the sheets when you add a new account?

Tim

Hi Everyone,

Need some help. I have this workbook which sheets is approximately
close to 50 sheets. We have Account names that approximately close to
300. Everytime a new account is added I need to update all the sheets,
aside I need to make sure also that the first account name starts in
row 9. If i have a master template name as "Original", how can I
create a code that will update all the succeeding sheets within this
workbook. Please help.

Thanks in advance!

Jerome

Btw, just to add, each formula from each sheet is different so just
cant copy the master sheet and paste it to all the remaining sheets.
Thanks!