Thanks bro I really appreciated I have been looking for this solution last 2 months and today I saw your movie and my work has completed. Very helpful video Thanks
Everybody has some intricate video on how to remove a password protected worksheet when all you need to do is copy and paste everything on to another sheet. Yours is the only video with a simple solution.
But how do you copy the same table and paste it below the original table (in the same sheet) with out changing formula cell references? That is what I am struggling with. What you showed is easy and straight forward.
Hi, I have sheet 1 which has formulas referencing sheet 2. How do I move both of them to another workbook without losing formulas and formatting. Thanks!
Very helpful, unfortunately I had a hard time understanding some of the things he said. Also a bit to fast for me, I have to take notes..I'm forgetful.
Previously I used the second method you showed to copy entire worksheet but now I am facing the problem after doing copy option marching ants line has despaired and while doing paste option message is shown that content are not of same size and shape so can paste any how, please help by giving solution.