Enter data on all worksheets with UserForm

[JJAngel]

Hello All,

I have 14 worksheets and the data on each are the same...

I have a UserForm that adds the below data into a main sheet and it works fine... My goal is to add that data to all worksheets at the same time.

The names of the work sheets are:

Jan_Data
Feb_Data
Mar_Data
Apr_Data
May_Data
Jun_Data
Jul_Data
Aug_Data
Sep_Data
Oct_Data
Nov_Data
Dec_Data
Annual_Data
EmployeeData

The code that works is

Please Login or Register  to view this content.

Any thoughts??

Regards,

John

[Fluff13]

If you want it on all sheets, how about

Please Login or Register  to view this content.

[JJAngel]

Outstanding - works like a charm!!!

Thank You Much

[Fluff13]

You're welcome & thanks for the feedback

[JJAngel]

Hello All,

Thanks to Fluff13 the code works like magic... I have one additional question?

Can a line of code be written into this code below that can exclude any one specific worksheet just by adding the name of that worksheet in the code to exclude??

Please Login or Register  to view this content.

Best Regards,

John

[Fluff13]

Yup, you can do it like

Please Login or Register  to view this content.

[nigelog]

already answered by Fluff

[JJAngel]

Hi nigelog,

Thanks for your input... I appreciate that... I will test and get back !!!

Regards,

John