Hi there,
I need to get some detailed information from a data sheet. I'll attach file here. raw data is in the sheet "base". i need to get those data to sheet "data sheet".
In "data sheet" there is a column "emp no". And same in "base" sheet.
I need to get dates from "base" sheet to "data sheet" relating to each "emp no". there are more than one date for each "emp no" in "base" sheet.
I have done some examples manually in attached file.
Thank you.
Kasun Prasad.
Bookmarks