• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro to create an expanding table

pmk11

New Member
So I have recorded a macro that filters for certain criteria in a master list of projects, then copies the projects that meets this criteria and puts it into a timeline in another worksheet. However, because the list of projects gets bigger and smaller when the filter criteria changes, right now I have to have twenty extra rows so that the pasted list doesnt ourgrow my timeline. I was wondering if anyone knows how I could input a few lines in my macro so that the table for the timeline expands as the number of prjects grows or shrinks.


One method I have tried is to copy the filtered data and "Insert Copied Cells" into the table, however I don't even get the option to insert copied cells after I have copied the data...


Thanks alot for the help everyone!
 
Hi, pmk11!

Considered uploading a sample file? Or at least macro code and worksheet description (columns, rows, formats).

Regards!
 
<p>If you are willing to buy best designer handbags than search gives you lot of benefits. Make sure to search best supplier online which gives you best quality cheap designer handbags online. According to me going for wholesale sellers also benefits you by saving your lot of dollars. There are some wholesalers which offer free shipping service however the service through they sends you bags are very slow ask them to send through express service if buying through international shops which are online. Through express service you can easily get your handbags with in ten days.</p>


<p> Handbags are just as popular as ladies' shoes. So it is no wonder that a shoe store carries even handbags. Because women can not only buy their shoes, but have to buy the perfect handbag to do so. After all, the handbags are also attached to the sandals or sneakers. Women attach enormous importance to the handbags match the entire outfit that you are worth. There are many handbags shops you can choose your favorite one from, ladies handbags, designer handbag, luxury handbag, leather handbags, fashion leather handbags, online handbag, brand handbags and so on. You may be dazzled, but how to choose the perfect authentic handbags.</p>


<p><br class="Clear" />

</p>


<p> </p>


<p> Fashion style <span style="font-size: small">prada wallets</span>-china retail at reasonable price with high quality</p>


</p>



<p><span style="color: #ff6600"><span style="font-size: small">prada sunglasses</span></span>
</p>



<div class="pro_i">://www.pradaoutletsalesonline.com/prada-wallet-outletsh-10-yellowred-p-73.html"><img class="listingProductImage" title=" Prada Wallet outlet SH 10 Yellow/red " alt="Prada Wallet outlet SH 10 Yellow/red" width="130" height="97" src="http://www.pradaoutletsalesonline.com/bmz_cache/1/1a29f25214f80a4d32730f178c20c30f.image.130x97.jpg" /></div>

<div class="ProductDetails">Prada Wallet outlet SH 10 Yellow/red </div>

<div style="text-align: center; height: 22px"><span class="pro_price"><span class="normalprice">$164.00 </span> <span class="productSpecialPrice">$88.85</span><span class="productPriceDiscount">

Save: 46% off</span></span></div>

[*]
<div class="pro_i"><img class="listingProductImage" title=" Prada Wallet outlet SH 11 Black/red " alt="Prada Wallet outlet SH 11 Black/red" width="130" height="97" src="http://www.pradaoutletsalesonline.com/bmz_cache/f/f3b1d1a313e42aed26f8d9ec603b38fb.image.130x97.jpg" /></div>

<div class="ProductDetails">Prada Wallet outlet SH 11 Black/red </div>

<div style="text-align: center; height: 22px"><span class="pro_price"><span class="normalprice">$164.00 </span> <span class="productSpecialPrice">$88.85</span><span class="productPriceDiscount">

Save: 46% off</span></span></div>



<ul class="roducysnew">


<div class="pro_i"><img class="listingProductImage" title=" Prada Wallet outlet SH 12 White/red " alt="Prada Wallet outlet SH 12 White/red" width="130" height="97" src="http://www.pradaoutletsalesonline.com/bmz_cache/0/036550c5815bf89675b7f2d3dc299646.image.130x97.jpg" /></div>

<div class="ProductDetails">Prada Wallet outlet SH 12 White/red
</div>

<div style="text-align: center; height: 22px"><span class="pro_price"><span class="normalprice">$164.00 </span> <span class="productSpecialPrice">$88.85</span><span class="productPriceDiscount">

</span></span></div>


<p>Branded bags are always the best choice, as they are typically made with materials that are of good quality. Much care also goes into their designs and finish. But because these Wholesale Bags China have a brand, usually a name of a famous designer and are made with best materials, they are very expensive most of the time. If your problem is how to get a designer bag for half of its original price, don't worry Coach Bags On Sale because you don't always have to pay a lot for it because there are options when it comes to buying discount fashion bags and ways to do this.</p>


<p> </p>


<p>

<p> </p>

<p> Try out the bag in the mirror and see for yourself if the bag is flattering to you. There are various vendors on the Internet that offer customized promotional purses. The choice ranges from light weight purses, small design printed purses, custom printed purses and more with variety design and print. These online suppliers will take your message and print it onto your desired purses at a very reasonable cost. So for more information on printed promotional purses, marketing and advertising items and products check out the top suppliers online today. Print4Half.com with the intention of bringing high-quality, low-cost design Printed Pocket & Purses to global market and to other customers. As a small business we know first hand the importance of receiving quality printed products for all business needs.</p>

<p> </p>


相关的主题文章:

 
Back
Top