Hi,
I am looking at a document register system on Excel.
I'd like sheet 1 to be the Index sheet.
The Index sheet will look up the master "All forms and revisions list" and list all the forms with "Doc Ref numbers" beginning with "MF" and the most recent revision only.
The master sheet with all forms on, would look like this:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Doc Ref[/TD]
[TD]Doc Name[/TD]
[TD]Doc Type[/TD]
[TD]Section[/TD]
[TD]Issue Date[/TD]
[TD]Rev Number[/TD]
[TD]Description[/TD]
[TD]Author[/TD]
[/TR]
[TR]
[TD]MF001[/TD]
[TD]Test[/TD]
[TD]Procedure[/TD]
[TD]8[/TD]
[TD]11/12/18[/TD]
[TD]1.0[/TD]
[TD]First Issue[/TD]
[TD]Fred[/TD]
[/TR]
[TR]
[TD]MF002[/TD]
[TD]Still Testing[/TD]
[TD]PRoceduee[/TD]
[TD]5[/TD]
[TD]11/05/18[/TD]
[TD]1.0[/TD]
[TD]First Issue[/TD]
[TD]Fred[/TD]
[/TR]
[TR]
[TD]MF003[/TD]
[TD]Another Test[/TD]
[TD]Procedure[/TD]
[TD]4[/TD]
[TD]11/01/19[/TD]
[TD]1.0[/TD]
[TD]First Issue[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]MF001[/TD]
[TD]Test[/TD]
[TD]Procedure[/TD]
[TD]8[/TD]
[TD]14/02/19[/TD]
[TD]1.1[/TD]
[TD]Minor update[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]QP001[/TD]
[TD]Something[/TD]
[TD]Policy[/TD]
[TD]1[/TD]
[TD]12/12/18[/TD]
[TD]1.0[/TD]
[TD]First Issue[/TD]
[TD]Jane[/TD]
[/TR]
[TR]
[TD]QP001[/TD]
[TD]Something[/TD]
[TD]Policy[/TD]
[TD]1[/TD]
[TD]01/01/19[/TD]
[TD]1.1[/TD]
[TD]Minor Update[/TD]
[TD]Freddy[/TD]
[/TR]
</tbody>[/TABLE]
fd
The Index Sheet would look like this, (but sorted in Doc Ref order):
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Doc Ref[/TD]
[TD]Doc Name[/TD]
[TD]Doc Type[/TD]
[TD]Section[/TD]
[TD]Issue Date[/TD]
[TD]Rev Number[/TD]
[TD]Description[/TD]
[TD]Author[/TD]
[/TR]
[TR]
[TD]MF002[/TD]
[TD]Still Testing[/TD]
[TD]PRoceduee[/TD]
[TD]5[/TD]
[TD]11/05/18[/TD]
[TD]1.0[/TD]
[TD]First Issue[/TD]
[TD]Fred[/TD]
[/TR]
[TR]
[TD]MF003[/TD]
[TD]Another Test[/TD]
[TD]Procedure[/TD]
[TD]4[/TD]
[TD]11/01/19[/TD]
[TD]1.0[/TD]
[TD]First Issue[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]MF001[/TD]
[TD]Test[/TD]
[TD]Procedure[/TD]
[TD]8[/TD]
[TD]14/02/19[/TD]
[TD]1.1[/TD]
[TD]Minor update[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]QP001[/TD]
[TD]Something[/TD]
[TD]Policy[/TD]
[TD]1[/TD]
[TD]01/01/19[/TD]
[TD]1.1[/TD]
[TD]Minor Update[/TD]
[TD]Freddy[/TD]
[/TR]
</tbody>[/TABLE]
Thanks for your help.
I am looking at a document register system on Excel.
I'd like sheet 1 to be the Index sheet.
The Index sheet will look up the master "All forms and revisions list" and list all the forms with "Doc Ref numbers" beginning with "MF" and the most recent revision only.
The master sheet with all forms on, would look like this:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Doc Ref[/TD]
[TD]Doc Name[/TD]
[TD]Doc Type[/TD]
[TD]Section[/TD]
[TD]Issue Date[/TD]
[TD]Rev Number[/TD]
[TD]Description[/TD]
[TD]Author[/TD]
[/TR]
[TR]
[TD]MF001[/TD]
[TD]Test[/TD]
[TD]Procedure[/TD]
[TD]8[/TD]
[TD]11/12/18[/TD]
[TD]1.0[/TD]
[TD]First Issue[/TD]
[TD]Fred[/TD]
[/TR]
[TR]
[TD]MF002[/TD]
[TD]Still Testing[/TD]
[TD]PRoceduee[/TD]
[TD]5[/TD]
[TD]11/05/18[/TD]
[TD]1.0[/TD]
[TD]First Issue[/TD]
[TD]Fred[/TD]
[/TR]
[TR]
[TD]MF003[/TD]
[TD]Another Test[/TD]
[TD]Procedure[/TD]
[TD]4[/TD]
[TD]11/01/19[/TD]
[TD]1.0[/TD]
[TD]First Issue[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]MF001[/TD]
[TD]Test[/TD]
[TD]Procedure[/TD]
[TD]8[/TD]
[TD]14/02/19[/TD]
[TD]1.1[/TD]
[TD]Minor update[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]QP001[/TD]
[TD]Something[/TD]
[TD]Policy[/TD]
[TD]1[/TD]
[TD]12/12/18[/TD]
[TD]1.0[/TD]
[TD]First Issue[/TD]
[TD]Jane[/TD]
[/TR]
[TR]
[TD]QP001[/TD]
[TD]Something[/TD]
[TD]Policy[/TD]
[TD]1[/TD]
[TD]01/01/19[/TD]
[TD]1.1[/TD]
[TD]Minor Update[/TD]
[TD]Freddy[/TD]
[/TR]
</tbody>[/TABLE]
fd
The Index Sheet would look like this, (but sorted in Doc Ref order):
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Doc Ref[/TD]
[TD]Doc Name[/TD]
[TD]Doc Type[/TD]
[TD]Section[/TD]
[TD]Issue Date[/TD]
[TD]Rev Number[/TD]
[TD]Description[/TD]
[TD]Author[/TD]
[/TR]
[TR]
[TD]MF002[/TD]
[TD]Still Testing[/TD]
[TD]PRoceduee[/TD]
[TD]5[/TD]
[TD]11/05/18[/TD]
[TD]1.0[/TD]
[TD]First Issue[/TD]
[TD]Fred[/TD]
[/TR]
[TR]
[TD]MF003[/TD]
[TD]Another Test[/TD]
[TD]Procedure[/TD]
[TD]4[/TD]
[TD]11/01/19[/TD]
[TD]1.0[/TD]
[TD]First Issue[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]MF001[/TD]
[TD]Test[/TD]
[TD]Procedure[/TD]
[TD]8[/TD]
[TD]14/02/19[/TD]
[TD]1.1[/TD]
[TD]Minor update[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]QP001[/TD]
[TD]Something[/TD]
[TD]Policy[/TD]
[TD]1[/TD]
[TD]01/01/19[/TD]
[TD]1.1[/TD]
[TD]Minor Update[/TD]
[TD]Freddy[/TD]
[/TR]
</tbody>[/TABLE]
Thanks for your help.
Last edited: