Macro code for Document Control Register

sushilkadam

New Member
Joined
Mar 14, 2016
Messages
14
I need a macro for searching the data in particular sheet and then update the data in macro screen

For eg.
I have one Document Control Register containing all documents list with the revision of the documents
First Rev 01 is updated than Rev 02 than Rev 03 and so on

So I need to update the revision tracking dates as and when required by using Macro

Please help to give me code

Thanks
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

oldbrewer

Well-known Member
Joined
Apr 11, 2010
Messages
11,005
if doc3 goes from rev3 to rev4 today - how will the macro be involved - or are you storing new revisions for say a week then updating the master register..
 

sushilkadam

New Member
Joined
Mar 14, 2016
Messages
14
Thanks for your reply

Whenever I search a document in a sheet a small window should open which should show me the latest revision and other details of that document. Then I should be able to update the revision and other details (column wise) of that document

Other details like document title, revision, date of submission, date of resubmission and so on

Please help
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,280
Messages
5,836,370
Members
430,424
Latest member
ALHK022

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
Top