I'm new here and must say i'm very glad that i have found this page. It helped me a lot for now, but i can't find answer to my recent challenge.
I have file (attached) with several sheets, but main two sheets i need help with are called Predispit_Konzultacije and Trening_tablica. I need certain cells copied from Predispit_Konzultacije sheet to first empty row in Trening_tablica sheet if several conditions are met on Predispit_Konzultacije sheet:
1. Checkbox must be checked (that is solved by linking to cell where checkbox "says" TRUE or FALSE
2. Column L must have value "BUS Tech"
3. If value from columns F, H, I from Predispit_Konzultacije sheet already exist in Tablica_trening sheet in columns L, M , N
So, basically, i need to check cell value, comapare it to columns L, M, N in Tablica_trening and if it doesn't exist there, copy cells from row in Predispit_Konzultacije sheet to Trening_tablica. First two conditions i manage, but third (to find out if value from cell exist somewhere in sheet Tablica trening, and if does, not to copy that row, and if it doesn't, copy it). There is a button that runs macro called "Kopiraj u tablicu" on Predispit_Konzultacije sheet.
The problem is, if I select one row, and copy it, and then two more, it wil copy first row twice. I don't want that to happen.
I would very much appreciate any help i could get. I'm quite new to macro/vba in excel. Thanks,