Change List Selection VBA

Copper Contributor

Hi Folks!

 

A list of items is stored on one worksheet in a workbook. By selecting an option from a dropdown menu, the item may be copied to another sheet in the workbook. I need to be able to automatically change the selection in the dropdown on the initial worksheet. Can anyone help with this?

 

Thanks!!

1 Reply

Hey @Jecynta 

 

I'm not sure if i understand what you mean is correct. but try this, if it is because you want to change the content in the list, based on multiple Choice. 

https://www.youtube.com/watch?v=F264FpBDX28&t=79s

 

other wise, try a 3D formula if it based on the same cells spread out on multiple sheets.

 

Best Regards 

Julio César