Create Library Offline Public Access Catalogue (OPAC) in MS Excel | Catalogue | Multiple Combo boxes 

It is one of the very useful channel on RU-vid for Library and Information Science Professionals. Thank you

Very explained video. I followed the steps and I works

Thank you so much..for creating awesome videos for LIS Professionals they are really useful, relevant and every one can learn from your channel ...More power to you with Regards 😊😊😇

Sir, very good tool for those who are unable to impelement library automation. Sir, my sincere request yout to provide another video with "SEARCH" button option in this tool if possible...

Very good effort , useful all library professional. I appreciate for that.

Unbelievable! Awesome 👍

Its very Nice Sir.

Smart work..

It's really good video, please guide me sir

Thank you

Hello sir This video is useful .please guide me index formula.

How to input search bar?

I am really thankful to you Sir,I have creat OPAC but I didn't understand how can I add books.please guide me

Sir please help in adding search option in the same! I mean manually typing to get the result

Very nice and helpful. It can only function upon opening Microsoft excel i think?

Aslmoalikum Sir.

Hello,Sir Can you guide me which formula you put in combo box for transfer data sheet

Sir, It is very good. Why we select always w1 cell? Can we browse by entering title,author's name etc. by applying some different methods?

How about no. of books if someone borrowed it can be automatically decrease the no. of books?

sir is me searching system kis tara hoga or combo box me kis tara delet kartha hay

Sir, whether it will work on google sheets? If it works, same steps to be followed ah sir?

Hy Mr. Common man, i watched the video very well and practically i tried to create mine, i did everything up to the point where in your video you tried to check the process whether it will work by randomly selecting one tittle where automatically author, publisher, call number, and Accession number of the selected tittle appears , but mine fails to do this, nothing happens at that side when I select title. where exactly have i missed the point in the video?

Sir One doubt. Can we search the book by typing on the box

Hello,Sir Please guide how to add index formula.

can. I make this in MacBook Pro

Sir, need your assistance. Please help. Index formula is not working. I have tried several times. But unable to run.

Useful but what can be done for similar authors or titles

If I want search author name the show only one book but there is more books in library and the author is same

why the data for indexing is spilled?

im failing to put index function please help

OPAC full form is a ONLINE PUBLIC ACCESS CATALOUGE

Access library or college website offline ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ee4oqENZCUs.html

isko online kyse kia jaskta h?

this formula doesnot work

Thank you

Hello sir This video is useful .please guide me index formula.