Posts by ajwilltravel

Roy firstly thanks so much for this!! Yes what is on the summary sheet is exactly what I need. However, I do need the WTP & RMARN sheets to have their own macros & macros buttons - so I can filter then unfilter finished at any time (toggle between the 2). The reason is I use those sheets during the month for analysis - and I need to see both finished unfinished constantly. The summary sheet macro only needs to be run once a month - it's the final result of my analysis in the other 2 sheets. So i wanted the summary sheet to have it's own button ("copy to summary") and it's own macro. And I want the macros on the buttons on the other sheets to remain as they were. Sorry I didn't explain all this properly! I'm trying to fix it here but not having much luck!

Sorry Re your question How do you determine whether the Finished items have previously been copies or will they be deleted when the code runs? anything finished will not be copied. That’s the macro I need - to copy only what isn’t finished from the 2 sheets to the summary tab. Does that make sense? Thanks again

Hi those formulas are being used I just had to delete their source data sheets to upload this workbook to this forum as that data is confidential. Please disregard those columns. But they do have to stay where they are. Those columns do not need to copied in to the summary tab. Regarding the headers in summary tab I only put them there as a guide. I do not want any headers to be copied in to the summary tab (after the macro runs). Only the data in the columns I marked up & mentioned in my original query. Thanks…

crossposted: mrexcel.com/board/threads/copy…ksheet-as-values.1200086/
and
vbaexpress.com/forum/showthrea…-filtered-to-1-summary-wo

Hi everyone, I am a macro beginner. I have two worksheets with source data (layout of each worksheet is the same but number of rows on each sheet will continue to grow). In these 2 sheets 'WTP' and 'RMARN' I've managed to create a macro to autofilter (Filter on column F - Filter out any rows that are "Finished") - macro button top left). This column F is also a formula. My other macro is simply to clear the filter. What I need is a macro to copy certain columns from both of these source data sheets and copy paste as values in the 'Summary' sheet. I need to do this monthly so each time I run it I need to clear what is in the summary sheet from last time and run the macro again (replace what was already there). The columns I need to copy from the two source sheets are shown in the summary tab in attached - B C D E F O P & U. But I don't want the column headers to come through to the summary sheet when I run the macro. I've been on internet all day trying to build this macro & have failed. Also tried recording then editing it but got completely lost. Can anyone help? Must confess I'm hoping someone can do it for me then I can study it!