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
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
Group name1 | 229.50 | Group name2 | 4.50 | Group name3 | #N/A | |||||||||
Tools | 225.00 | Consumables | 4.50 | Tools | 0.00 | Consumables | 4.50 | Tools | 0.00 | Consumables | #N/A | |||
0.00 | Weed killer | 1.50 | 0.00 | Weed killer | 1.50 | 0.00 | Weed killer | 1.50 | ||||||
Lg Miter saw | 225.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 | Weed eater head | 1.50 | 0.00 | Weed eater head | 1.50 | 0.00 | Weed eater head | 1.50 | ||||||
0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||
0.00 | weed eater string | 1.50 | 0.00 | weed eater string | 1.50 | 0.00 | weed eater string | 1.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 name4 | 4.50 | Group name5 | 6.00 | Group name6 | 4.50 | |||||||||
Tools | 0.00 | Consumables | 4.50 | Tools | 0.00 | Consumables | 6.00 | Tools | 0.00 | Consumables | 4.50 | |||
0.00 | Weed killer | 1.50 | 0.00 | Weed killer | 1.50 | 0.00 | Weed killer | 1.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 | Weed eater head | 1.50 | 0.00 | Weed eater head | 1.50 | 0.00 | Weed eater head | 1.50 | ||||||
0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||
0.00 | weed eater string | 1.50 | 0.00 | weed eater string | 1.50 | 0.00 | weed eater string | 1.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 | Weed killer | 1.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