Hi, I have two sheets (input & output). Here I will be past complex text paragraph in the sheet “Input “ . I need a macro that will give me the results like “output” sheet . please check the attached excel workbook , in that I have color marked which text need to be taken from input sheet to Output sheet.
try
Please Login or Register to view this content.
Last edited by jindon; 06-01-2013 at 03:31 AM. Reason: Changed cell format (date)
if jindon's clever code doesn't work (I'm sure it does) here's my take on it:
data modified.xlsm
Hi, jindon
It works perfectly. You saved my time. before that I would take many hours to prepare the same report But now only a moments just button press time which is outstanding speed. Thanks for your valuable time .
Hi, Ed_Collins,
Your code also working fine , but one problem that is “Duration” column is not working as my requirements , (it will be actually [D2= Now()- C2 ] go down until blank ), & the cell format should be (D:HH:MM)
Hi, jindon
Need little bit macro modification as of our “ input” data having some changed (it is happened due to our linux server was updated recently)
(before “END” there is one space) base on this logic your code what i am currently using is working fine.
EXTERNAL ALARM
TOWER_LIGHT
END
please add one more logic which having no space also like below, there is no space before "END"
EXTERNAL ALARM
TOWER_LIGHT
END
Last edited by nur2544; 06-05-2013 at 11:37 AM.
Change
toPlease Login or Register to view this content.
Please Login or Register to view this content.
Characteristic of your beautiful VB scripts
Size: Very small
Speed: Extremely fast
Logic: Superb
Error: 0%
Remarks: Just Outstanding
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks