worksheets names

Hello Excel guru's!!! I need help in writing a macro to create a worksheet based on an entry in sheet named: Employee's. Within this sheet in Col. D4:d103 is a list of employee ID number. Upon an entry I need a sheet to be created with the employee ID number by copying the sheet named: Mater...

Hey! I'm having some issues with a macro to list all sheets with a workbook. The workbook is specified in another dropdown. I'm not sure how to reference another dropdown. I want the dropdown WorksheetsDD to populate once the workbook is specified in the dropdown WorkbooksDD. This is what I...

Hi guys, I've started a new role that requires me to fix the mess my predecessor created. My current assignment is to fix the formulas and formatting for over a thousand worksheets, spread across multiple workbooks. Each workbook represents a country e.g. 'England' and each worksheet in said...

Hello, I am trying to consolidate a spreadsheet with 45 worksheets. I want to copy all the data into one worksheet and call it master. I also need to copy the name of the worksheet next to the data in a separate column. I have three columns: 1) Recipient 2) Email Address 3) Comments the...

Hi there, I am looking for some VBA that can dynamically list all the names of the worksheets in a workbook (In Column A). i.e. If I add a worksheet the name appears, if i edit the name the name is edited on the list and if I delete a worksheet the names is removed. It doesn't need to be in...