Copying and paste data without certain colums

[vba1234]

Hi All

I am looking for a VBA code which copies certain columns onto to a new sheet which has been created. (the sheet attached - red columns must be removed when copied across).

Currently I have used the recording macro function in order for it to work i need to delete the sheet then recreate the sheet.

Please can anyone help? which then i can then use a button for.

Thanks

[AB33]

Please Login or Register  to view this content.

[vba1234]

Hi AB33

Thank for you this however I want to copy only the green heading columns onto to a new sheet without effecting the other original sheet?

Thanks

[AB33]

Please Login or Register  to view this content.

[Sintek]

I want to copy only the green heading columns onto to a new sheet without effecting the other original sheet?

Please Login or Register  to view this content.

[vba1234]

Thanks all...all sorted both solutions work!

[Sintek]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Glad I could assist...Tx for rep +

[Marc L]

Hi,

as a reminder when the destination headers match exactly the source headers (like here)
so it can be easily achieved with an Excel basics just needing a single codeline : an advanced filter !