Extract data from other sheet

[IKHAN]

Require assistance to extract info based on Master sheet column A10 (Year dropdown) and Column B10 ( Employee name dropdown) from "DATA" sheet starting from row27


output needed is the total in C10 ,D10 ,E10, F10 ,G10 , H10 from "DATA" sheet.

Help will be appreciated ...

 

[narunfca]

Hi!

Enclosed a file. Hope this will help.

with best regards

Arun N

 

[IKHAN]

It Works!!!1 Amazing..

Is it possible to add calender in "Master" sheet cell "C6"

 

[narunfca]

It Works!!!1 Amazing..

Is it possible to add calender in "Master" sheet cell "C6"

Dear IKHAN,

Enclosed the file. Hope this will help.

with best regards

Arun N

 

[IKHAN]

Thank You so much Arun....Works perfectly!!!!!

 

[IKHAN]

Require additional data extract based on "Master" sheet Cell "A10" dropdown.

If Year Matches "Master" sheet Cell "A10" with "Data" sheet cells "A1" OR "N1" should list in "Master" sheet cell I10 , J10 , K10 accordingly and also would be nice if "Master" sheet Column "B10" (All employee) gets updated in the dropdown list as per year in "Data" sheet A3 for 2016 or N3 for 2017

Not sure if i need to start new thread for this question..

Please see attached file...

Thank you

 

[narunfca]

Require additional data extract based on "Master" sheet Cell "A10" dropdown.

If Year Matches "Master" sheet Cell "A10" with "Data" sheet cells "A1" OR "N1" should list in "Master" sheet cell I10 , J10 , K10 accordingly and also would be nice if "Master" sheet Column "B10" (All employee) gets updated in the dropdown list as per year in "Data" sheet A3 for 2016 or N3 for 2017

Not sure if i need to start new thread for this question..

Please see attached file...

Thank you

Dear IKHAN

Define Range Name for 2016 as E_2016.
Define Range Name for 2017 as E_2017.
Data Validation is List at =INDIRECT("E_"&A10)

Enclosed example file.

with best regards
Arun N

 

[IKHAN]

Thanks Arun ..

First part of query doesn't work :

If Year Matches "Master" sheet Cell "A10" and Cell B10 with "Data" sheet cells "A1" OR "N1" should update in "Master" sheet cell I10 , J10 , K10 accordingly

 

[narunfca]

Thanks Arun ..

First part of query doesn't work :

If Year Matches "Master" sheet Cell "A10" and Cell B10 with "Data" sheet cells "A1" OR "N1" should update in "Master" sheet cell I10 , J10 , K10 accordingly

Enclosed file as per your requirement.

with best regards
Arun N

 

[narunfca]

If you want the column B to extract all employees, I have enclosed the file to extract all the employees available.

with best regards
Arun N

 

[IKHAN]

Awesome..Thank you Arun

 

[IKHAN]

@narunfca

Arun

We have another requirement added.

To extract data based on year employee name and type of OFF day used

ex. If year 2016 is selected and Emp1 from dropdown(b32) is chosen and any Off day selected from OFF days list(c32) - Must provide all dates taken in column D and notes field(column E) against it.

Thanks for help in advance..

 

[narunfca]

Enclosed the solved file.

with best regards
Arun N