Hello All,
First post so please be kind :). I believe this may be tricky as although my knowledge base is small I cannot even get my head around where to start with this.
What I am looking to do is create 2 workbooks that link together. Workbook 1 will be a personal tracker, workbook two will be a work list where column A is customer name, B is customer number, C is case number and column D should take the workers name.
In the personal tracker C2 will contain the individuals name, so I would like to paste this in work list column D next to one customer when the macro is run in the personal tracker. I wish it to run until the program gets to a row where column D is blank (no name already there). When it reaches the blank row (column D) it will put in the name from personal tracker C2 and copy the customer details from the work list over to personal tracker. It will then stop as I only want workers to have one case at a time.
I know that is probably not to easy to follow but if you need any clarification please just post and I will answer to the best of my ability.
Thank you in advance for taking the time to help figure this out.
Due to IT restrictions I cannot upload example files from my network apologies.