Find Jobs
Hire Freelancers

Excel Data Manipulation (Sort & Copy)

$30-250 USD

Ολοκληρώθηκε
Αναρτήθηκε πάνω από 5 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση
I need to copy data from one excel worksheet to several others. 1) All the Data to be copied from (Source) is on the "Copy From This Sheet" tab - Need to copy based on the part number column. - the only data from each row that needs copied is part number, description, list price, qty, Desc(%) - Note that these column locations likely will NOT change, so can use column reference. 2) The part number for each row needs to be checked against the sheet named "part numbers" and sorted to tabs based on that list. 3) There are twenty (20) sets of tabs (called 1 - 20) though the attached sample only has two sets created for reference. Each set contains three "types". - Each type is used for sorting. - Type B is for anything that is found in the type b column in the "part numbers" tab. - Type C is for anything that is found in the type c column in the "part numbers" tab. - All part number NOT classified on the "part numbers" tab, go in Type A. 4) When parsing the data to copy, if there is a blank "part number" cell in a row, that starts a new "tab set" - up to twenty. See notes in the spreadsheet as well. **Match DESTINATION styles. Data should ONLY copy into the tables.... **The tab naming follows the same scheme for all 20 sets. **Code must be commented to note functions/steps from high level.
Ταυτότητα εργασίας: 17772182

Σχετικά με την εργασία

