Excel Macro to Copy the higligted cell value header only with the primary key

[gregorydube]

Hi All,

Greetings,

I'm looking for a excel vba macro where it will copy all the highligted cell value heade and paste the same in different sheet for example

all the row one has header

B5, G5, AA5, BG5 columns are the issue and these cells are highlighted so i want

A5 cells which is primary key, to be copied followed by the headers which are in row 1 for those (b1,G1,AA1,BG1)

kinldy help data size can be exced 150 columns and row can go upto 3 lacs'

thanks
Gregory