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

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Forum statistics

Threads
1,223,889
Messages
6,175,226
Members
452,620
Latest member
dsubash

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