Ok my problem is as follows:

I have a Spreadsheet which has 27 Columns and a variable number of Rows, dependant on which job the data was collected from. I need to transfer the data from 6 of the columns (in two ranges) into a new spreadsheet, so far so good and I have cobbled together a macro which does this. The sticking point at present is that I only want to copy the rows that relate to two variables - "Energy Consumption" and "Transport & Travel" as I then need to manipulate this data in various ways.

The Macro I am currently working with is below (I have deleted the formatting parts to save complication). Appreciate that there may be better ways of doing this part but have made a stab at it.

Please Login or Register  to view this content.
Would be grateful of any assistance