Want to add additional columns to attached macro

Hi,

Can someone help please. I don't know how to add addtional columns to the attached macro. At the moment when I run macro it provides me with one column of data with a heading. Want to add an extra four columns. The titles of columns can be col2, col3, col4 and col6.

Many thanks.

Please Login or Register  to view this content.

Hi

To add the extra headings change the line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

If you want to add extra columns of data to the output, which columns from the source sheet do you want to copy over?


rylo

Rylo,

The additional data is found in column B'C'F'L.

Apologies for cross posting didn't know post got copied to other sites.

Hi

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

rylo