Hmmm... FYI most of us don't take kindly to x-posts as we run the risk that we're wasting our time posting a solution here if someone else has already resolved somewhere else and given we do this for free in our spare time this kind of practice will inevitably alienate people.... as I say an FYI.
From looking at your sample file... it seems to me that you have an error in your formula in 2!B19 -- should I think be referring to B166 not B150... assuming that to be the case then I would advise the following on Sheet "2":
Then list your linked cells as before in the adjacent cells, eg G17:I23... so
Once the above has been setup you can apply the following formula on Sheet "2":
You've not provided any details for column C so I will leave that for you to resolve.
For Day 1 you will of course get REF# errors using the above however you infer on your pre-existing Sheet "1" that the above range (B17:B23) on Day 1 sheet will contain hard coded values anyway so you will simply override the formulae with your own values.
Bookmarks