Summary Report from Multiple Data Tabs

Dear Forum Members

I would like to see a report of only a certain day based on the criteria selected. Please see attached for the output that I require. Appreciate any assistance that I can get.

Best regards

Tamil

Hi Leo

Thank you for taking the time to have a look. In the detailed tab i.e. "Peacock", Column C indicates the "Waning" phase and Column Q indicates the "Waxing" phase. What I want is say I pick Sunday, waning phase and Peacock. The output should be as Column E to Q in the Output tab. Just noticed an error in the file, I will try to re upload it.

Thanks for taking the effort to look into this.

Best regards

Tamil

Maybe

Please Login or Register  to view this content.

blue fields are validations

Kind regards
Leo

Hi Leo

This is great stuff! It seems to be exactly what I require. Let me play with it a bit and I will update you accordingly.

Best regards

Tamil

Hi Leo

The file is working perfectly! Many thanks for this. If you don't mind I'd like to request one more thing. I have been manually looking up and updating columns J. If you could provide me a formula where I could run this automatically I would appreciate it. Basically, what I require is to update Column J by adding the minutes in the "Time" tab based on the Waning/Waxing phase and the "Activity of Sub Bird". So say for example, Cell I3 in the "Vulture" tab is 7:01am and the "Activity Sub Bird" is "Eating" Cell M3. Having determined this i.e. Eating and Waxing, the necessary minute applicable will be 30 minutes which is in the "Time" tab. Column H determines the demarcation between Day/Night. The 1st cycle of 1 to 5 is Day and the cycle of 1 to 5 is night. The update in Cell J3 should therefore be an addition of 7:01am with 30 minutes i.e. 7:31am. The "Peacock" tab contains the manual task but I hope there is a way to automate it.

Many thanks once again.

Tamil

Formulas in I4 and copy down, after this in J3 and copy down


Kind regards
Leo