Good Morning everyone,
I need to change Column A to add in more products, but im scared the other columns (See attached picture) will move up and down and my spreadsheet will be illustrating false values as these values are only specific to each product.
Basicailly- If I insert additional products in column A, the spreadsheet may become misformatted when I filter/sort it A-Z therefore giving false values.
Is there a way/formula to make sure the highlighted columns(See attached) always stay with the correct products in A?
Your help will be greatly appreciated.
Kind Regards.
Bookmarks