Better formulas for selecting contractors

Copper Contributor

I am trying to find a more efficient way to start running my bid tab I use daily for number selection. We currently have a button that you select to select the bidder you want and then it will select them and their number for out main sheet, but it has been breaking quite a bit and telling us that the marcos are supported when I try to work on this in teams with my project team and has been causing errors. does anyone know of a more efficient and user friendly way to change this. 

amoulin2025_0-1682100742419.png

 

1 Reply
If it's a matter of selecting a bidder and then the data below is moved to another sheet, you could create a FILTER formula to pull the data. If you're able upload a sample then a formula can be drawn up.