hi
i have three tables. RFID input, Main database and Attendance.
when a new IFID input is added the function checks if it is in the "Main database". If so it moves the relative information to "Attendance" table. with your help i managed to get the formula running perfectly. big thanks.
but wen i increase the number of rows in those tables around 500, it takes around 30 seconds to excel to do its calculations. For may application I need around 3000 rows. I want these tables to update real time. Is it possibly with excel ???
any pointers on methods to reduce calculation time ??
I have attache the workbook, check if my use of formula is increasing calculation time??
Try adding or deleting few values in "RFID input" sheet, you will see it takes few seconds.RFID attendance database.xls
any better and faster method for this application??
Thanks