PDA

View Full Version : Sleeper: Combine Worksheets into Master Depending on ID



ismphoto123
11-04-2015, 11:07 AM
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






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



14700