In Progress

Excel macro (looping) to format data in Excel sheet

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: Data Processing, Excel

See more: format prices, excel macro how to, what is macro in excel, format price, data in, excel row column, excel macro row, excel macro example column move, move data excel, price sheet, excel column row, excel 2013 macro, pre data, error macro, column row excel, excel copy sheet format, excel column copy, excel sheet budget, format data excel, excel copy format sheet, macro excel format, macro format, excel macro sheet, excel price macro, price excel macro

About the Employer:
( 30 reviews ) Sydney, Australia

Project ID: #4524541

Awarded to:


Will will done as per your requirement and more in less than 12 hours. Thanks FAZ

$30 USD in 1 day
(10 Reviews)

5 freelancers are bidding on average $31 for this job


Consider it done. Check your PM for my bid details.

$30 USD in 1 day
(50 Reviews)

Ready to start right now.

$30 USD in 2 days
(6 Reviews)

yes i am at your service sir.please proceed.

$35 USD in 3 days
(2 Reviews)

I can do this Job and please let me know the details

$30 USD in 1 day
(0 Reviews)