Update a table in Excel based on basic criteria - data entry or excel specialist needed
Budget $30-250 USD
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
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More
Hello? How are you? I have good experiences in "Update a table in Excel based on basic criteria - data entry or excel specialist needed" as you can see my profile for these (Data Entry, Data Processing, Excel, Visual More
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
Hi, As per requirements I will copy the data carefully from different sheets to single one for you. I will also try to make macro which will move the data as per description of the project. Please share your Excel s More
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]
Hello. How are you? I am highly interested to work on the "Update a table in Excel based on basic criteria - data entry or excel specialist needed". I am a full stack Excel/VBA expert and I have more than 7 years ex More
Hi, I am good at excel. I am good with macros and formulas as well. I understand the work that you are asking to be completed. I can get this done in 3 hours. Let me know more details about the project. Thanks, More
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.
I would like to assist you. Kindly advice me further instructions. Thank you very much. Will be waiting your message...
Hello. Below are examples of my recently completed project similar to your requirements: Smart Excel Sheet - https://www.freelancer.com.ru/projects/data-entry/vba-excel-compare-count-sort/?w=f Flexible customized d More
Dear, I am interested in participating in your project. I have experience and skill in data management through Excel. I am available to start immediately, do not hesitate to contact me. Clarification: • The More
Hi, I can do this job accurately and quickly. I'll do it using formulas like VLOOKUP and INDEX. My professional experience with Excel is vast. But I still have little experience here on this platform, that's why my More
I can do the job! I'm an engineer with advanced working knowledge and experience in Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, MS Project, Autocad, pdf, etc.), web More
Hello, I am very experienced in Excel and also in the things you need to do with and get/manipulate from it. Very happy to assist you. I am based in the UK - happy to chat about it with you on here. Look forwar More
Hi there, Greetings for the day!. I have gone through your requirement of "updating an excel table". I have more than 12+ yrs of experience in MIS Reporting, Data Analysis using MS Excel. In short, I am MIS More
Hello sir, I'm a civil engineering student and I'll be happy to use my excel knowledge to help you with this task. If any additional Information is needed I'm up to answer. Relevant Skills and Experience Advanced exce More
