ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Need help on MACRO for copying between worksheets (https://www.excelbanter.com/excel-programming/362057-need-help-macro-copying-between-worksheets.html)

stanleysi

Need help on MACRO for copying between worksheets
 

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



All times are GMT +1. The time now is 05:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com