Macro Or Formula Help

  • Thread starter Thread starter DB
  • Start date Start date
D

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
 
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
 
Back
Top