Managing Data in Cells

[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 ..
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

[Dastard]

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

[RobDog888]

Whats making this difficult is the format of your first sheets data storage. It should be stored in columns and not rows. If you cant change the format then you just have to work harder.

There is a .Find method of the range object. You can specify what to search for and start from location.

Performing a macro is always the easiest way to determine how Excel does certain things.

Since this is an assignment I will guide you. Check the help file for the .Find method. You will start with searching in a loop for the "GENSET" text. Then when found you do a inner loop .Find' ing the particular info you need to copy to sheet2.

[Dastard]

Thanks Rob for ur consideration but as a matter of fact , i have a text file of first data storage sheet . i copied a part of it in excel to give it a current shape , do u have some betta options if we work on raw data having it as text file ... also its not exactly a assignment . i m telecom engineer and donno much abt vb .. this is a task my boss gave to me and a i have to do it somehow or other []
i have attached text file aswell

[RobDog888]

If you do it with a textfile then you will have to read it all into an array and then go line by line looking for your GENSET and other criteria.

Either way will work and both ways have the complications of being stored vertically vs horizontal.