Fetch EMP ID's & Count

**kalavatiaai** · 11-23-2015, 09:16 PM

With Reference to the link - http://www.excelforum.com/excel-prog...ml#post4248090

With the same line for the code provided by Vraag Below, I need the code which will give the pass output differently and failed output differently.

Please note - In the result column, there can be different values as well like pass, fail, N/A, Not Eligible etc...

I need count of EMPID in one column & wat are the EMP ID in other column for their respective result column
Thanks Vraag for your code, that helped me too but i need the pass, failed, N/A out differently .

Please Login or Register  to view this content.

**jindon** · 11-23-2015, 11:29 PM

Deleted....................

**Parth007** · 11-24-2015, 05:25 AM

Hello KalavatiAai,

PLease use code tags... & then post your code in it

Coming to the requirment the data is calculated in Output sheet on the basis of Input sheet column J as a whole..

u want the output columns different on the basis of Result (Column J)..... me stuck on this...

Please see the file.. do you need something like this? codings needs to be done.. as of now only the format is attached...

**kalavatiaai** · 11-24-2015, 11:34 AM

Hi Parth,
Yes i need the macro which is in accordance to the file you have attached.
Im new to VBA so im unable to find it on net.

can anyone pls help me on this as this is bit urgent.
it would be really greatfull and response from all ends will highly be appreciated.

Than you all...

**jindon** · 11-24-2015, 11:38 AM

See the attached

Please Login or Register  to view this content.

**kalavatiaai** · 11-24-2015, 01:58 PM

Thank you very much Jindon, i appreciate your effort.
I tried copy pasting the code for Fail as well but unable to do it.
can you please have a look at the below code, if the code for Pass and fail is correct or not.
I need the "Wat are EMP ID's" and Count OF EMPID's for diferent different types of values in Result, the way you have done for "Pass"

Moreover we are hardcoding the values here, is it possible to pick whatever the values it has and then it will be convenient for me.

Please Login or Register  to view this content.

**jindon** · 11-24-2015, 05:46 PM

Then I need to see your EXACT desired result.

**kalavatiaai** · 11-24-2015, 08:16 PM

Hi Jindon,

Please find my sheet for the desired result in output tab for which I need the code.
As per the output tab I need the result separately for each result value. The code you provided generates the result for only Pass. I want the result for Pass, Fail, NA, etc. In case in future if new result value is added in the input then the code should be capable to identify this new value and generate the outcome this new value as well.
Note - The column F in input tab has repeated value.

Thanks,

**jindon** · 11-24-2015, 11:31 PM

You should have posted the 2nd file in the first place...

Please Login or Register  to view this content.

**kalavatiaai** · 11-25-2015, 10:40 PM

hello Jindon,
Thank you very much for your quick help.
This code really worked for my test file i also tried in my master file to incorporate this code. but not sure why this is failing.

finally after giving a hard try the entire day, iam attaching the main file for your reference.
can you please have a look at the file and incorporate the code as the attached excel.

based on the column f (flmap), column j data and column B data should be obtained. Column F has same data is repeated multiple times and for this status and def is to be generated in different work sheet of same file.

**kalavatiaai** · 11-28-2015, 12:38 PM

Thank you very much Jindon... its actually worked as i was about to build... I m really very gratefull to you

Fetch EMP ID's & Count

LinkBack

Thread Tools

Rate This Thread

Display

Fetch EMP ID's & Count

Re: Fetch EMP ID's & Count

Re: Fetch EMP ID's & Count

Re: Fetch EMP ID's & Count

Re: Fetch EMP ID's & Count

Re: Fetch EMP ID's & Count

Re: Fetch EMP ID's & Count

Re: Fetch EMP ID's & Count

Re: Fetch EMP ID's & Count

Re: Fetch EMP ID's & Count

Re: Fetch EMP ID's & Count

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Fetch row ids from other sheet

[SOLVED] Fetch variable from another sub?

[SOLVED] Search and Fetch

Fetch value from cell for VBA

Fetch the record

to fetch value from corresponding cell

fetch value of a cell, if its row contain a value > 0

Bookmarks

Bookmarks

Posting Permissions