Hi
Well i m working on this assignment right now , take a look at
attachment and in sheet named as "Input" ... jus scroll down to take a
look . u ll find 9 different blocks each distinguished by different
colour ( in actual scenario there is no colouring )
now in each block i have to go for the string "GENSET IN OPERATION" .if
i find this string in that block ( like in second block at position
"A32" , in Seventh block at "A133", in ninth block at "A174") .. then
it should creat an output sheet just like i have created as second
sheet named as "Result" , Scan that specific block and fill in the
information i have filled like ... for second block , Event Time and
Event Date are at "A20" , Clear Time and Clear date are at "A37"... i
need them in separate cells just like i have put them in .. and Event
Type is definitly that string i was looking for ..
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


+-------------------------------------------------------------------+
|Filename: TEST FILE.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4840 |
+-------------------------------------------------------------------+

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

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=548006

There are lots of people who won't open attachments. (I don't.) There are lots
of people who don't connect to the newsgroups through excelforum so they can't
open the attachment even if they wanted to.

You're going to limit the number of responses by including attachments.

If you try explaining your problem in plain text, you may get some answers.

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=548006

--

Dave Peterson