Macros for Excel reports
Budget: $250 – $750 AUD
I need 3 different macros made for microsoft excel.
I generate reports from a software package that creates .rpt files (can open in notepad). They are very raw and basic looking and I need them to look good in excel so I can generate pdf's of the reports.
I've attached some files. The files in the 'example' folders are reports that have been imported to excel and had macros arrange them nicely. This is to give you an idea of what has been achieved with macros. The other folders contain files of reports I've made recently through time-wasting editing in excel.
Ideally, I'd like to import the .rpt file into excel and have it look similar to the excel files shown in the example folders.
There are three 'LWS' folders that contain the 3 report formats I need made.
Also, within the report, there are numbers that need to be highlighted if outside a certain range. You'll see, for example, a 'pavement depth' column in one of the reports. If this is outside the specified parameters, it will need to be highlighted. (Again, similar to what's shown in the examples)
Any questions, please let me know.
I generate reports from a software package that creates .rpt files (can open in notepad). They are very raw and basic looking and I need them to look good in excel so I can generate pdf's of the reports.
I've attached some files. The files in the 'example' folders are reports that have been imported to excel and had macros arrange them nicely. This is to give you an idea of what has been achieved with macros. The other folders contain files of reports I've made recently through time-wasting editing in excel.
Ideally, I'd like to import the .rpt file into excel and have it look similar to the excel files shown in the example folders.
There are three 'LWS' folders that contain the 3 report formats I need made.
Also, within the report, there are numbers that need to be highlighted if outside a certain range. You'll see, for example, a 'pavement depth' column in one of the reports. If this is outside the specified parameters, it will need to be highlighted. (Again, similar to what's shown in the examples)
Any questions, please let me know.