Hi,
The attached sheet has two tabs, one is an output tab and one is a source tab ("Holdings"). I'm trying to populate Ticker and Portfolio Weighting % on the Main_Output tab, but only for the portion of the Holdings tab where column L = A10 on the Main Output tab.
I realize that I could make a pivot table from the Holdings tab and copy and paste accordingly to the Main Output tab (which is the backup plan), but my goal was to make this sheet a little more dynamic (perhaps with returning an array on the Main Output tab). In any case, I've already copied and pasted what I'm looking for on the Main Output tab for the example ID GNA1K found in column L on the Holdings tab.
Also keep in mind that the sizing of the portfolio ID range can change (in certain cases maybe the GNA1K count will be 45, in others it might be 55).
I'm hoping at the very least my explanation makes sense. I didn't think this was too difficult until I actually tried doing it and now I'm not sure how to really proceed. Any help appreciated.
Thanks.
Bookmarks