I have excel 2007
My data file has multiple sheets.
I want some of the sheets to be
blocked from viewing.
I have tried the Hide option
but anybody and Un-hide it.
Any other method for that
thanks
Hello Hui
I think the issue will be solved by some code and not the
Lookup function. I did post this issue just three days back and
was replied by one expert Faseeh also with the Lookup formula.
But I do not want any extra sheet to be added.
Also in lookup formula as I delete the code...
Let me first give an eg in xl-2007
my data in a sheet named ProductList
Columns
A B C D E F and so on till column M
Code Name Make Type and so on
1001 Pillow ABC&Co. GN
1002 BedSheet ABC&Co. GN
1003 Carpet ABC&Co. GN
1004 Brush RR Trader GN...
Hello Faseeh
It was good but as you delete the
Code number from the Output sheet
the data re-appears in the
ModifiedProdLst.
What I needed was it should get deleted perma
since I will use that code for some other
details and not the same.
thanks
Let me first give an eg in xl-2007
my data in a sheet named ProductList
Columns
A B C D E F and so on till column M
Code Name Make Type and so on
1001 Pillow ABC&Co. GN
1002 BedSheet ABC&Co. GN
1003 Carpet ABC&Co. GN
1004 Brush RR Trader GN
1005...