I need someone who is an expert with Python and OpenPyXl to help me to finish a task automation programme that I have been writing.
Let me explain.
I have 3 excel sheets,
Write off levels - New World from 1st July 2021 [login to view URL]
Write off levels - New World from 1st Apr [login to view URL]
New World Template [login to view URL]
I need to perform several tasks on the Write off levels sheets including removal of a number of columns and rows, unmerge cells etc and then copy a cell range (A - BE) into the New World Template sheet.
So far this is fine and I have my programme doing this successfully.
But the problem I have is when I copy the values from the 2nd Write off levels sheet and paste into New World Template sheet it overwrites the values from the first Write off levels sheet!
So in summary, I need to perform a number of actions on both Write off levels sheets (this is already in the programme script) and then copy cell range A - BE from BOTH Write off levels sheets and merge these values into the New World Template sheet without overwriting each other!
Once this is done I then need to copy the cell formulas from Column BF - CK and "drag" these formulas down to the last row.
I know this can all be done in OpenPyXl but I need some help to achieve this.
I have attached my script below so that you can see what I have written so far.
Please do NOT bid on this unless you are 100% confident that you can complete the task.
I will NOT pay for someone that does not complete this task successfully as I have already had many Freelancers attempt this task and fail and then demand payment from me!
I will send the Excel files to you once we have agreed on the task.
Please start your bid with **OPENPYXL** so that I know you have actually read and understood the description.
12 freelancers are bidding on average £29 for this job
**OPENPYXL** Python Developer I have read your job description and I am pretty sure that I can complete every bit of your requirements. Further details and cost can be discussed in chat