|
Managing Data in Cells
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 |
Managing Data in Cells
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 |
Managing Data in Cells
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 |
Managing Data in Cells
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 |
Managing Data in Cells
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 |
| All times are GMT +1. The time now is 10:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com