Display first instance of number on alt worksheet

**dgits** · 07-03-2012, 05:22 AM

Hi All,

Standing on the shoulders of giants I have created a worksheet which displays a date/time of when data is entered into a cell. I have then created an alternative worksheet which looks for particular data in the first worksheet and displays it in the second.

My intention with this is having the ability to log out a piece of paperwork and track what time this has gone out, then log when it comes back and display the time it comes back. Some pieces of paperwork may be more than one page therefore may have multiple logs when it comes in.

Currently sheet2 is the 'scanning' page whereby paperwork is 'scanned' via barcode, with a date/time when this was done. Regardless of whether paperwork is going out or coming in it is all scanned onto this one worksheet.

Sheet1 then looks for a value in sheet2 and displays the date/time registered against it. If you enter a value in column A, column B displays the first instance of this numbers date, column C the first instance of this numbers time. Column D the second instance of this numbers date, E the second instance of this numbers time and so on.

What I want to do is for 'sheet1, column A' to automatically recognise when a new first instance appears in 'sheet2, column A' and auto populate the cell. It will only display this once however so we only have one instance of a particular value in that worksheet. In my attached example I have tried to create a formula in sheet1, A2 but then had to manually enter the required data in a3+ as my formula does not work correctly

.

I hope I have explained myself well enough. I have attached a sample of my spreadsheet as is. I am currently testing this functionality to make sure this is possible and if you have any other alternatives to how I've captured my information which would work better it would be very much appreciated.

Thanks for your help.

vba test2906.2012.xls