Find 1st instance in column A, paste corresponding value from column B into another cell and continue down until end of data

[MrsFraser07]

I'm sure this is easy in VBA, just wondering if there is also a formula I could use? What I want to do is the following: Find the first instance of UWI using a lookup formula, then paste corresponding value from "Oil" into another cell on another sheet in my workbook. Then proceed to go down the "UWI" column until it reaches the end of the data for that specific UWI, and paste the corresponding "Oil" value in my other sheet. A pic of the other worksheet is below. I want to paste the "oil" values in columns B, G, L and so on.

The source data table below has multiple UWI's, so I want a formula (or VBA) to find the first one, copy all the "Oil" values within that UWI to another sheet and then move onto the new UWI and do the same. It is so tedious to copy and paste these values into my other worksheet so I'm wanting to automate it. I'm not very skilled at VBA but willing to try! Interested if there is a nested Lookup function way of doing this by formula as well. Thanks for any help.

UWI	Prod Date	Oil (bbl/d)
00/05-06-001-24W1/0	Nov/2011	50.01
00/05-06-001-24W1/0	Dec/2011	214.57
00/05-06-001-24W1/0	Jan/2012	155.88
00/05-06-001-24W1/0	Feb/2012	109.71
00/05-06-001-24W1/0	Mar/2012	72.81
00/05-06-001-24W1/0	Apr/2012	61.98
00/05-06-001-24W1/0	May/2012	64.63
00/05-06-001-24W1/0	Jun/2012	44.89
00/05-06-001-24W1/0	Jul/2012	50.57
00/05-06-001-24W1/0	Aug/2012	43.81
00/05-06-001-24W1/0	Sep/2012	15.75
00/05-06-001-24W1/0	Oct/2012	17.92
00/05-06-001-24W1/0	Nov/2012	50.53
00/05-06-001-24W1/0	Dec/2012	30.19
00/05-06-001-24W1/0	Jan/2013	37.62

 

[Sergius]

Hello! Let's clarify a little. You have a column with Daiams in the form of a month and year on the first sheet. On the second sheet there is a column with months from 1 to 12. How should the data be signed up?
In the columns of the B, G and L, these are different “UWI” or the same thing.

 

[MrsFraser07]

Hello! Let's clarify a little. You have a column with Daiams in the form of a month and year on the first sheet. On the second sheet there is a column with months from 1 to 12. How should the data be signed up?
In the columns of the B, G and L, these are different “UWI” or the same thing.

The data sheet is simply in columns. There are thousands of rows of data. I want a formula or VBA code to lookup the UWI from Sheet #2 (eg. 00/05-06-001-24W1/0), go to my data sheet and find the very first instance of that UWI. Then I want it to paste the corresponding value from the "oil" column in the data sheet, and paste it in Sheet #2 in cell B5. Then find the second instance, and paste, etc. until it reaches the last value for that UWI. Kind of like a find, copy and paste array. Hope that helps clarify?