Hello,

I have a small project and am wondering if there may be someone
interested in which I could pay a nominal amount.

I am looking for a spreadsheet that will take 4 columns of data:



TIME PRICE TIME PRICE

5:00 2500 5:00 3000

4:59 2500 4:59 3001

4:58 2501 4:57 3000

4:57 2500 4:56 3001



and match up the rows based upon the TIME columns to correspond with
each other. The missing rows would then be populated with the price of
the prior row and the appropriate time. In this case it would simple
parse (use of macro?) and insert 4:58 in column 3 and 3000 in column 4.



A simple excel sheet with some VBA (?) and a macro to run it once the
dirty data is in would suffice I suppose but I am clueless when it
comes to programming anything.


Please let me know if you’re interested and what the cost may be.



Thanks,


Leonard


---
Message posted from http://www.ExcelForum.com/