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.