write VBA code to normalize data and move rows

  • Status: Closed
  • Prize: $50
  • Entries Received: 10
  • Winner: IgeS

Contest Brief

I recorded a video at the link below explaining exactly what I need done.

https://www.loom.com/share/7c0c68956547482baa8822bcba4f1fca

To summarize, I need a VBA code to reorder the columns of raw data files and to split one column in specific. THEN I need a VBA code to normalize the data in a few columns to always be "Proper" format, and a few columns to always be "Upper" format.

The first entry that has a working solution will be awarded. I understand there are multiple ways this can be done. I'm not picky - I just need to reduce the amount of time spent and the risk of creating manual errors. This is time sensitive and will be awarded accordingly.

Recommended Skills

Employer Feedback

“Awesome freelancer! Super creative and has a good grasp on finding solutions”

Profile image revamp365, United States.

Top entries from this contest

View More Entries

Public Clarification Board

  • Paramamithra
    Paramamithra
    • 4 years ago

    Please update the status of the project.
    Is the contest closed or still open for new entries

    • 4 years ago
    1. garybutler
      garybutler
      • 4 years ago

      I'm considering entering, but I don't want to waste my time either. Has this project been completed already. As the job seems fairly simple. I find it hard to believe that 8 people failed to deliver. If the project is still ongoing let us know. After reviewing your video I know this can be done in less than two hours.

      • 4 years ago
  • bishalali101
    bishalali101
    • 4 years ago

    Hello there!
    I have carefully gone through your job post and understood your requirements. I am offering you my quality service. You can check my profile & portfolio for details about my experiences. If you give me the opportunity, I’ll provide you quality service according to your instructions within your expected budget & estimated time. We can discuss it more over chat and also can show you my plans as well as previous work samples.I am waiting for your positive response. Thanks! Best Regards, Monirul Islam

    • 4 years ago
  • bilal6364
    bilal6364
    • 4 years ago

    yes sir i see your vidoe and file your project Will be done but 50% advance payment thank you

    • 4 years ago
  • ranashahed2000
    ranashahed2000
    • 4 years ago

    Hi please see entry #2

    • 4 years ago
  • MMG2019
    MMG2019
    • 4 years ago

    hello, can do that in VB6 or MS ACCESS ?

    • 4 years ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!