Find value in column with header and output variable in same row, different column

[ggibs7]

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

[lotuxel]

In this kind of case, you don't need macro and use vlookup function is can handle.
Please see attached.

[ggibs7]

Thanks, the reason I wanted to use a macro is because I will have 800+ spreadsheets plus many more variables so was looking
for an example which i could use and adapt for multiple tasks to automate my data process

[AB33]

Your request is not clear to me.
I found 1.864 in column B row 938, so what is the next step? What do you want to do once that match is found?

[ggibs7]

Once the match is found, i would like to select the value in the column named "BallOrigin"Z that is in the same row as the number just found (row 938) and output the value from "BallOrigin:Z row 38 to a blank cell.

[AB33]

Return to blank cells, column F. Is this right?

[ggibs7]

That's right

[lotuxel]

If to use macro , please advice what is yours' criteria?

[AB33]

Try the attached.

[ggibs7]

Lotuexel - what do you mean by criteria? Sorry new to this all!

[ggibs7]

Perfect, Thanks!