Copy and paste into new sheet if VBA

Hi,
I have a code (detailed below) which copys and pastes data and formula into a new sheet and creates a new sheet for all different variables in column A. This works fine for copying from one sheet, now I need it to look into the second sheet named "non resources" and do the same but copy and paste both sheets information on to one summary sheet in the same workbook. Any help is much appriciatted.

Please Login or Register  to view this content.

hi Kads
You could clean up the code by removing the "Select" method and replacing them with "With" statments

You can loop the two sheets by

Please Login or Register  to view this content.