HI Mahesh Sir,
Thanks for the such a nice code but it is just 2nd portion of the code i
think you have not add the 1 part which we have discussed at afternoon and
onemore thing that i have given u the process base test columns to be
deleted after the filter which we have discussed alreay
Request
Hi mahesh,
both r the same
as i have mentioned on my prev mail dont look any value just want to
delete complete column based on process name and the eg will remain
same (pls refer earlier mail). Still if u want we can communicate via
phone. If u can give me ur cell no or if u want u can also call
Hi Maulik
do u want to delete column which contain only "NA" , not "Na"
is both are different or same
On Mon, Feb 21, 2011 at 12:08 PM, maulik desai wrote:
> Hi mahesh,
>
> in a simple manner u have given instruction to macro to del column
> which contains "na" value in any columns right but i w
Hi mahesh,
in a simple manner u have given instruction to macro to del column
which contains "na" value in any columns right but i want that instead
of specific value bifercation i want that entire column should be
their rest columns to be deleted
for eg. If if u select process 5 or emp name e i
One more thing i have noticed that macro delete the complete Column contains
"NA" value from the sheet but as i have mentioned on my prev mail that i
want the specific cloumns based on Process name becasue sometime it happens
that in required columns we have to enter "NA" so in that case macro will
Hi Mahesh,
Thanks for the lovely Solution but 2 minor modification i wanted from you
1. File should be saved in Excel 2003 format (.xls) ,Currently it is saved
in .xlsx format
2. i dont want " sheet Name should Be" Column should be saved on output
sheets because it is just for your information,ki
Thanks mahesh,
there is some problem with the code
when i click on Create workbook button it give me error in code
ActiveWorkbook.SaveAs (sPath & sFileName)
also border part also not execute
request u to kindly check the same
And my earlier mail have mentioned that each process has is own te
Hi Gurus,
I Just want to create Diff excel sheet based onn Emp name & sheet name
should be "emp name & date".there are diff test are available for each
process I also want to update that process test scores in respective sheet
(kindly see the sheets for more info),i am having very large excel data
