Hello,
I have been stuck on this project for weeks. There are six sheets. One named 'Macro' that will have instructions and command buttons, 'Results' where the data would populate, and APAR, MBS, Purchase, and Sales. So the common identifier is the CUSIP. Not all sheets will have the same cusips, but the first two columns 'CUSIP' and 'Asset Description' are the same and the third column contains the value. What I am intending to do is populate the results tab with all CUSIPs and Asset Description's without duplicates. Then I would like the macro to look through CUSIPS in the last four sheets and return the value from the third column of that sheet into the corresponding column in the Results tab.
Below is an example of the Results tab and an APAR (which has the same layout, and just a different column header which is the same column header as Results tab). Sample is attached. Thank you in advance for your help! I also have to add more sheets and more columns to the Results sheet, this is just a simplified version.
CUSIP Asset Description APAR MBS Purchase Sales 111111111 this1 1 10 18 26 222222222 this2 2 11 19 27 333333333 this3 3 12 28 444444444 this4 4 13 20 29 555555555 this5 5 14 21 30 666666666 this6 6 15 22 31 777777777 this7 7 16 23 32 888888888 this8 8 17 24 33 999999999 this9 9 25 34
Sample Excel.xlsx
CUSIP Asset Description APAR 111111111 this1 1 222222222 this2 2 333333333 this3 3 444444444 this4 4 555555555 this5 5 666666666 this6 6 777777777 this7 7 888888888 this8 8 999999999 this9 9
Reply With Quote