Closed

Update a table in Excel based on basic criteria - data entry or excel specialist needed

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.

Skills: Data Entry, Data Processing, Excel, Visual Basic

See more: data entry excel india, mis data entry excel, program data entry excel, home based excel jobs, excel jobs from home part time, online excel job home based, home based excel data entry jobs, get paid to make excel spreadsheets, freelance excel spreadsheet design, data entry jobs online, earn money excel projects, offline data entry excel, data entry excel documents, term ready data entry excel, freelance numerical data entry excel, enter medical data entry excel, basic charge data entry, hiring data entry excel home, basic data entry excel, web based data entry excel

About the Employer:
( 0 reviews ) São Paulo, Brazil

Project ID: #18707545

90 freelancers are bidding on average $134 for this job

schoudhary1553

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

$220 USD in 3 days
(319 Reviews)
7.8
polarjin2017

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

$155 USD in 3 days
(78 Reviews)
6.5
TonmoyRoy111

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

$100 USD in 3 days
(301 Reviews)
6.7
macroPOL

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

$100 USD in 5 days
(94 Reviews)
6.0
rinabuoy13

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

$35 USD in 3 days
(70 Reviews)
5.8
TechnoGuruu

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

$99 USD in 3 days
(62 Reviews)
5.5
aubrey03

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]

$100 USD in 1 day
(81 Reviews)
5.4
lightingdavid

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

$100 USD in 0 days
(33 Reviews)
5.3
arpankumarde

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

$30 USD in 1 day
(65 Reviews)
4.5
prasannjeetp

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.

$30 USD in 3 days
(46 Reviews)
4.5
nvchien94

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.

$30 USD in 1 day
(30 Reviews)
4.1
tbrifki64

I would like to assist you. Kindly advice me further instructions. Thank you very much. Will be waiting your message...

$100 USD in 1 day
(11 Reviews)
3.8
GopalJp

Hi, I would to offer my services for your project Update a table in Excel based on basic criteria - data entry or excel specialist needed. I am an India based accountant having more than five years experience and als More

$100 USD in 3 days
(7 Reviews)
2.9
KozlouAlex

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

$90 USD in 0 days
(4 Reviews)
2.8
GabrielBarreiro1

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

$100 USD in 3 days
(5 Reviews)
2.9
DBoptimizations

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

$30 USD in 1 day
(4 Reviews)
1.9
ielucerotrad1

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

$100 USD in 2 days
(2 Reviews)
1.4
LOUISSAH666

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

$155 USD in 3 days
(1 Review)
1.2
freelancer4100r

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

$167 USD in 4 days
(1 Review)
0.3
GustavoMSilva

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

$105 USD in 1 day
(0 Reviews)
0.0