I have a large excel sheet that I use at work. I have lots of formulas so I protect the cells from being overwritten. Every month I have to transfer data from clients that use the same excel sheet. Now, here is my question. I want to copy their entire worksheet and paste everything into my worksheet without disrupting my locked cells. I keep getting the message that the worksheet is protected, etc... If I only grab the data (from their worksheet) that is not protected and copy and paste into mine then that would be long hours and tedious because about every 5th row and about every other cell is protected. How can I do this? Please help. Time is running out on a deadline. E-mail me if you would like to help and need to know more information. Thanks. denniswilburn@hotmail.com
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.