denniswilburn
New Member
- Joined
- Mar 28, 2002
- Messages
- 1
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