Forum Discussion
Corrolating Data and Auto Update on a master sheet
Good Afternoon All,
Pretty new to working indepth with excel, I currently have a Excel document as an audit protocol document with multiple data cells, as part of the audit criteria, I'm looking at trying to make the sheet quicker and user friendly.
I Have 4 non conformance sheets at the beginning of my excel book, named as the following:
Direct Non Conformance
Certificate Non Conformance
Mobilisation Non Conformance
Observations.
When we are using the sheet, I would like to be able to put a drop down, with say DNC, CNC etc when I do place the DNC, CNC in the box, it automatically transfers the full data across to the dedicated sheet as headed above, is this possible?
I have attached a copy of the file attached that I'm currently working with.
If so is there a fairly easy way of doing this?
Look forward to hearing from you all.
Thanks in advance
MW
1 Reply
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.
