Index sheet lookup recent entry on subsequent sheets

Diesel9a1

New Member
Joined
Feb 12, 2015
Messages
37
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.
 
Last edited:

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top