;1604370]HI all,

Hi Ron,

Thanks for your reply. I need to generate the reports tweice a month. i export the reports from Ms-Access.

I need to delete the columns from the excel. same columns for all the reports i generate.
Random means.. the columns are not in order like col A, col B ..... first col A , THEN COL C OR COL K LIKE THAT..

I want to delete the columns with data which i dont need for my reports.

If you need any further details please let me know. i can post the sample columns as well.

Thank you,


every month i geenrate reports. from ms-access i export the reports to excel. i have various colmns which i dont requier. i need to delete them manually.
the columns are random.
From A - Z columns the data is filled. most of the columns i dont requier. by using a macro can i deleted these unwanted columns.

how i can do this. my desk is full load of work.i am new to excel to.

can some one please help me in this regards.
i am great ful to all.

Thanks
VENkata