D
Dastard
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 ..
i hope u Gurus will help me out with this
in case of query do buzz me back
Regards
+-------------------------------------------------------------------+
|Filename: TEST FILE.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4839 |
+-------------------------------------------------------------------+
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 ..
i hope u Gurus will help me out with this
in case of query do buzz me back
Regards
+-------------------------------------------------------------------+
|Filename: TEST FILE.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4839 |
+-------------------------------------------------------------------+