Macro Or Formula Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DB - 16 Jul 2007 23:35 GMT

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

Reply to this Message

Wigi - 17 Jul 2007 00:24 GMT

Hi DB

Have a look at the code I wrote here:

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

Good luck with it.

Signature

Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music

> Hello,
> I need help with a macro. I need it to be able to complete the following
[quoted text clipped - 6 lines]
> Thanks
> DB

Reply to this Message

Carlos - 17 Jul 2007 12:05 GMT

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

> Hi DB
>
[quoted text clipped - 16 lines]
>> Thanks
>> DB

Reply to this Message

Rate this thread: