Macros for Excel reports

Closed Posted 2 years ago Paid on delivery
Closed Paid on delivery

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.

Visual Basic Data Processing Excel Visual Basic for Apps Microsoft Office

Project ID: #31086645

About the project

37 proposals Remote project Active 2 years ago

37 freelancers are bidding on average $376 for this job

SShtv

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA.

$500 AUD in 7 days
(117 Reviews)
6.4
nagybatonyi

I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contain More

$290 AUD in 3 days
(64 Reviews)
5.7
raoarslan56

Here sir, I have read your job description carefully and checked you attached file... I will write you VBA code to search .rpt file in a folder and upload into excel.. I will write you VBA code to format/arrange the da More

$250 AUD in 1 day
(21 Reviews)
4.9
dataEntryExperty

I will do it for you. How much time do you have. Please let me know if more details on chat. Already completed many projects

$250 AUD in 1 day
(16 Reviews)
3.8
agupta2812

Hello there, Good day! I am interested in this project. I am an expert in Macros/Excel/VBA with 10+ years of experience. Please reach out to me to discuss further. Thank you!

$650 AUD in 3 days
(6 Reviews)
3.1
sramireddy065

Hi my experience with skills you mentioned Visual basic for Apps and Excel is almost more than 5 years and i have seen file you shared with me i am sure i can complete this project. Send message to discuss further

$500 AUD in 7 days
(5 Reviews)
2.7
josephvictory

Hi, I can assist you in this task. I’m proficient in Microsoft excel VBA micros and also in excel arithmetic formulas. I’m confident that I’ll provide you the best possible result required. I am proficient in Microsof More

$250 AUD in 5 days
(1 Review)
2.3
anmolmakkar666

Hello! I am an excel expert. ⭐⭐I will start right now very perfectly.⭐⭐ Let's do it now Don't think about anything just inbox me for more discuss. Please check my completed projects I'm waiting for your response.

$250 AUD in 1 day
(3 Reviews)
1.5
Jerrysmit0913

Dear Employer! I have a plenty of experiences in programming of C++, Python, C#, VB, VBA, x86/x64 Assembler, etc. You'll know my price as a professional one for your project during chatting. I would be very glad if i More

$250 AUD in 7 days
(0 Reviews)
0.0
dolendrayadav1

I am a professional Data Entry expert. I have two to three years of data work experience. I have very good speed with accuracy in my work. I always complete my target in given dead line. I am an honest person and do w More

$300 AUD in 4 days
(0 Reviews)
0.0
Holarwale01

I have read your description, I can do the job perfectly. I'm a data entry expert with good knowledge of Excel. I will prepare the macro files as soon as possible. I'm ready to work for you. Thanks.

$350 AUD in 5 days
(0 Reviews)
0.0
jdcassociate69

Dear Sir/ Madam I looked at your attached Macro Files.zip. I can do that task perfectly. I really want you to give me this job so that I can prove myself. I am a newcomer in this site but I have been more than 10 year More

$250 AUD in 4 days
(0 Reviews)
0.0
Kimhuong2211

Fully understand your requirements & understood what you require. I can delivery the work within 24 hours, I can do this project with 100% accuracy right now. I want to send you sample tamlate because your satisfaction More

$250 AUD in 7 days
(0 Reviews)
0.0
SheikhAbouBakr

I am professional data entry operator i can handle all type of data in all sort of inventory software i am right person for this job

$250 AUD in 7 days
(0 Reviews)
0.0