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
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks