how are u All

i am looking help for 2 problems

kindly help me!

i got 2 worksheets, actuly those are monthly reports,

what i need to do is

i have to define a Macro by which my 200 Sheets & my each sheets have 5-6
merge cells

1) what i need that any code which AUTOMATICLLY REMOVE the Merge cells & make
it Left Justify


2) i have a code

=IF(B7>0,IF(ISNA(VLOOKUP(B7,'C:\Documents and
Settings\Sajjad\Desktop\done\[Feb2007.xls]KHi - Main'!$B$7:$B$500,1,0)),"Not
Found","OK"),"")


& i want to paste this code automaticcly on my each sheets till 500th Room


one thing is to note that both worksheets have same Sheets name

is this possible that i dont have to go & paste the same FUNCATION to each
Sheet & change the Sheets name

rather use a macro to do this task