Logging Data

[jc0r]

Hi all

I have a worksheet with data in cells A5:H21. In column I5:I21 i have a simple True or False formula that is corresponding to the data of the same row. For example, if A9:H9 = True, I9 = True.

What i would like to do is leave this running and log only the rows that contain the "True" value in column I onto a seperate sheet within the Workbook. However, i do not want any duplicate entries. Column A contains a name, therefore if the name is already found, i do not want the data logged. On a day to day basis, the amount of enytries logged will vary, so when the data is logged, i would need to go into the next row that is empty on the logging sheet.

Thanks in advance

Regards

jc0r

 

[opc121177]

Hey J

Im sure its possible to do, as most things are in excel. Unfortunatley im only novice at excel, but knowing how good this forum is to respond im sure someone will have an answer for you soon