ExcelBanter - How do I copy my dropdown box with data to another worksheet?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I copy my dropdown box with data to another worksheet? (https://www.excelbanter.com/excel-worksheet-functions/12583-how-do-i-copy-my-dropdown-box-data-another-worksheet.html)

Tess

How do I copy my dropdown box with data to another worksheet?

I have created a customer drop down list with company name, address, phone
numbers etc. Does anyone know how I copy that box to edit into other
connected worksheets to choose from?

All times are GMT +1. The time now is 02:35 AM.