PDA

View Full Version : Solved: Match data with macro or lookup formulas



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

Bob Phillips
03-24-2010, 04:39 PM
Like this?

stanleydgrom
03-24-2010, 08:45 PM
ioncila,

Detach/open workbook "Complete Historical - MatchTest(1) - ioncila - SDG13.xls".

Click on worksheet "Historical", enter you "Cod" code in cell G15, and try the two command buttons.


xld, nicely done.


Have a great day,
Stan

ioncila
03-25-2010, 03:11 AM
Thank you very much for your quick responses and help.

I asked one of two options and I got both. Thanks Xld and Stanleydgrom.

However, Stanleydgrom's is the one that corresponds to what I intend to do.

Xld's solution is an option that fits perfectly in another form that I'm working too, so I'm going to adapt it.

Again, Thank You Both very much.

Ioncila