Suoritettu

Excel Data Manipulation (Sort & Copy)

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.

Taidot: tietojenkäsittely, Excel, VBScript, Visual Basic

Näytä lisää: excel sort function, how do you sort columns in excel without mixing data?, how do i sort in excel with multiple columns?, how to sort data in excel, how do you sort in excel but keep rows together?, in excel, how to sort a column and keep respective values in other columns, sort data in excel without messing up formulas, how to sort columns in excel without mixing data, simple visual basic application sort excel data, excel macro data manipulation, excel data manipulation, excel macro copy excel data, copy excel data paste internet explorer, excel assignment data manipulation, excel data manipulation outsource, copy excel data internet explore, excel data manipulation sigma, example macros excel data manipulation, macros excel data manipulation examples, excel data manipulation macros

Tietoa työnantajasta:
( 6 arvostelua ) Tempe, United States

Projektin tunnus: #17772182

Myönnetty käyttäjälle:

maguirrer

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 päivässä
(7 Arvostelua)
2.4
ilkecokay

Hello there, excel expert here. Your job is actually easy, in includes only Find-Match function, and copy function, and some error catching. No need for you to pay high amounts. I'll do it for you for a low price. You Lisää

$40 USD 3 päivässä
(15 Arvostelua)
4.0

54 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Lisää

$200 USD 2 päivässä
(640 arvostelua)
8.3
mirniyazuddin92

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 päivässä
(295 arvostelua)
7.7
schoudhary1553

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 Lisää

$200 USD 3 päivässä
(292 arvostelua)
7.7
Webxpert4u

Hello, I am ready to copy data from one sheet to multiple sheets. I am checking your excel file. I am sure, I can automate it. Still checking file.. Highly experienced in Excel Programming, Excel automation and Macr Lisää

$177 USD 2 päivässä
(204 arvostelua)
7.7
SBITServices

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 c Lisää

$100 USD 3 päivässä
(388 arvostelua)
7.3
ineedWorkJob

Greetings sir, how are you today sir? hope fine. Sir, I have read your project details and i will develop a windows software that will copy data form master sheet to other sheet as per your mentioned rules. S Lisää

$200 USD 2 päivässä
(116 arvostelua)
6.3
paulmd369

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 päivässä
(107 arvostelua)
6.4
TonmoyRoy111

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 Lisää

$100 USD 1 päivässä
(276 arvostelua)
6.6
TechnoGuruu

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 Lisää

$138 USD 3 päivässä
(46 arvostelua)
5.2
supper5guy

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 päivässä
(73 arvostelua)
5.4
abhinovpankaj

Hello, I have been working as freelancer since last ~ 6 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Lisää

$155 USD 3 päivässä
(61 arvostelua)
5.5
sonarkaushik

I am very able to sort, copy and organise excel data as per your requirement. I am ready to start. regards

$144 USD 3 päivässä
(54 arvostelua)
5.8
kahilH

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 päivässä
(24 arvostelua)
5.0
AmrBalshy

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 päivässä
(13 arvostelua)
4.3
sevillajk01

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 päivässä
(12 arvostelua)
3.7
sdroberts

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 i Lisää

$138 USD 3 päivässä
(4 arvostelua)
3.7
vbgata

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 f Lisää

$133 USD 2 päivässä
(1 arvostelu)
2.2
qinchetan

------------------------------------------- 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 exp Lisää

$55 USD 2 päivässä
(3 arvostelua)
1.5
chyedur

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 päivässä
(1 arvostelu)
1.5
AdrianCJ

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 päivässä
(1 arvostelu)
0.8