help with moving a worksheet to a workbook

[Jbryantbaker]

Ok, i will try to explain this. I have 65 worksheets in this existing workbook. I need each one of them into an existing separate workbook also numbered 1-65.

I am basically taking 3,250 rows and dividing it into 50 rows to give out for someone to work on. That makes it 65 worksheets with 50 rows of data. But each existing workbook that I need each worksheet to go into has an existing worksheet(template) that is needed. I am completely lost. I was able to create the 65 worksheets by assigning each row a group number(1-65) and then using a pivot table to get the groups and just double clicking inside the pivot table to get the worksheets for each.

can this be done just with excel? do i need to use access?

I posted this on the VBA board but no one answered me


Please help!

[Joe Bushfield]

I would use Access personally but it can be done

Please Login or Register  to view this content.

[Jbryantbaker]

Thank YOUUUU!!!!

This gave us a start and we were able to make it work from there!!! You are da man!