Loop thru lines of text in a cell and extract specific values: please help?
 

Hello friends,
I have an excel worksheet with huge chunk of text in Column F, and i'd
like to loop through each line in this cell to get specific data from
it. This sheet is derived from an email that i have succeded in
importing into specific cells like From, To, CC, ReceivedTime, Body,
etc. into specific Cells. Column F has the body of the email that i'd
like to extract data from.

Now i want to loop through the huge chunk of body text in cell F and
extract specific values from them, placing each on respective columns
on another sheet called results. I have mapped each data to get, so
this is a work in progress and i am a little lost on how to completely
loop inside a single cell, perhaps you can take a look at my code? On
the sheet labelled "results" I have highlighted, in Yellow the columns
that needs to get data from my column F.... Please take a look at
cellF10 e.g. Use the down-arrow key to scroll to the botton if all is
not visible as the text in it is large.

What i am trying to extract into results sheet from each line of the
cells in Column F (e.g F10) is:

Project:
Project ID:
Sub Profile:
Sub ProfileID: (# in brackets right after subprofile Name)

Employee:
EmpNo:
Weeklys data for each employee should span across columns as -
02/19:
02/26:
03/05:
03/12:
03/19:

I have started this, and i can get the other columns, but i don't know
how to work out a way to loop through the huge text in column F and get
this data from there. I can use the Instr function for that, but i need
to loop thru cells in column F first...

I have attached the sheet for your viewing and you can take a look at
my in progress code. Please help. :)


+-------------------------------------------------------------------+
|Filename: profileMacro.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4557 |
+-------------------------------------------------------------------+

--
Mslady
------------------------------------------------------------------------
Mslady's Profile: http://www.excelforum.com/member.php...o&userid=27776
View this thread: http://www.excelforum.com/showthread...hreadid=528744

Loop thru lines of text in a cell and extract specific values: ple
 

Hi,
E-mail me ) and I'll mail you some
code.

"Mslady" wrote:


Hello friends,
I have an excel worksheet with huge chunk of text in Column F, and i'd
like to loop through each line in this cell to get specific data from
it. This sheet is derived from an email that i have succeded in
importing into specific cells like From, To, CC, ReceivedTime, Body,
etc. into specific Cells. Column F has the body of the email that i'd
like to extract data from.

Now i want to loop through the huge chunk of body text in cell F and
extract specific values from them, placing each on respective columns
on another sheet called results. I have mapped each data to get, so
this is a work in progress and i am a little lost on how to completely
loop inside a single cell, perhaps you can take a look at my code? On
the sheet labelled "results" I have highlighted, in Yellow the columns
that needs to get data from my column F.... Please take a look at
cellF10 e.g. Use the down-arrow key to scroll to the botton if all is
not visible as the text in it is large.

What i am trying to extract into results sheet from each line of the
cells in Column F (e.g F10) is:

Project:
Project ID:
Sub Profile:
Sub ProfileID: (# in brackets right after subprofile Name)

Employee:
EmpNo:
Weeklys data for each employee should span across columns as -
02/19:
02/26:
03/05:
03/12:
03/19:

I have started this, and i can get the other columns, but i don't know
how to work out a way to loop through the huge text in column F and get
this data from there. I can use the Instr function for that, but i need
to loop thru cells in column F first...

I have attached the sheet for your viewing and you can take a look at
my in progress code. Please help. :)


+-------------------------------------------------------------------+
|Filename: profileMacro.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4557 |
+-------------------------------------------------------------------+

--
Mslady
------------------------------------------------------------------------
Mslady's Profile: http://www.excelforum.com/member.php...o&userid=27776
View this thread: http://www.excelforum.com/showthread...hreadid=528744

Loop thru lines of text in a cell and extract specific values: please help?
 

Thanks Toppers, i have emailed you :)

Thanks buddy!!


--
Mslady
------------------------------------------------------------------------
Mslady's Profile: http://www.excelforum.com/member.php...o&userid=27776
View this thread: http://www.excelforum.com/showthread...hreadid=528744