vba search form adjustment_01

Hi,
Enter a single quote in front of your value and the cell will be treated as text.

Please verify that

• for cost centres the column that can have more than one item is 'items found in c/c'
• for price book the column that can have more than one item is 'Description'
• for recipes the column that can have more than one item is 'Item Description'

I just noticed that the 'Item Description' column in recipes has two problems:

1. Cells H4 to H8 have a drop-down, while the rest of the cells in that column don't. Do you want that drop-down in all the cells in that column?
2. The dropdown prevents the ability to add more than one item in the cell so that column cannot have more than one item (see the third bullet above)

hi martin, in reply to your comments;

for cost centres the column that can have more than one item is 'items found in c/c'

frank - column C & D can have multiple items
.

for price book the column that can have more than one item is 'Description'

frank - from column "I" onwards can have more than 1 result
.

for recipes the column that can have more than one item is 'Item Description'

frank - from column "E" onwards can have more than 1 result
.

Cells H4 to H8 have a drop-down, while the rest of the cells in that column don't. Do you want that drop-down in all the cells in that column?

frank - remove drop down option from this column for all cells
.
Can i copy & paste my previous version data of every wksht into this new one once you have completed it? can this be done by copying the entire sht from prev wkbk to new wkbk?

In price book

• Please verify that you mean "column "I" onwards" and not "column "E" onwards" or something else.
• What is the right-most column that can have data?
• The heading for column "I" is blank. Should it have a heading?

In recipes

• There is a drop-down in cells S4 to S12 but not in the rest of the column, Should I remove the drop-down?
• You say "from column "E" onwards...". Even columns like "M"?
• And are you saying that a single cell like F4 could contain more that one value?

hi martin,
*price book*
item 1 - yes, column "i" not "e"
item 2 - i dont understand your question, could you explain further
item 3 - the heading for column "i" is not blank its labelled as "CC"
.
*recipes*
item 1 - yes, remove drop down
item 2 - column "m" will only ever have 1 value per column "b" meaning that where there is data in column "b" then column "m" will only ever
               show 1 value in the last row before the next data in column "b"
item 3 - the only columns that will have more than 1 value in a single cell will be columns "t" to "y"

*price book*
Sorry for the confusion. I was looking at the wrong worksheet.

Try this.
29216197.xlsm

hi martin,
*price book*
- the search result shows the 2nd item 1st & the 1st item 2nd, can you show the result in the same sequence as shown in the wksht pls?
 
*recipes*
- the search result is showing 15 when there is only 4? remember that the search criteria should be looking up only from column 'b" and then only the rows contained within this recipe name. For example, the search for "brick" should only look up from column "b" then only search & display the rows contained within this recipe name therefore because there is only 1 recipe name with the the text "brick" it will only show results from rows 4:7, no other rows.
If there were 2 recipe names with the text "brick" then there would be 2 shown in the result in the same display sequence as the 1st.