Moving cell contents to another worksheet table

**treemkr** · 09-09-2010, 11:12 AM

I have calculation worksheets in a spreadsheet where I want to automatically move results to another worksheet table based on certain values in the calculation worksheet that correspond to x and y table values.

Sort of like a reverse of using the INDEX and MATCH functions for pulling data out of a table.

Is there a way to do this?

**darkyam** · 09-09-2010, 11:28 AM

I don't really understand what you're trying to do. Could you please post a dummy workbook, along with manual results and a more in-depth explanation?

**treemkr** · 09-09-2010, 11:38 AM

OK. I was trying to be general, and I know it is a little confusing (after I reread my original post)

What I have is a spreadsheet for golf league scoring and standings.
Each week is on a different sheet.
I want to be able to put weekly results into another sheet based on week and player. This would be set up like a table. Week number in y axis, player name (or number) in x axis.
Because of matchups individual player scores will be at different locations on the worksheet for each week.
So, I want to be able to move scores to the table by referencing the week number and player number.
That is why I mention that it is like the reverse of pulling data out of a table using the INDEX and MATCH functions.

Does this make sense?

**darkyam** · 09-09-2010, 11:54 AM

It would still be easier to see a dummy workbook so we can see your setup, but here's an attempt:
Let's assume your table's data starts in B2 with names across the top (x axis is horizontal, right?) and week number in column A. The tabs would have to be named the same as in column A for this to work. Something like =Vlookup(B$1,Indirect($A2&"!$A$1:$B$50"),2,0) should work, I think. If you do Week 1 as the tab name (or anything with a space in it) instead of just 1, you'll need to change it to =Vlookup(B$1,Indirect("'"&$A2&"'!$A$1:$B$50"),2,0)

**treemkr** · 09-09-2010, 12:24 PM

darykam

Hmmm....I think this assumes that the data in the individual worksheets are also in the same type of table (names across top / weeks down the side). This is not the case. Week number would be in the upper right of each sheet, with player number along side (not in consecutive rows), and score to be moved at a location some cells to the right of player number.

I'll have to send you a spreadsheet to see what I am talking about, but will have to do that when I get back to the computer where it is located (probably tonight).

Thanks for taking the time to look into this for me.