Excel to create office document register

kennycad

New Member
Joined
Jul 26, 2007
Messages
1
Hi,

I work in an engineering firm and have used excel in the past for various calc etc.

recently i put together a timesheet system for tracking and monitoring employee times on projects for billing etc. It was during this that i have come to realise the massive possibilities this program has.

This got me thinking about putting together a "document register" system using excel. It would be used in place of hard filing system. then registered documents could be easily searched etc.

this could assist in minimising space used to store hard copies also.

it could also take away responsibility in correctly naming electronic files.

The rough idea is as follows:

Users receive either electronic or hard copy documents

Open excel doc register, browse for the file they wish to register, enter relevant (searchable info) then click process, this renames the file to the correct format, and moves to the correct folder, also adds info to a master database with a hyperlink to the new file location. The in future other users can open the master, search based on fields, once document found they can click hyperlink which opens file.

I know this is fairly long winded, however has anyone created something similar, or come across something similar?

Cheers
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,181,648
Messages
5,931,213
Members
436,784
Latest member
amuljono

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