Dear All
I have a text in Column A4 ,I am extracting a number from that text in
colum B4,using outcome of I want to use Vlookup but its not successful.
Same Out put I entered by hand in the column then I get desire result.
To entered manually its take lot of time I have more than 1000 data.
Hello Mr.Kumar
You can get same output by pivot table, see the attached file.
On Sat, Jun 13, 2015 at 3:37 PM, Kumar Bhanushali
kumar.bhanush...@pmcprojects.com wrote:
*Dear Sir,*
I had attached a file which contains Daily Report sheet, I am updating
this sheet daily. This sheet contains 7
Dear Sir,
I had attached a file which contains Daily Report sheet, I am updating
this sheet daily. This sheet contains 7 nos of contractor.
From this sheet, I have to separate data, contractor wise.
Please help
Regards,
Kumar Bhanushali
DISCLAIMER
The information contained in this e-mail
Hi Kumar,
You can use below vba code to get contractor details simply by
entering Contractor Unique No and the filtered details will be saved
to respected contractor sheets.
Sub AutofilterExample()
Dim Criteria As Integer
'Enter Contractor Unique No to get respected contractor details
Make a little changes in your formula as mention below, then lookup on that
value.
=--MID(A9,FIND(1,A9,1),6)
On Sat, Jun 13, 2015 at 1:07 PM, Shrinivas Shevde shrinivas...@gmail.com
wrote:
Dear All
I have a text in Column A4 ,I am extracting a number from that text in
colum B4,using outcome
