Excel macro (looping) to format data in Excel sheet

Avg Bid (USD)
Project Budget (USD)
$30 - $30

Project Description:
I have a sheet of data, which is in many rows across various columns. What I need a macro to do is loop though the data and copy (not move) prices from the data over to the column to the right for the data they relate to. I will provide an example of how the data should look pre and post.

I will set the sheet up as per my example, but it would be helpful if the macro could show an error if it finds a price heading that I have not put in the first row.

I have to format a few different sheets, so the number of column headings will vary.

PM me if interested and I will send you the example.

Budget is upto $30 (max) and needed in next 12 hours.

Many thanks

Skills required:
Data Processing, Excel
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 30
in 1 days
Hire oFAZo
$ 30
in 1 days
$ 30
in 2 days
Hire mnmalikhasan
$ 35
in 3 days
Hire Jovin10
$ 30
in 1 days