Hi everyone,

Would appreciate if you could help me with a MACRO for the following :
If you open the spreadsheet you will see 4 worksheets (SheetA,B,C and
D)
I need a macro that will copy the appropriate rows, columns and ranges
from SheetA and generate it into SheetB (sample output is there
already).
Thereafter, I need to do the same for SheetC and include that into
SheetB that will generate output similar to SheetD.

This has to be done multiple times over and over for about 40k rows.

Thanks

Stanley Si


+-------------------------------------------------------------------+
|Filename: HELP on macro.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4799 |
+-------------------------------------------------------------------+

--
stanleysi
------------------------------------------------------------------------
stanleysi's Profile: http://www.excelforum.com/member.php...fo&userid=8893
View this thread: http://www.excelforum.com/showthread...hreadid=544260