Linking Certain Data Between Two Tables.

[XL_Newbie]

Hello-

I'd like to populate specific sets of data for each group (>100 groups in real data) from master table to a simplified table.
I have created the forrmula to link to specific cells to show what I like to accomplish. Reference workbook is attached.

I like to be able to drag down the three cells for the rest of the groups. How can I achieve that?

Thanks in advance for all replies.

P.

[XL_Newbie]

Can someone help me with my request? Any suggestions? Thanks.

P.

[Special-K]

in S5
=INDEX($C$5:$N$36,MATCH($R5,$B$5:$B$36,0),MATCH(S$4,$C$4:$N$4,0))

copy across and down to AD16

Update: Hang on this will only work for the first group

Thinking...

[Special-K]

Mm, tricky cos you've merged the cells together

[XL_Newbie]

Mm, tricky cos you've merged the cells together

Which cells merge are you referring to? Please let me know. Thx.

P.

[XL_Newbie]

Hello-

I still need help on this. Anyone please! Thanks.

P.

[XL_Newbie]

So this is too difficult or not possible? No guru wants to take on this challenge? Thanks.

P.

[FDibbins]

The attached file gives you what you need. I added a helper column at O, hid this ifyou want.

Also, I did some manual manipulation to the formulae in the Jan column of the summary - there were just too many variables to consider for absoluting, seeing as how you merged the group headings.

Also I added helper data in each month column, at the bottom of both tables, you can hide this too if you want

[XL_Newbie]

Thanks FDibbins for giving this a try. Looks like you misunderstood what I need help with.

My provided file shows every group has 8 sets of data or rows (Test 1 to Test 8). I only want to data for Test 1, Test 3 and Test 8 copied to a final table on the right.
I have manually copied this set of data for Group 1 as a reference. My real data table has more than 100 groups and growing so I like to know a way I can highlight the formuas/cells in Test 1, 3 and 8 from right hand table then drap them all the way down.

Please let me know if this is still not clear. thanks.

P.

[FDibbins]

The only way I can figure out how do what (I think) you need, is to un-merge the "group" in ypur column Q. That way, you can use absoluting so that you can opy/paste the formulae like you want to do.

Just remember to setup your data range so that it changes as you add more data. Hope this is what you were after?

[XL_Newbie]

The only way I can figure out how do what (I think) you need, is to un-merge the "group" in ypur column Q. That way, you can use absoluting so that you can opy/paste the formulae like you want to do.

Just remember to setup your data range so that it changes as you add more data. Hope this is what you were after?

Thank you very much FDibbins for your time and efforts in helping me out on this challenge. This will work fine for me with a bit of cleaning up on my table and formatting.

I gave you the star. Have a nice day.

P.

[FDibbins]

Glad I could help, dont forget to mark this thread as solved