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.
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 για αυτή τη δουλειά
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.
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
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
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
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
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
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
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
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
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
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
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.
-------------------------------------------
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.
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
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"