Forum Discussion
kosisme1
Dec 25, 2022Copper Contributor
making a book list
HI, fairly new to excel and I am trying to make a book list containing book title, shelf location, author, and perhaps date published. It is for a bookcase with eight shelves and approx sixty books p...
OliverScheurich
Dec 26, 2022Gold Contributor
An alternative could be Power Query. In the attached file you can enter all books, authors, shelf locations and years in the large blue dynamic table. Then you can enter the search criteria in the small blue dynamic tables. You can search for one or more books, authors or shelf locations at the same time. After entering the search criteria you can click in any cell of the green table, right-click with the mouse and select refresh.