Macro Or Formula Help

[DB]

Hello,
I need help with a macro. I need it to be able to complete the following
task in a workbook. I have a main sheet with data, and I need to be able to
assign a word or numerical to say column "H", and it would take the
information in that row and create another worksheet named the same as
information in "H". And everything with the same "H" would combine to that
particular worksheet.



Thanks
DB

 

[Guest]

Hi DB

Have a look at the code I wrote here:

http://www.ozgrid.com/forum/showthread.php?t=72736

Good luck with it.

 

[Carlos]

Hi,
The code that you have solved a big problem for me trying to seperate
certian rows eccept for the empty cells.
I am not good in VB code!
What changes should be done to the code so as to exclude empty cells.
How many sheets can I have with this code?
Using Excel 2003