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.
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.
Windows, Excel 2007