48 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 6 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
Avatar Χρήστη
Hello, can you tell me more about point 3?, I can start inmediately and send the file back until the end of the weekend (as soon as possible). It will help me with my reputation because Im a new freelancers.
$45 USD σε 2 ημέρες
5,0 (47 αξιολογήσεις)
4,5
4,5
48 freelancers δίνουν μια μέση προσφορά $117 USD για αυτή τη δουλειά
Avatar Χρήστη
Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 400 + projects with 100% client satisfaction. I can help you with Excel Data Manipulation (Sort & Copy) I have more than 5 years of the experience in Data Processing, Excel, VBScript, Visual Basic Please ping me for more discussion. Thanks.
$200 USD σε 3 ημέρες
4,9 (551 αξιολογήσεις)
8,4
8,4
Avatar Χρήστη
Hi there, I can copy data from one excel worksheet to several others. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
$100 USD σε 3 ημέρες
4,9 (372 αξιολογήσεις)
8,0
8,0
Avatar Χρήστη
Hello tkjoffs, I have checked the data in attached file and read your requirements. I can write VBA progrm with user friendly user interface.I have 5 years experience in Excel VBA programming, advanced concepts like Pivot table, Vlookup, Charts, Data analyser etc.. I can complete task within time with 100% accuracy. With Regards, Sai
$100 USD σε 3 ημέρες
4,9 (484 αξιολογήσεις)
7,7
7,7
Avatar Χρήστη
Dear client First of all thank you for giving your requirements in details. I understand completely what is to be done. And i ensure the job will be done to perfection. I will write the code for you. Kindly contact me. Roy
$100 USD σε 1 ημέρα
4,9 (502 αξιολογήσεις)
7,4
7,4
Avatar Χρήστη
copy data from one excel worksheet to several others. 4 varies parts to follows. A short brief specified above. It's for you that i understood project. Could you select me as your employee? Thank you
$250 USD σε 6 ημέρες
5,0 (139 αξιολογήσεις)
6,8
6,8
Avatar Χρήστη
Hi, As you are looking for automation using VBA macro in your excel sheet so that data will be distributed to different sheets based on part number. I will build the macro for you. I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many such projects. Please give me this opportunity to work on your project. Quality work with high accuracy and 100% customer satisfaction is guaranteed. Thanks and regards, Mohan
$138 USD σε 3 ημέρες
5,0 (93 αξιολογήσεις)
6,4
6,4
Avatar Χρήστη
Hello thee, as an expert in excel and VBA, i can help you to develop the necessary code to handle data sorting and copying efficiently. Please contact me and let us talk more about your project. Thanks
$80 USD σε 3 ημέρες
4,9 (85 αξιολογήσεις)
5,8
5,8
Avatar Χρήστη
I am very able to sort, copy and organise excel data as per your requirement. I am ready to start. regards
$144 USD σε 3 ημέρες
4,7 (54 αξιολογήσεις)
5,8
5,8
Avatar Χρήστη
hello! I am very interested on your project, I would love to help you and you can be assured of a quality and accurate output from me. Hope you consider me! thanks
$100 USD σε 3 ημέρες
4,9 (65 αξιολογήσεις)
5,4
5,4
Avatar Χρήστη
Hello I am a highly skilled data processo ive worked on many simillar projects before i suggest to implement a script to auto perform the task /thank you in advance
$95 USD σε 3 ημέρες
4,7 (29 αξιολογήσεις)
5,1
5,1
Avatar Χρήστη
It would be my pleasure if you accepted my bid to work together. I can handle and deliver this task professionally. Kind regards, Amr
$80 USD σε 3 ημέρες
5,0 (15 αξιολογήσεις)
4,4
4,4
Avatar Χρήστη
Hello I would be able to help you. I have over 10 years experience with excel and vba for a global financial services company. In that time i became the local lead for all excel and vba issues where I designed and implemented many macros to automate systems and improve efficiencies. I have the skills required for your task. I look forward to working with you soon. Kind regards Steve
$138 USD σε 3 ημέρες
5,0 (9 αξιολογήσεις)
4,2
4,2
Avatar Χρήστη
Dear Employer; i would love to work for you. if you want your work done on time please contact me.
$30 USD σε 2 ημέρες
5,0 (4 αξιολογήσεις)
3,2
3,2
Avatar Χρήστη
If you don't mind I can do all this in powershell just because is something that I use on a daily basis.
$90 USD σε 3 ημέρες
5,0 (2 αξιολογήσεις)
2,9
2,9
Avatar Χρήστη
Hi there! I have read and understood that you need Excel Data Manipulation. I am highly skilled in excel with a typing speed of 86+ wpm and 98+% accuracy. Please initiate a private message so that we can discuss further and start work right away. Thank you, and have a great day! Arun
$133 USD σε 2 ημέρες
5,0 (1 αξιολόγηση)
2,2
2,2
Avatar Χρήστη
Hello, could you just clear me the purpose of Set1 and Set2 please? I've been reading the requirements for 30 minutes! Regards!! Chyedur
$50 USD σε 2 ημέρες
5,0 (3 αξιολογήσεις)
2,2
2,2
Avatar Χρήστη
As a professional accountant, I have a vast experience in working with Excel sheets and their features. I am highly accurate and precise in working with data. I would be glad to work on this project.
$50 USD σε 1 ημέρα
5,0 (5 αξιολογήσεις)
1,9
1,9
Avatar Χρήστη
------------------------------------------- I am a lazy person so I started automating my work and became an expert in it. I have handled huge data and processed them with my automation skills. I have 9 years of experience in the Excel sheets and macro. Handled huge data in office. Completed many automation projects.
$55 USD σε 2 ημέρες
5,0 (3 αξιολογήσεις)
1,5
1,5
Avatar Χρήστη
hey employer, i have recently completed work in excel and also i can complete your work in maximum 2 days .also if you want want i can create specific buttons for automation of whole process if its a regular entry work. for more further information like planning about this project you can inbox me anytime. thanks regards
$30 USD σε 2 ημέρες
5,0 (1 αξιολόγηση)
0,4
0,4
Avatar Χρήστη
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do this job and give you an efficient job that will be very acceptable and presentable. I and my team work on web development and mobile apps and I can assure you that you will never be disappointed"
$208 USD σε 7 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της UNITED STATES
Tempe, United States
5,0
7
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Δεκ 12, 2010

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.