Macro to Save Multiple copy of spreadsheet from named range

Hi

I need help to create multiple copy of workbook from a named range called - CoCode - range is on sheet called - Data - cell range - L2:L37.

Problem is that i want each workbook named as the name that is in cell range (CoCode).

Also in same workbook in a sheet called - Company Summary , in cell J1 there is validation list that refers to range same (Codode) i want that to change in each workbook.

I.e 1st copy of workbook name is equal to 1st reference in range CoCode and same 1st reference in Validation list in - Company Summary - Sheet in cell J1.

Also selecting Validation populates several sheets in workbook to information revelant to that company code selection in cell J1, - there are no external links to this document-

I hope this is clear.

Thanks for yor help in advance

Chirayu

Option Explicit needs to be at the top of each of your modules. This insures all typos are caught as they occur and all vairables are properly declared and matched.

Please Login or Register  to view this content.