Hi thank you for responding, see my codes below, I will try to remove the sensitive information from my template and upload if the codes are not a help.
NB: FULL DISCLAIMER. I am a newbie at VBA & Macro, but with Google and you guys I got by.
So far my template works great. I am 99% complete, I would only like to add the log/ tracking work sheet so I can generate a report at the end of the week.
I know that Access would be the ideal solution for my purpose, but for not this will do.
All the following codes are in "ThisWorkbook" all macros run and the end result are ok thus far (fingers crossed).
Kind regards,
OB
Bookmarks