Forum Discussion
Parts inventory
Thank you for that, here is the only sheet i want to work with once i have it all together.
i will create a section that i search for my part numbers .
A single data table would NOT have all the blank rows. That makes it more readily readable by humans, but you're asking a computer to do the reading.
One of the major mistakes made in designing a spreadsheet where you want LOOKUP (in any of its various manifestations) to work, is to make it pretty. Eliminate the colors, eliminate the blank rows. Add a column to take care of (recognize) the different sections.
- All i want is my search bar where i enter in a parts number to locate where in the parts # is in line A and line I the current inventory amount.
Hi Shareena
Here play with this
you select the part number using a drop down, you can type a few of the number to narrow your search in the drop down list:
for example, you type HK in the drop down then press the drop down arrow:
then press ctrl+alt+F5 to refresh the search screen
then it will show the stats related to the part number and the row its located in the inventory table
And yes, I'm saying no blank spaces. A table is a continuous table. It's a mistake to leave open rows. Here's a very good reference site: note what is said about tables and how to create them. https://exceljet.net/excel-tables
The second sentence under the first heading: " First, remove blank rows and make sure all columns have a unique name, then put....."
The mistake is to create a table that looks good to your human eye. This is data to be used, manipulated by the computer: in your case, the source data for an inquiry. Make the results of the inquiry look as pretty as you want. Keep the database itself, the table, just plain and fully functional. You're making it harder to deliver the important result you want, first by having the source data on separate spreadsheets and second by dividing them into sections when you have them on a single sheet.
- the bank sections are to add more parts. so you saying to not have the blank spaces?
