Home

Move or copy

%3CLINGO-SUB%20id%3D%22lingo-sub-302524%22%20slang%3D%22en-US%22%3EMove%20or%20copy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-302524%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BI%20want%20to%20be%20able%20to%20move%20or%20copy%20a%20sheet%20in%20a%20workbook%20to%20add%20a%20new%20sheet%2C%20but%20when%20I%20do%20this%20the%20sorting%20I%20have%20setup%20doesn't%20copy%20over.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-302524%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-302619%22%20slang%3D%22en-US%22%3ERe%3A%20Move%20or%20copy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-302619%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20very%20much%20for%20trying%20Damien.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20feeling%20it%20COULD%20be%20to%20do%20with%20different%20versions%20of%20Excel...%E2%80%A6.I'm%20still%20investigating.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-302593%22%20slang%3D%22en-US%22%3ERe%3A%20Move%20or%20copy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-302593%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F255033%22%20target%3D%22_blank%22%3E%40Julespeto%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20have%20the%20same%20issue%20when%20I%20simulate%20it%20on%20my%20end.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20a%20weird%20one%20all%20right%2C%20and%20I'm%20not%20sure%20how%20to%20advise%20you%20from%20here.%20Maybe%20another%20forum%20user%20has%20the%20answer%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20else%20know%3F%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-302591%22%20slang%3D%22en-US%22%3ERe%3A%20Move%20or%20copy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-302591%22%20slang%3D%22en-US%22%3E%3CP%3ESee%20I%20now%20have%20to%20setup%20the%20sorting%20again.....%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-302590%22%20slang%3D%22en-US%22%3ERe%3A%20Move%20or%20copy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-302590%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Damien%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20I%20have%20tried%20that%2C%20it%20copies%20over%20all%20the%20data%20but%20not%20the%20%22sorting%22%20I%20have%20setup%20in%20the%20original%20sheet....very%20strange.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-302586%22%20slang%3D%22en-US%22%3ERe%3A%20Move%20or%20copy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-302586%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F255033%22%20target%3D%22_blank%22%3E%40Julespeto%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20image.%20When%20you%20say%20%3CSTRONG%3EMove%2FCopy%3C%2FSTRONG%3E%2C%20are%20you%20copy%2Fcutting%20the%20data%20accross%20to%20a%20new%20sheet%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20yes%2C%20give%20this%20alternative%20method%20a%20go%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Right%20click%20onto%20the%20worksheet%20tab%20and%20click%20%3CSTRONG%3EMove%20or%20Copy%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20210px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F62910iB3D070E9A7C5B44F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22capture20181217160310832.png%22%20title%3D%22capture20181217160310832.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Select%3CSTRONG%3E%20Sheet1%20%3C%2FSTRONG%3E(or%20whatever%20it%20is%20called)%20in%20the%20list%20and%20tick%3CSTRONG%3E%20Create%20a%20copy%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20286px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F62911i8546DA6E2000584C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22capture20181217160319012.png%22%20title%3D%22capture20181217160319012.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3.%20Click%20OK.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20entire%20worksheet%20should%20be%20duplicated%20exactly%20as%20is.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20know%20how%20you%20go%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-302582%22%20slang%3D%22en-US%22%3ERe%3A%20Move%20or%20copy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-302582%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20just%20done%20a%20screenshot%20to%20show%20what%20I%20mean.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20move%2Fcopy%20to%20add%20a%20tab%20to%20my%20spreadsheet%2C%20I%20want%20these%20same%20sorting%20criteria%20to%20copy%20over%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-302581%22%20slang%3D%22en-US%22%3ERe%3A%20Move%20or%20copy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-302581%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Damien%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20response.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo%20my%20problem%20is%2C%20I%20have%20set%20up%20the%20first%20tab%20with%20sorting%20by%20column%2C%20then%20colour%20etc%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20try%20to%20move%2Fcopy%20to%20a%20new%20tab%20all%20the%20data%20in%20the%20sheet%20comes%20across%2C%20but%20the%20%22sort%22%20options%20I%20have%20setup%20in%20my%20first%20sheet%20are%20not%20coming%20across%20to%20the%20new%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20to%20copy%20the%20whole%20sheet%20and%20paste%20it%20to%20the%20new%20sheet%2C%20I've%20tried%20copying%20the%20sheet%20and%20then%20selecting%20%22paste%20format%22%20but%20none%20of%20these%20are%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20if%20that%20doesn't%20make%20a%20lot%20of%20sense.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EJulie%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-302538%22%20slang%3D%22en-US%22%3ERe%3A%20Move%20or%20copy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-302538%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F255033%22%20target%3D%22_blank%22%3E%40Julespeto%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20you%20are%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20want%20to%20clarify%20your%20scenario%2C%20do%20I%20understand%20you%20correctly%20that%20you%20want%20to%20make%20a%20copy%20of%20a%20sheet%20within%20a%20workbook%20but%20your%20data%20in%20the%20sheet%20you%20have%20copied%20becomes%20unsorted%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20moving%20or%20copying%20the%20sheet%2C%20it%20should%20be%20exactly%20as%20you%20have%20had%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20able%20to%20confirm%20if%20I%20have%20understood%20you%20correctly%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
Julespeto
Occasional Contributor

 I want to be able to move or copy a sheet in a workbook to add a new sheet, but when I do this the sorting I have setup doesn't copy over.

 

8 Replies

Hi @Julespeto

 

I hope you are well.

 

I just want to clarify your scenario, do I understand you correctly that you want to make a copy of a sheet within a workbook but your data in the sheet you have copied becomes unsorted?

 

When moving or copying the sheet, it should be exactly as you have had it. 

 

Are you able to confirm if I have understood you correctly?

 

Cheers

Damien

Hi Damien

Thank you for your response.

 

No my problem is, I have set up the first tab with sorting by column, then colour etc etc.

 

When I try to move/copy to a new tab all the data in the sheet comes across, but the "sort" options I have setup in my first sheet are not coming across to the new sheet.

 

I've tried to copy the whole sheet and paste it to the new sheet, I've tried copying the sheet and then selecting "paste format" but none of these are working.

 

Sorry if that doesn't make a lot of sense.

 

Regards

Julie

Highlighted

I've just done a screenshot to show what I mean.

 

When I move/copy to add a tab to my spreadsheet, I want these same sorting criteria to copy over as well.

Hi @Julespeto

 

Thanks for the image. When you say Move/Copy, are you copy/cutting the data accross to a new sheet?

 

If yes, give this alternative method a go:

 

1. Right click onto the worksheet tab and click Move or Copy.

 

capture20181217160310832.png

 

2. Select Sheet1 (or whatever it is called) in the list and tick Create a copy.

 

capture20181217160319012.png

 

3. Click OK.

 

Your entire worksheet should be duplicated exactly as is.

 

Let me know how you go?

 

Cheers

Damien

Hi Damien

 

Yes I have tried that, it copies over all the data but not the "sorting" I have setup in the original sheet....very strange. 

See I now have to setup the sorting again.....

Hi @Julespeto

 

I don't have the same issue when I simulate it on my end.

 

It's a weird one all right, and I'm not sure how to advise you from here. Maybe another forum user has the answer?

 

Does anyone else know???

 

Cheers

Damien

Thank you very much for trying Damien.

 

I have a feeling it COULD be to do with different versions of Excel...….I'm still investigating.

Related Conversations