• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Get Value in multiple column which have data

asparagus

Member
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
 

Attachments

  • Local N-Series.xlsm
    579 KB · Views: 6
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
 
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
 
Back
Top