Need Experts Advice


New Member
Jul 17, 2010

I have a stiuation, I wanted to know that whether it can be solved by Excel 07 or not?

Q: There is a library, which is not following a coding system for books. Currently the library is having 100 books and 100 are coming on the way. It is having 4 Shelves each is again divided into rows of 10 and one row can carry as much as 10 books.

There are four types of books currently available at library.
1. Physics
2. Mathematics
3. Literature
4. Fiction

Library incharge made an Access table with the following fields:
BookName Type Rows Position Shelve

And also an Excel file named as Librarybooks.xlsx having two columns
BookName Type
Because management wants to know only the books available and type they have.

For data entry purpose in excel he made a data validation rule for column B i.e. Type
having options :
New Entry

If a user selects on New Entry he will get a input box asking Type,Rows,Position and Shelve and after entering the data the same needs to be updated in Access Sheet.

Or if user selects any of the pre defined types the input box asking Rows,Position and Shelve.

Else it is better to have the same table in excel and hide it using hide property. And then writing code will be easier for the same.

What do you suggest?

And if the answer is the first one please mention how to relate the access table to excel....and what will happen if the same code is copied to another machine i.e. whether Access works as a back end database with the sheet, wherever it is been copied.:confused::confused::confused:


Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Latest member
John Strickland

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...