Get Value in multiple column which have data

[asparagus]

Dear Master,

I want to get data from multiple column which have data or not blank.
I just want copy paste column with have data and blank column not copy paste.

this my .xlsm file and the code there are into the file

Thanks

Regards,
AsparAgus

 

[Asheesh]

Hi AsparAgus -

Can you explain your requirement in detail..

 

[NARAYANK991]

Hi Asheesh ,

From what I can understand , the code is copying a range A4 through BI5000.

But in this range , a lot of the columns are totally blank except for the headers ; I think these columns are to be excluded from the copy.

Narayan

 

[asparagus]

Hi Asheesh & Narayan

File will be running when it opened and auto filter automatic running too.
when data or value already filtered, there are column with "blank" data, for example D9,E9,F9,Etc,.

Blank Header no problem, most important data from header dont be "BLANK".

If column or Header not have data or "Blank" i want to delete coulmn and just header with data not deleted.

Thanks,I hope you understand my explanation.

Regards,
AsparAgus