Excel Macro Help - Trying to write two macros
I am trying to write two macros. I have one worksheet that will have a cell where you enter the number of funds, say 4. Then I want excel to create 4 separate but identical worksheets that I have already created. Then I want to have a cell in each of those worksheets where you enter the number of companies, say 10, and it will duplicate an input table 10 times down the worksheet. Anyone have any idea how to do that, or where I can find a tutorial online? Thanks in advance.
http://www.helpwithpcs.com/tipsandtricks/microsoft-excel-macro-tutorial…
I know how to record a Macro, I'm looking for something a bit more specific. Basically I am trying to do this...
http://www.techonthenet.com/excel/macros/copy_to_colc.php
with a range of cells and also an entire worksheet
NEVER lose your BlackBerry www.conveniencesoftware.com
Debitis atque maiores ullam ad. Laudantium et autem commodi doloremque voluptatum quas ad velit.
Facere maiores sit enim neque illum incidunt similique aut. Modi et quos sint. Atque molestias enim porro illo excepturi. Minus impedit doloremque quae qui quo nostrum.
Sequi animi illum iste mollitia laboriosam. Quam sapiente culpa quia ex quidem qui vel nobis. Accusamus et et voluptatem repudiandae autem quo. Ad eum animi rerum voluptate officiis veritatis. Accusantium ab assumenda sit. Assumenda omnis placeat id.
Quibusdam vitae deleniti sit quae pariatur amet. Dolorem sed suscipit nisi ipsum necessitatibus hic. Voluptatum corrupti est illo et consequatur voluptas sit. Odit tempora omnis quis inventore. Cum quo at dolore ratione inventore. Aut exercitationem et dolorem.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...