Searchable data validation list problem

Lschuman

New Member
Joined
Oct 10, 2024
Messages
1
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
I have a workbook "Cost Calculator" in this workbook are worksheets "Tools" and "Consumables" each one of these worksheets contain a searchable list using data validation. In another worksheet, "Tool boxes", there is 24 groups each containing separate lists for tools and consumables. The groups are arranged on the worksheet 3 groups across and 8 groups down (see below). Each list searches the appropriate list in either the "Tools" or "Consumables" worksheet using Data Validation. The consumables side works fine. But the tools data validation only works in the 3 groups on the left side of the sheet, meaning nothing shows up in the data validation list. When I copy and paste any of the lists on the left side to any of the list spaces to the right the data validation does not show the list of choices. But, here's the kicker, If I copy one of the list that are on the right into the same column as the lists on the left side the data validation list works. Additionally, the Tools Data validation search works in another worksheet. I even tried setting up a different sheet for the tool boxes but have the same issue. Thanks

Group name1229.50 Group name24.50 Group name3#N/A
Tools 225.00Consumables4.50 Tools 0.00Consumables4.50 Tools 0.00Consumables#N/A
0.00Weed killer1.50 0.00Weed killer1.50 0.00Weed killer1.50
Lg Miter saw225.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00Weed eater head1.50 0.00Weed eater head1.50 0.00Weed eater head1.50
0.00 0.00 0.00 0.00 0.00 0.00
0.00weed eater string1.50 0.00weed eater string1.50 0.00weed eater string1.50
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 #N/A
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
Group name44.50 Group name56.00 Group name64.50
Tools 0.00Consumables4.50 Tools 0.00Consumables6.00 Tools 0.00Consumables4.50
0.00Weed killer1.50 0.00Weed killer1.50 0.00Weed killer1.50
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00Weed eater head1.50 0.00Weed eater head1.50 0.00Weed eater head1.50
0.00 0.00 0.00 0.00 0.00 0.00
0.00weed eater string1.50 0.00weed eater string1.50 0.00weed eater string1.50
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00Weed killer1.50 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00


t List List

Tools Cost Consumables Cost Tools Cost Consumables Cost Tools Cost Consumables Cost
List List List List List List

Tools Cost Consumables Cost Tools Cost Consumables Cost Tools Cost Consumables Cost
List List List List List List

Tools Cost Consumables Cost Tools Cost Consumables Cost Tools Cost Consumables Cost
List List List List List List

Tools Cost Consumables Cost Tools Cost Consumables Cost Tools Cost Consumables Cost
List List List List List List

Tools Cost Consumables Cost Tools Cost Consumables Cost Tools Cost Consumables Cost
List List List List List List
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Forum statistics

Threads
1,223,886
Messages
6,175,196
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top