ioncila
03-24-2010, 04:13 PM
Hi
I'm in a small trouble with this and I wish I could get some help from you to build correspondence between data by macro or lookup formulas..
The attached file has 3 sheets: 'WorkersList', 'EnterData' and 'Historical'.
First one shows a list of workers in the company. 'EnterData' is to record every tool that is distributed to each worker.
What I want to do is to entry some data in 'Historical' relative to each worker and correspondant date, from the most recent one to the older one, as it shows in the attached file.
Is this very complicated to do? Please show me a way.
Thank you very much in advance
I'm in a small trouble with this and I wish I could get some help from you to build correspondence between data by macro or lookup formulas..
The attached file has 3 sheets: 'WorkersList', 'EnterData' and 'Historical'.
First one shows a list of workers in the company. 'EnterData' is to record every tool that is distributed to each worker.
What I want to do is to entry some data in 'Historical' relative to each worker and correspondant date, from the most recent one to the older one, as it shows in the attached file.
Is this very complicated to do? Please show me a way.
Thank you very much in advance