Create sheets from ranges

[lfhomet]

Hi,

I have this file, I would like to create a sheet for each different supplier code (column D), and each sheet named with the supplier code.

thanks

[stanleydgromjr]

lfhomet,

See the attached workbook "NSF_Centralizados - lfhomet - SDG10.xls" with macro "DistributeRows".

Open the workbook, and run the "DistributeRows" macro.

[Leith Ross]

Hello lfhomet,

This macro has been added to the attached workbook. It will create one worksheet and name it for each supplier in the list. If the supplier name contains any illegal characters for a worksheet name, they are removed.

Please Login or Register  to view this content.

[lfhomet]

Thank you both very much for your help.

It worked just fine.