moving rows to a sheet

[steveallany2k6]

i have created a spreadsheet which has a main sheet, it then looks at column b and creates a sheet for each unique value in that column. i now want it to move each row so to the corrosponding sheet which has been created.

ie for every row which has value "a" in column b i want it to goto the sheet "a" etc basically filtering to the different sheets

Any Help apreciated

Thanks

Steve

[arlu1201]

Do you have a sample file that you can upload?

[steveallany2k6]

Sample.xls
i would like it so the rows move to the sheets named the same as column B

[arlu1201]

Try this code

Please Login or Register  to view this content.

Put it in a standard module.

This code will create sheets for you if they do not exist. So you do not need a separate code just to create the sheets.

[steveallany2k6]

Is there a ways so i can create headers for each column? while creating the sheets
ie A = Site B= name C=Start date etc etc

then save each sheet as a seperate excell file?

[arlu1201]

Are these headers in the main sheet? They can be copied over to the tabs from there.

[steveallany2k6]

in the script thats runs before that it deletes the header but i can just ommit the deling of the header so that row 1 would be the header so what code would i use so it copies it to every sheet and then saves each sheet as a single file?

thanks for all this i apreciate it

[arlu1201]

Edited code here

Please Login or Register  to view this content.

Do you want code to be added to the above which saves each sheet as a single excel file?

[steveallany2k6]

If you can just make it as a separate module and then i can just call the module if thats ok.

Regards

Steve

[steveallany2k6]

also when the data is transfered to each sheet how do i get it so the format is copied also as at the minute it does it not ver good. ie column widths are not right

[arlu1201]

This is the updated code which also saves the sheets in separate files. The columns widths have been taken care of too.

Please Login or Register  to view this content.

Do you need a code to clear / delete each sheet if you want to run the macro a 2nd time, after all the sheets have been saved as separate files?