Hello!
I'm working on an automatically updating sheet that uses a unique function from the main sheet of the workbook. This secondary sheet is to list everything unique in that category and to provide extra information that would be unneccesary on the main sheet. It's working great except for when a new category is added on the main sheet that causes the automated entries to shift while their corresponding cells with the extra information don't, causing the alignment to be incorrect. I looked into "freeze panes", but I think that is mainly for viewing purposes. The cells still need to be editable, but if there is any way to make the entire row shift together when one cell is automatically added to the column with the unique function, that would be wonderful.
I'm working on an automatically updating sheet that uses a unique function from the main sheet of the workbook. This secondary sheet is to list everything unique in that category and to provide extra information that would be unneccesary on the main sheet. It's working great except for when a new category is added on the main sheet that causes the automated entries to shift while their corresponding cells with the extra information don't, causing the alignment to be incorrect. I looked into "freeze panes", but I think that is mainly for viewing purposes. The cells still need to be editable, but if there is any way to make the entire row shift together when one cell is automatically added to the column with the unique function, that would be wonderful.