Two Blocks are separated by a line ... also u can use clear cell as
ending and event cell as starting of a block ..
the result sheet attached is manually made , since blocks were only 9
my problem is that i have thousands of such blocks ... i need ur help
Regards again


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

I am sitting in front of PC since last 8 hours, somebody plz help me .
if not with complete solution , atleast somewhere to start from .
anything


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

Here is one solution : http://cjoint.com/?gdlnD3nKuM

You'll be kind to tell me if I got an "A"!

Cheers,
--
AP

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

I am sitting in front of PC since last 8 hours, somebody plz help me .
if not with complete solution , atleast somewhere to start from .
anything


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

And multiposting to different newsgroups is a way to be ignored, too.



Dastard wrote:

I am sitting in front of PC since last 8 hours, somebody plz help me .
if not with complete solution , atleast somewhere to start from .
anything

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

--

Dave Peterson

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

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