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.
55 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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
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
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 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 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