Hello ,
I have 1000s of resume and I need to extract candidates Contact info in Excel.
Contact info I need to extract is First Name, Last Name,Address Line 1,County,Town,Zipcode,Home Phone,Mobile Phone and Email Address.
Please let me know if you have any extractor or script so I can extract info fastly from resume to excel.
My budget is low so please dont bid high.
Best Regards,
Lucky
Extract DateStamps From Excel & Create A Progress Bar
Mar 14
Posted by admin in Excel | Comments off
Using an Excel2007 spreadsheet , I need to extract multiple date stamps and generate a progress bar with those dates.
One cell contains a worklog (can be a long text containing multiple DateStamps records).Here is an example of the content in a cell :
"Approval Comment
—————-
Mike: Approved
25/Feb/2010 1:18:30 PM Bobby
<<From Worklog >> 00000006555581
———————————————————————————
Authorization Comment
—————-
:
03/Mar/2010 8:03:15 AM Gim
<<From Worklog >> 00000006955581
———————————————————————————
Approval Comment
—————-
Peter: Approved
01/Nov/2010 9:09:31 AM John
<<From Worklog in Change>> 000000065559581
———————————————————————————
Implementation
13/Dec/2010 1:09:36 PM Jean
<<From Worklog >> 000000065559581
———————————————————————————
All cars ready"
I need a progress bar showing in different colours on the right side on a separate column.In the above example ,there are 3 datestamps
25/Feb/2010 1:18:30 PM
03/Mar/2010 8:03:15 AM
01/Nov/2010 9:09:31 AM
13/Dec/2010 1:09:36 PM
each interval between the dates should be with a different colour .Also,the last interval should be RED if it is longer than a specific time.
This should be a macro compatible with Excel2077-2010 .
Tags: bar, comment, datestamps, Excel, extract, progress, worklog