Hi everyone
Someone created this macro for me a while back and I am attempting to reuse it but because i don't understand the macro, it is not working. I am using office 365 by the way.
So in the attached file, in the 'summary' sheet, I want to click the blue square to copy all the data in columns D, I, B and Z from the 3 x worksheet "CC PO Details", "CB PO Details" and "CS PO Details". All 3 worksheets are the same except "CS PO Details has 2 extra columns of data on the end (but I don't need them in the 'summary').
Further to this I need the macro to filter out all nil values and all "Finished" values in column I in each sheet.
If you step in to the macro "Copy to Summary" you will see the macro is already built. i just don't know how to adjust it to bring in the columns above!
Also I would ideally like blank columns between columns D, I, B and Z - so leave columns A, D, E and F blank in the 'Summary' after the macro has run.
I hope all this makes sense!!
Thanks very much
Bookmarks