Hi,

I'm new to Vba and wondering if someone could help with the following problem.

I have data which outputs into a spreadsheet with an event time code located at the top. I would like the find this value (in this instance 1.864) in the "time" column and set this as a variable/event(?) so i could then find the value located in the "BallOrigin:Z" column at this time/event and output it to a separate worksheet.

Any help is much appreciated.

ball test.xls