Forum Discussion
Pulling data fields from reports (based on date) and compiling them into another tab.
Hello, I have an inspector report that I am trying to pull data from certain fields based on a Ring #. The inspector will fill out the main report page and then the selected fields will record o...
Hello,
instead of an IF command i've tried this formula
=IFERROR(INDEX(CoverPage!$I$51:$I$53,MATCH([@Ring],CoverPage!$C$51:$C$53,0)),"")
in cell B3 of sheet "Compiled Info" and it seems to return the expected result. The formula is spilled down within the dynamic table. However because of the merged cells in sheet "CoverPage" i find it difficult to help with this task.
Thank you so much for the continued help with this.
Is there any way that there can be an unique ID for x6 and the date, so that when a person picks their shift the info is tied to that shift? somehow these people want this done the other way around, that they fill the info into Excavation Checklist tab and that gets populated onto the cover page. Is this way possible at all? or is there just a way that if they fill into onto the combined tab it will to over to the cover page.
Is there any way that there can be an unique ID for x6 and the date, so that when a person picks their shift the info is tied to that shift? somehow these people want this done the other way around, that they fill the info into Excavation Checklist tab and that gets populated onto the cover page. Is this way possible at all? or is there just a way that if they fill into onto the combined tab it will to over to the cover page.
The result that I really need is that when they delete off of the cover page, it is still recorded on the combined tab.
Do you mean that the CoverPage is the entry template form and you can input on CoverPage then the save data from CoverPage to shift info and clean relative input data in CoverPage ?
