Is there a way to speed this up?

Every month I have to compile a spreadsheet of about 90 wells and the daily production for each well covering a span about 45 days. In one column is the property number and in the next column is the well name. Is there a code or a statement or something I could put in each cell to where I wouldn't have to click and drag it all and hopefully speed up the process as well. All the data is on the 1st sheet and then I put a list of the wells and their property numbers on the 3rd sheet. If Im not making much sense I apologize I'm more of a CAD guy than an Excel guy.

Sheet 1 ______________Sheet2
Column A Column B__ Column A Column B
(code?) Armstrong 1 __123456 Armstrong 1

I hope this makes a little more sense, I would appreciate any help you can offer.
Thank you so much.

Hi

Can't follow your structure or requirement. Can you post up a sample file showing your data, and what you would like done with it.


rylo

Sheet 1
Prop # Well Name Date
12345 Armstrong 1 1/1/2007
12345 Armstrong 1 1/2/2007
12345 Armstrong 1 1/3/2007
12345 Armstrong 1 1/4/2007
12345 Armstrong 1 1/5/2007
12345 Armstrong 1 1/6/2007
12345 Armstrong 1 1/7/2007
12345 Armstrong 1 1/8/2007
etc. etc. etc.


Sheet 2
Prop# Well Name
54321 Ashley1
12345 Armstrong 1
23451 Savanah 1

Basically I would like to put something in the "Prop#" column that will tell it to look at the name in the "Well Name" column and look at the list on "Sheet 2" and find the corresponding Prop# and fill in the right number?

I hope Im making more sense, I do apologize for my ignorance. Like I said yesterday I'm just trying to figure some way to speed up the task.

Thanks again for trying to help me.

could u plz attach your current excel file so that it can make it more clear as what exactly u need.


regards

Excel Power

If you could add a helper column before the Prop # Column and copy this formula down as far as you need (The ranges would need to be adjusted). Using this formula.

=INDEX(Sheet2!$A$2:$A$50,MATCH(Sheet1!$C2,Sheet2!$B$2:$B$50,0))

Then delete the present Prop # column on Sheet1 and the Helper column would become the new Prop # column.

Or you could just place this formula in the Prop # column on sheet1.

=INDEX(Sheet2!$A$2:$A$50,MATCH(Sheet1!$B2,Sheet2!$B$2:$B$50,0))

adjusting the ranges to fit your sheets. I think this is what you might want. I've attached a copy of the helper example. Let us know.

Dean

Hope this helps. Thank ya'll so much for your help.

I have added the following formula to Column A of your Sheet1 and copied down to the end of the present data. It appears to me to be what you wanted.

=INDEX(Sheet2!$A$2:$A$6,MATCH(Sheet1!$B2,Sheet2!$B$2:$B$6,0))

If you increase the lookup fields on Sheet2, ie. Echo2-4, fox 3-5, etc. you will need to incease the lookup range in the formula to something like:

=INDEX(Sheet2!$A$2:$A$10,MATCH(Sheet1!$B2,Sheet2!$B$2:$B$10,0))

I have attached your updated sheet. Let me know how you go on this. We want to get it right.

Dean

Thanks so much everybody!!

Dean, it worked like a charm, its cut down my productivity time by almost half! I can't begin to thank you enough. Like I said previously I'm an idiot when it comes to Excel but if you ever need any CAD help, I would love a chance at paying you back?

Glad it worked for you. Thanks for the response and the offer. Good luck and have a good day. "I love it when a plan comes together."

See ya,

Dean