Encerrado

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

Windows?

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 are bidding on average $4 for this job

lucidsolution

See private message.

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

See private message.

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

See private message.

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