Here it is : http://cjoint.com/?gej0VGCuE7
Now, I should get an A+

Cheers,
--
AP

"Dastard" a écrit
dans le message de news:
...

Ardes .. A .. man its A sooper plus plus .. its exactly the way i want
it to be.. thanks a lot dude ..
now just lil more help .. i have attached the file with just a lil
alteration in "Result" sheet
in "A1" i have a text BSC14 .. i want now that when i run the same
macro . it should copy the text of "A1" to all the lowering cells ( at
same time macro is producing text in their right cells )... sounds
simple !
Secondly i have added a column at the end with naming "Node" .. now
this is the info in every block . like ( 'MDKA2124' at "A11" in first
block ...'MDKA2144' at "A30" in second block ... and 'MDHY4655' at
"A50" in third block ) i want these node names to be printed as well
corresponding to other information of each successful block
What you have already done .. this is just a few line code for u ... i
ll appreciate if u add these functions to ur previous code . as i m
still trying to digest ur previous code
Appreciating and waiting
Regards


+-------------------------------------------------------------------+
|Filename: New.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4846 |
+-------------------------------------------------------------------+

--
Dastard
------------------------------------------------------------------------
Dastard's Profile:
http://www.excelforum.com/member.php...o&userid=34406
View this thread: http://www.excelforum.com/showthread...hreadid=547949