Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Managing Data in Cells
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting hover data labels to cells other than source data | Charts and Charting in Excel | |||
Setting hover data labels to cells other than source data | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
How do I copy data (word) into respective cells when the data bei. | New Users to Excel |