Em Andamento

Excell Formatting Macro(repost)

We have a web based software application that dumps out a excel report. After the file is dumped out, we want a macro (executed by the user) to perform a number of formatting options to the report.

## Deliverables

Requirements: - Macro should be named “MoneyReport?? and be saved in the included [url removed, login to view] file. This file contains other macros and this macro should not interfere with the included other macros. Macro automated format requirements: - Col A should be deleted. - If possible, the print default should be set to 11 x 14 landscape so they only have to press the print button. - Each column width and left/right margins should be set that the report can print on 11 x 17 paper in landscape mode without requiring multiple sheets to print the full width. Multiple sheets for the depth is ok and expected. - Columns permit fee ??" Total should all be formatted a light blue color. - Columns Inspection % and Plan Review % should be formatted a light green color. - The very last row at the end of the report for Columns Permit fee ??" Total should be formatted a dark blue color. Also, the very last row at the end of the report for Columns Inspection % and Plan Review % should be formatted a dark green color. - The number types such as currency and number, there types should be set by the macro so excel does not interpret a long number as scientific notation. - The column names Permit number ??" Plan Review % should be printed on the top of every physical piece of paper that is required to print the full report. o The steps to do this manually are: Printing a Row on all pages • Click on the Page Layout Tab • Click on the small expand icon in the lower right corner of the Page Setup area. • Click on the Sheet Tab from the dialogue box • From the Print Titles section of the dialogue box, click on the selection button for the ‘Rows to repeat at top:’ section. • Select the rows you wish to repeat and click the Selection button. The final deliverable should be the enclosed [url removed, login to view] file with the previous macros intact and the macro defined above enclosed and ready to run.

## Platform

Windows, Excel 2007

Habilidades: Instalação de Script, Shell Script, Arquitetura de software, Área de trabalho do Windows

Ver mais: wish application review, we excell, set application, script sheets, printed names, o notation, scientific paper review, printing press, notation, excel formatting, blue corner, full color printing, excel sheet formatting, macro script file, excel column width macro, section landscape, excel macro row, print repost, excel report macro, plan review report, dumps, corner tab, excel print sheet, windows application layout, repost multiple page

Acerca do Empregador:
( 228 comentários ) Houma, United States

ID do Projeto: #3001211

Premiar a:


See private message.

$16 USD em 14 dias
(15 Avaliações)

2 freelancers estão ofertando em média $19 para este trabalho


See private message.

$21.25 USD in 14 dias
(14 Comentários)