Insert Row on Protected Sheet with Formulas/Formatting and Link to Other Worksheets

Question

I'm trying to create a workbook with several linked and locked worksheets.

Tab 1 is for the user to enter unlimited data. There are formulas and formatting applied to several columns. Tab 2 separates and quantifies all the data from Tab 1. Tabs 3-6 chart all the data from Tab 1.

I have the formulas and functions set up to modify Tabs 2-6 based on the filters the user applies on Tab 1.

My problems are: (1) I want to allow the user to insert rows that copies the formulas and formatting and (2) I would like the "quantity" tables and charts in the other tabs to also update based on the filters.

Currently, when I insert a row the formulas and formatting are not copied and when I enter the data, the following tabs are not updated, I'm assuming because those entire sheets are locked.

I hope I've explained this enough to understand. I have no experience with Macros and read several online forums that give examples, but they haven't worked for me.

Any assistance would be greatly appreciated!! Let me know if I must send the workbook for review.

Thanks in advance.

Answer 1

Hi Naysha,

When you protect a worksheet, all cells are locked by default, which means that the worksheet cannot be edited.

We suggest that you refer to this article: Lock or unlock specific areas of a protected worksheetfor more information on how to unlock specific cells and ranges in a protected worksheet.

To know how you can update the data in an existing chart and change the data source on the worksheet, you can refer to this article: Update the data in an existing chart.

Let us know if you need further help.