to take all of the data from 3 worbooks and put them in other workbooks
the new workbooks will be sorted into data fields per spreadsheet these can be added into multiple workbooks if needed - see sample workbook and the orginal data attached
- if software developers want ot make a program that sorts the data in the workbooks that is fine as well
## Deliverables
The attached file contains 1 of the original files ([login to view URL] & [login to view URL]) the sample is how it is to look when finished, copying each categories into its own worksheet. all of the data from the other workbooks will be added to that same worksheet.
[login to view URL] -- 999600 records
[login to view URL] -- 816967 records
[login to view URL] -- 122859 records
The task is to take each category from the 2 csv & xlsx files and put it into other workbook (or workbooks if need)
e.g.
[login to view URL] (category) builders ==> goes into new workbook sheet 1 tab called builders
[login to view URL] (category) builders ==> goes into new workbook sheet 1 tab called builders
[login to view URL] (category) builders ==> goes into new workbook sheet 1 tab called builders
[login to view URL] (category) Plumbers ==> in goes into new workbook sheet 2 tab called plumbers
[login to view URL] (category) Plumbers ==> goes into new workbook sheet 2 tab called plumbers
[login to view URL] (category) plumbers ==> goes into new workbook sheet 2 tab called plumbers
the other two files will be uploaded when the job is assigned
thanks