I have a data set that needs updating. Essentially, I need 32 individual sheets transposed and consolidated into an existing sheet in Excel. This can be achieved through copy and pasting or a simple macro but non-standard row positions make using macros a little challenging. Approximately 150 copy and pastes per sheet are required. Or can use excel formulas which dramatically reduces the need for copy pasting. It is very quick and simple but attention to detail is really important. The criteria is simple but because there are multiple elements in the criteria I cannot do it quickly with Macros. The task is simple and should take between 2-3 hours depending on your competence with Excel if you use formulas or 10 hours if you just use the transpose and copy paste feature. Accuracy is of the utmost importance. The data set is a research data set so I will be validating it using random entries. I need someone that has strong attention to detail that will not make mistakes. A bonus will be provided if the Upworker achieves 100% accuracy. Additionally, I have a number of other data sets that I cannot process with Macros and as such if this goes well, I am happy to make this an ongoing contract. Please note, that you will need to know how to use VLOOKUP and concatenate in excel to consolidate the sheets to complete the task.
90 freelancers are bidding on average $134 for this job
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
Hello, I am Excel and VBA expert. Could you give more details? If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 80 projects. Jan
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you for further discussion. Kind regards Rina
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
Hi, I am an Excel Expert with very good knowledge of VBA and formula. I can do this task. Please come on chat for more details. Thank you Awaiting your response.
Hello there, I am an Excel expert with skills in macro and VBA script. Formula is easy to me. Please share me the material for work and I will give you result soon. Can start now. Thank you.