Oct 03 2019 06:41 AM
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!!
Mar 13 2020 06:03 AM - edited Mar 13 2020 06:04 AM
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