Forum Discussion
Corrolating Data and Auto Update on a master sheet
I notice (as you are no doubt aware) that you asked your question a number of days ago and there've been a lot of views but no answers. At least part of the problem is that it's not clear from your description where you'd be putting that "drop down box" you refer to--in what sheet, in which cell(s)....and where that data is expected to come from then to populate adjoining cells.
So that's at least part of why you've not gotten an answer.
From my vantage point (uninformed as it is), I find myself wondering why this was ever conceived of as an Excel project to begin with. SO MUCH of what is in those various sheets looks like it would be more suited to Microsoft Word, where the table capability could be used for even more extensive text boxes....
So you could help also by putting into words exactly what Excel is expected to offer in this audit protocol. If you're hoping to use the various LOOKUP functions to retrieve those extensive texts under certain conditions, it would help if they were all consolidated into a single database (with some inevitable re-design for the sake of consistency). But that's all conjecture on my part. So please help us here on this site help you by spelling out a bit more of the specifics and to the extent possible, the larger context.