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
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

oldbrewer

Board Regular
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,499
Messages
5,596,517
Members
414,074
Latest member
Matthew Kakde

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