Hi,
I'm making a master spreadsheet that needs to pull data from about 80 source sheets.
I want to put a forumula like this....
=SUM(IF((SHEETX!D20:D40="Defeasance")*(SHEETX!H20:H40="EUR"),SHEETX!L20:L36,0))<o></o>
.....in every cell in a column, but in each cell I want to replace SHEETX with a different sheet name. A big problem is that when the source sheets were being made, they were made in the wrong order, so they cant be reffered to as Sheet1, Sheet 2 etc. I'd like C3 to be linked to AdaptPharma, C4 to AditiTechnologies and so on. the only order the source sheets are in is alphabetical order. If it would help, the name of the sheet I want to link to each cell in the column (Csomething) is the value currently in Asomething. I was wondering if anyone could advise on writing a macro to solve my problem?
Thanks a mill
I'm making a master spreadsheet that needs to pull data from about 80 source sheets.
I want to put a forumula like this....
=SUM(IF((SHEETX!D20:D40="Defeasance")*(SHEETX!H20:H40="EUR"),SHEETX!L20:L36,0))<o></o>
.....in every cell in a column, but in each cell I want to replace SHEETX with a different sheet name. A big problem is that when the source sheets were being made, they were made in the wrong order, so they cant be reffered to as Sheet1, Sheet 2 etc. I'd like C3 to be linked to AdaptPharma, C4 to AditiTechnologies and so on. the only order the source sheets are in is alphabetical order. If it would help, the name of the sheet I want to link to each cell in the column (Csomething) is the value currently in Asomething. I was wondering if anyone could advise on writing a macro to solve my problem?
Thanks a mill