DRExcel515
Board Regular
- Joined
- Oct 20, 2017
- Messages
- 56
I have a tab in a spreadsheet that each month gets a brand new dump of data for 3 different mutual funds. For the month ending 11.30.17 the total number of holdings for all 3 funds was 533 and for 12.31.17 was 544 (they are listed in order... so all of one funds holdings are from say row 2-100, then fund 3 and so on all the way down). My point is that the total number of individual holdings and total rows of data changes each month.
I have separate tabs for each of the 3 funds that each month I make a copy of the tab and copy and paste the new set of holdings into the respective funds new month end tab. What I'd love to be able to do is have a formula that somehow goes into the tab that gets the new holdings for each fund dumped in every month and somehow pulls over the correct list of holdings for that fund (even if say one month one of the funds has 100 holdings and ends on row 100 and the next month has 88 holdings and ends on row 88). The example below is say where I would dump the holdings for the 3 funds each month. There are 3 separate tabs (one for each fund that would need to find all the holdings for each fund. Any help would be much appreciated
[TABLE="width: 280"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Fund Code[/TD]
[TD]Holding[/TD]
[/TR]
[TR]
[TD]CRO[/TD]
[TD]Holding A[/TD]
[/TR]
[TR]
[TD]CRO[/TD]
[TD]Holding B[/TD]
[/TR]
[TR]
[TD]CRO[/TD]
[TD]Holding C[/TD]
[/TR]
[TR]
[TD]CRO[/TD]
[TD]Holding D[/TD]
[/TR]
[TR]
[TD]ICO[/TD]
[TD]Holding A[/TD]
[/TR]
[TR]
[TD]ICO[/TD]
[TD]Holding B[/TD]
[/TR]
[TR]
[TD]ICO[/TD]
[TD]Holding C[/TD]
[/TR]
[TR]
[TD]ICO[/TD]
[TD]Holding D[/TD]
[/TR]
[TR]
[TD]ICO[/TD]
[TD]Holding E[/TD]
[/TR]
[TR]
[TD]NPT[/TD]
[TD]Holding A[/TD]
[/TR]
[TR]
[TD]NPT[/TD]
[TD]Holding B[/TD]
[/TR]
[TR]
[TD]NPT[/TD]
[TD]Holding C[/TD]
[/TR]
[TR]
[TD]NPT[/TD]
[TD]Holding D[/TD]
[/TR]
</tbody>[/TABLE]
I have separate tabs for each of the 3 funds that each month I make a copy of the tab and copy and paste the new set of holdings into the respective funds new month end tab. What I'd love to be able to do is have a formula that somehow goes into the tab that gets the new holdings for each fund dumped in every month and somehow pulls over the correct list of holdings for that fund (even if say one month one of the funds has 100 holdings and ends on row 100 and the next month has 88 holdings and ends on row 88). The example below is say where I would dump the holdings for the 3 funds each month. There are 3 separate tabs (one for each fund that would need to find all the holdings for each fund. Any help would be much appreciated
[TABLE="width: 280"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Fund Code[/TD]
[TD]Holding[/TD]
[/TR]
[TR]
[TD]CRO[/TD]
[TD]Holding A[/TD]
[/TR]
[TR]
[TD]CRO[/TD]
[TD]Holding B[/TD]
[/TR]
[TR]
[TD]CRO[/TD]
[TD]Holding C[/TD]
[/TR]
[TR]
[TD]CRO[/TD]
[TD]Holding D[/TD]
[/TR]
[TR]
[TD]ICO[/TD]
[TD]Holding A[/TD]
[/TR]
[TR]
[TD]ICO[/TD]
[TD]Holding B[/TD]
[/TR]
[TR]
[TD]ICO[/TD]
[TD]Holding C[/TD]
[/TR]
[TR]
[TD]ICO[/TD]
[TD]Holding D[/TD]
[/TR]
[TR]
[TD]ICO[/TD]
[TD]Holding E[/TD]
[/TR]
[TR]
[TD]NPT[/TD]
[TD]Holding A[/TD]
[/TR]
[TR]
[TD]NPT[/TD]
[TD]Holding B[/TD]
[/TR]
[TR]
[TD]NPT[/TD]
[TD]Holding C[/TD]
[/TR]
[TR]
[TD]NPT[/TD]
[TD]Holding D[/TD]
[/TR]
</tbody>[/TABLE]