EXCEL MACRO Copy/Paste and Insert Rows
Closed
Hello,
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!
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!
Related:
- EXCEL MACRO Copy/Paste and Insert Rows
- Insert gif in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Insert check mark in word - Guide
- How to insert photo in word for resume - Guide
- Insert draft watermark in word on all pages - Guide
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
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.
Note: your data need not be to be real data but a good representative of how data looks like
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.
Note: your data need not be to be real data but a good representative of how data looks like
