Move or Copy Worksheet to Another or New Workbook and Keep Layout and Formatting in Excel

In this Microsoft Excel video tutorial I explain how to move or copy a worksheet to another workbook or to a new workbook whilst keeping the original layout and formatting.

#microsoftexcel #copy #worksheet #exceltutorial #exceltips

[jennifertrotter]

as I have to use the captions due to hearing problems I cant follow this video the captions cover the part at the bottom so I cant see it

[AnteBoss]

Hi Chester, not relevant to this video but I was wondering something about data validation - I need to lock certan cells when other cells have any value in them - so lets say A1 and A2, I must go to data validation and insert forumula (for A1) =A2="<>" - meaning if i input something in A1, and some value exist in A2, I get error. That is what I know. But the problem is that it only works when you have 2 cells. If I were to have cells A1, A2, A3, and if I were to put formula into cell A2 for data validation =A1;A3="<>" it would show me error that I can do it because data validation doesnt support "split ranges". I could have multiple cells in the first and the last because they dont break - =A1;A2;A3;A4="<> or range =A1:A4="<>" but not for the middle values. I hope you can solve this for me, if I even made sense of what I am trying to do.