macro to copy speciifc headers data to an extract sheet in same workbook

Hi All

I have an export sheet where there are several headers (DATA SHEET).

Am looking for a macro to copy specific headers to last data row as per extract sheet .

It should insert the name as per extract sheet sample (facture no).

For ease of understanding I have put the columns headers on the extract sheet row 2 (green) row 1 are the headers to be extracted

However I am looking for a code which is a modulable so that I can insert the header as per specific requirements it may be contigious or non contigious depending on instructions recieved , the data goes up to 20000 rows .

Thanks if any one can assist

Originally Posted by jaslake

Hi JEAN1972

Are there any Columns you would NEVER wish to extract?
Are there Columns you would ALWAYS wish to extract?
Are there Columns you may SOMETIMES wish to extract?

Is there a preferred extraction sequence for those Columns you ALWAYS/SOMETIMES wish to extract?

Hi Jaslake

As per extract sheet, these columns are the most I am requested to do but sometimes It may be less ,sometimes not in same sequence order as per sample shown

Originally Posted by jaslake

Hi JEAN

There's a User Form in the attached...it's called by CTRL + x. It'll present a Form with a ListBox populated by
You can simply Select All or you can Multi Select and Click Add. The manner in which you Select and Click Add will determine the Column Order of the resulting Report.

Play with it...let me know.

Hi Jake

I play with it at at all angles and exactly what I was looking for .

It worked much more than I expected, you save me from a tedious daily chore

Thank you a lot for your assistance.