GottaBeKD182
New member
Hey everyone,
I have a rather large project that's been dropped in my lap and I'd like to see if there's a simpler way of doing it.
I have an Excel sheet with 1400+ lines of SKU's and pricing that I need to adjust. I need to find out the margin % of each one first, then adjust each one to the range I've been told to change them to. I've managed to properly find the margin % on the first line, so I know how to do it, but having to input this formula =(D2-C2)/D2*100 into each row, then changing the cell numbers for each line is of course remarkably tedious.
There HAS to be an easier way to do this. Does anyone know? I've attached a copy of the Excel file (minus SKU numbers and descriptions for privacy reasons) if that helps.
My sanity thanks you.
Kyle
I have a rather large project that's been dropped in my lap and I'd like to see if there's a simpler way of doing it.
I have an Excel sheet with 1400+ lines of SKU's and pricing that I need to adjust. I need to find out the margin % of each one first, then adjust each one to the range I've been told to change them to. I've managed to properly find the margin % on the first line, so I know how to do it, but having to input this formula =(D2-C2)/D2*100 into each row, then changing the cell numbers for each line is of course remarkably tedious.
There HAS to be an easier way to do this. Does anyone know? I've attached a copy of the Excel file (minus SKU numbers and descriptions for privacy reasons) if that helps.
My sanity thanks you.
Kyle