Excel macro to parse 13Fs

Every quarter financial firms file a form called a 13F. I have data aggregated from these in excel format and need someone to either do the work or write a macro that can combine the files into a single workbook (each file with its own worksheet) and then format them slightly by cutting off the first couple rows of each sheet and filtering certain columns to change to red font for cells that exceed 10% etc. I have attached an example of one of the excel sheets.

## Deliverables

Either a macro and instructurions to do this, or preferably I can send a zip with all of the files and someone can send me back the aggregated excel file.

## Platform


Habilidades: PHP

Ver mais: the parse platform, combine excel, data excel work sheets, write macro, excel combine rows, excel combine data rows, php workbook, php macro, php excel macro, excel data filtering, php data parse, excel file columns, parse data file, parse data, excel macro php, write file excel, excel change data format, filtering excel, quarter excel, preferably engineering, excel combine macro, excel combine, excel filtering, filtering data excel, write file macro excel

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #2970683

3 freelancers estão ofertando em média $4 para este trabalho


See private message.

$4.25 USD in 2 dias
(3 Comentários)

See private message.

$4.25 USD in 2 dias
(16 Comentários)

See private message.

$4.25 USD in 2 dias
(3 Comentários)