Matching and retrieving data (Please help!) x

[rinonishi]

Hiya, me again!

(please see example below if this is confusing!) In the "K" column of my spreadsheet I have all company name entries, and in the "L" I have all of the corresponding date quarters e.g. Q1, Q2 up to Q4, with random data in the following columns. I then condensed down these columns into the Quarters I actually need, so company name in "A", Quarter in "B" and random data in the next few columns:

-----A-------B----X-------------------K-------L-----Y
Com. A | | Q1| | x | |........ | | Com. A | | Q1 | | y
Com. A | | Q3| | x | |........ | | Com. A | | Q2 | | y
Com. A | | Q3| | x | |........ | | Com. A | | Q3 | | y
Com. B | | Q2| | x | |........ | | Com. A | | Q4 | | y
Com. A | | Q4| | x | |......... | | Com. B | | Q1 | | y

I now have the task of attaching the "more data" column alongside the "random data column" (there is plenty of space!). But as the table on the right contains all Quarters, and I only want the relevant Quarter's "more data" entries being put with the random data, I'm not quite sure what to do! Pseudo-code wise I think I want to do something along the lines of:
For(i = 0 up to last row)
For(j = 0 up to last row)
if((Ai == Kj) && (Bi == Lj))
copy more data in row i next to random data in row i

I've got experience with some coding but excel macros are wizardry to me at this stage, any help would be greatly appreciated as it's for a fast approaching deadline!


Thanks and please ask if I haven't given enough information! I've attached a screenshot of my spreadsheet if that helps

help please.JPG

[mike7952]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.