Hi guys,
Im having an issue with some code ive been working on - Im not the most advanced VBA coder but I know my way around.
Basically its a sheet for managing overtime which users do from a Frontend - They simply add thier overtime, hit send and it adds it to the backend database (currently using Sheet1 for testing purposes)
The frontends 'sendable' data is in Range B17:L36 and the idea is it adds it on the first available empty cell.
Ive got it working but it wont let me fire the Macro more than 3 times if there is no data in the sheet, and comes up with a Runtime error 1004 - Cells not found. If there is already data in there and ive used the macro 3 times already it will come up with the error again. Maybe im missing something? Any help would be greatly appreiciated.
Code Below:
Thanks
Bookmarks