Getting info from one Tab to another as per date/day.

[John-Matford]

Hello,

I have been building this Ventilation Programe with Excel,
I have done and completed 95% of what I wanted to do,
there are some quite complicated calculation to assist me,
there are 6 tabs,
one each represents each shed and then there's an Information sheet, this is the sheet I would like to show at all times,
What I am looking to do is get some info from each tab to go onto the Information Tab, but must only show information for that day, date or age,

for example: Information tab BB10 (on Time), I want to it show the figure that is for that date from Tab 1 "I" colume
I will want this information to change on a daily basis,
I have uploadded the vent chart so hopefully you will see what I mean,
would be very much appreiciated if you can help with a way of doing this,

John.

[handerson0603]

See if this does what you want. I did Shed-1; you should be able to duplicate them for the others.

If this is not what you were asking for, please clarify.

Copy of Vent-Matford.xlsx

[John-Matford]

Hi handerson0603

Thank you very much for that input, I can complete this chart now after 2 years in a making,
I had done alot on there, just couldn't work that one out,
but thanks again.
John.