Hi RedHerring. Welcome to the forum.
Let's try it anyway.
With drop down in C1(?) use INDIRECT to build a string referencing the sheet & range(s).
For example. Referencing those you should be able to build the rest of the formulas.
If this still doesn't help solve please upload a sample Excel workbook ... not pics or screenshots ... save retyping data.
If you are not familiar with how to do this:
To attach a file to your post,
- be sure to desensitize the data
- click “Go Advanced” (next to Post Quick Reply – bottom right),
- scroll down until you see “Manage Attachments”, click that,
- click “Browse”.
- select your file(s)
- click “Upload”
- click “Close window”
- click “Submit Reply”
The file name will appear at the bottom of your reply.
Bookmarks