EXCEL MACRO Copy/Paste and Insert Rows

Macrofusion - May 17, 2011 at 09:09 AM
 Anonymous User - Mar 3, 2013 at 11:04 PM

I am trying to write a macro that takes data from a filter and copy and pastes it into a template to create a standardized set of reports. Ideally, I would like the macro to copy the cells and insert the number of rows needed (thereby keeping the template colors consistent) and paste the information. The number of rows varies as the output from the filters vary.

Thanks for any help!

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 24, 2011 at 10:08 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.

your data need not be to be real data but a good representative of how data looks like
Anonymous User
Mar 3, 2013 at 11:04 PM
Thanks how can I make a foyer?