Copying data / worksheet to another workbook

trevolly

Board Regular
Joined
Aug 22, 2021
Messages
65
Office Version
  1. 365
Platform
  1. Windows
Hi all,

I am creating a new daily log workbook for my airport (thanks for all help so far). We have a Day and Night shift and we start a new log for each shift. I have designed a "handover" sheet giving the oncoming shift the relevant info they need about the airfield. On this "handover" sheet I have made some drop down lists (Data, Data Validation, List and then highlighting data from another sheet) to show the states of the airfield.

I want to be able to take this "handover" sheet from one shift and copy the sheet to the oncoming shifts workbook so they are aware of what is going on on the airfield. I made a button and macro command (right click on tab, move or copy, to book, create a copy) which does copy the handover sheet (and all its content) to a new workbook but it breaks the drop down menus. Does anyone have any ideas or other ways of achieving this?

I've attached a screenshot of the sheet

Can I just say thanks again (and I've actually enjoyed playing with excel!!)

Thanks all
 

Attachments

  • handover sheet.jpg
    handover sheet.jpg
    191.9 KB · Views: 8

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

trevolly

Board Regular
Joined
Aug 22, 2021
Messages
65
Office Version
  1. 365
Platform
  1. Windows
Sorry the screenshot didn't have the cells address shown
 

Attachments

  • handover2.jpg
    handover2.jpg
    214 KB · Views: 7

Forum statistics

Threads
1,148,423
Messages
5,746,596
Members
424,032
Latest member
pochie2741

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top