View Single Post
 
Old 01-27-2020, 04:55 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Try right-clicking the tab of the sheet you want to copy, choose Move or Copy…, then in the To book: field dropdown choose your destination workbook, choose where you want it to go relative the existing sheets in the destination workbook in the Before sheet: field, tick the Create a copy checkbox, click OK, then you can delete stuff you don't want in the copied sheet.
Before this operation, you can select multiple sheets (using the Ctrl key on the keyboard if they're not all next to each other, using the Shift key if they are, or a combination) to save the repetitive work.
Reply With Quote